Google Sheets is an extremely convenient tool from Google to maintain your records in a spreadsheet format and is used by millions of users across the globe. It is fitting, reliable, and easily accessible by many at the same time. You can create as many sheets as you want according to the purpose of your business and it won’t disappoint you. However, there might arise a situation in which you need to import data from one sheet to another multiple times.
One easy way is to simply copy the data from one sheet and paste it to another but it is not a feasible way to conduct, since you might need to perform the same action multiple times or the size of data might be humungous to handle. Thus we make use of theIMPORTRANGE() function.
In the following article, we will discuss how to implement the IMPORTRANGE() function and insert data from one sheet to another.
Importing a Cell from One Sheet to Another
In order to import cell data from one sheet to another, first select the cell position where you want to import the data and then type =IMPORTRANCE( in that cell.
After that, visit the sheet from where you want to import the data and copy that sheet’s ID number from the browser address bar as shown below.
Now paste the id number inside the IMPORTRANGE() function within double inverted commas.
Once done with that, add the name of the sheet (label) from which you want to import data inside double inverted commas separated by a comma. And after the label insert an exclamation mark too.
💡 Tip
The sheet label of a sheet is mentioned at the bottom of the window just below the slider. By default, it is labeled as ‘Sheet1’. It will be good practice to rename it by right-clicking on it to avoid confusion.
After the exclamation mark, type the cell number from where you want to import data. In this case, the cell number is ‘B8’. Then close the double inverted comma and the circular bracket and press ‘Enter’.
You may encounter an error (like the one seen below) after adding the IMPORTRANGE() function.
To resolve this issue, click on the error. A dialogue box will appear asking for access to the other sheet. So simply click on the ‘Allow access’ button and Google will get access to that sheet.
As soon as you grant access, the data will appear in the desired position.
Importing Column from One Sheet to Another
The entire procedure is similar except for the cell address. Here, instead of mentioning a single cell address, you need to mention the range of the entire column whose data you want to import. To mention the range, after the exclamation mark, type the cell address of the first cell and then of the last cell of the column separated by a colon.
Close the double inverted comma and the circular bracket and press ‘Enter’. This will import the entire column to the desired location.
Importing Entire Table from one Sheet to Another
In this scenario as well, you only need to change the range. Insert the cell address of the first cell of the table and the last cell of the table. Separate them with a colon and close the inverted comma and the circular bracket.
Once you press ‘Enter’, the entire table will be inserted at the desired location.
This technique is extremely efficient and will reflect the changes made to the main data in imported data as well. Thus it saves you from the hassle of making edits in both the sheets.
Member discussion