Hello!

I absolutely love Google Sheets + want everyone else to love it as much as I do and therefore I have decided to make a series of blog posts (with accompanying video) to help you learn how to use Google Sheets.

Will has kindly done the video for this one and therefore we are both in the thumbnail looking pretty cool if you ask me.

Watch the video below (click on the thumbnail) + you can follow along with the written instructions too!

GSheets-UsingImportRange (1)


Import Range

Import Range is one of those formulas that can be hard to do… yet gives you so many benefits when you know how to do it. When used with Google Forms, you can import specific data from the spreadsheet to another spreadsheet (or the same spreadsheet just another tab) which can be incredibly useful if you only want to see certain sections or questions at a glance.

Here is a step by step tutorial on how to use the formula (and what each part means):


STEP 1: SELECT THE CELL YOU WANT THE DATA TO GO INTO

This will be where all of the data will move to.

STEP 2: BEGIN THE FORMULA WITH AN ‘=’ 
=

You will start every almost every formula with this. The equals sign tells the spreadsheet that you’re about to start a formula.

STEP 3: TYPE IN ‘IMPORTRANGE’ 

=IMPORTRANGE

This tells the spreadsheet which formula you will be using and in this case it is import range. You may also notice a little box that pops up that will give you some information about what the specific formula does.

STEP 4: ADD AN OPEN BRACKET

=IMPORTRANGE(

By adding an open bracket, the spreadsheet knows there is more to come and you are welcoming the next piece of formula.

STEP 5: COPY AND PASTE THE SPREADSHEET URL OF THE SHEET YOU WANT TO TAKE INFORMATION FROM

spreadsheeturl

Be careful at this point because there is a specific part you will need to copy and that is the only part you need. It is the URL from ‘spreadsheets/d/’ to the next forward slash. An easy way to remember is to copy the URL between each forward slash.

STEP 6: PASTE THAT URL INTO YOUR FORMULA IN BETWEEN TWO SPEECH MARKS

paste spreadsheet url.gif

I have used control V here to paste, but you can just right click and paste the URL. Don’t forget to ‘sandwich’ them in speech marks so the spreadsheet knows where they need to collect the URL from.

STEP 7: SELECT YOUR SHEET AND CELL RANGE

sheet select and cell range.gif

This will be where you take the information from another sheet and the cell range. I have used a sheet within the document so I just use Sheet2 and I have selected the cell range plus a few cells around to show you can import more than one cell.

STEP 8: FINISH WITH A SPEECH MARK AND A CLOSE BRACKET

last part.gif

I do apologise for the gif on this one. It was supposed to just be me showing to get rid of that irritating close bracket that appeared and then closing it with a speech mark and a close bracket – I will fix it as soon as I get back to my PC.

You end with a speech mark to confirm the sheet selection and cell range, and then close it all up with a close bracket to close in where your open bracket opened it at the beginning. Finish off by triumphantly pressing ‘Enter’ on your keyboard and voila, your selected cell should appear where you did the formula.


Please let me know if you found this tutorial helpful, it was too confusing or you need some help. I am always available here or on my Twitter @CharlieLecuyer9

Thanks for reading!