Table of Contents
IMPORTRANGE can be used within the same spreadsheet to import data from another sheet within the same spreadsheet. This allows for the same data to be accessed in more than one sheet, without having to manually copy and paste the data into the other sheet. This is useful for having multiple views of the same data set and can help make working with large datasets easier.
You can use the IMPORTRANGE function in Google Sheets to import data from another spreadsheet.
However, if you would like to import data from one sheet to another sheet within the same workbook, there is no need to use the IMPORTRANGE function.
Instead, it’s much easier to use the QUERY function.
For example, you can use the following syntax to import the cells in the range B1:B9 from a sheet called assists into your current sheet:
=QUERY(assists!B1:B9)
This is much more efficient than using the IMPORTRANGE function and typing out the URL where the sheet is located just to import the data.
The following example shows how to use this syntax in practice.
Example: Using QUERY to Import Data from One Sheet into Another Sheet
Suppose we have the following sheet called points that contains information about the points scored by basketball players on various teams:
And suppose we have another sheet within the same workbook called assists that contains information about the assists made by the same basketball players:
We can type the following formula into cell C1 of the points sheet to import the values in the range B1:B9 from the assists sheet:
=QUERY(assists!B1:B9)
The following screenshot shows how to use this syntax in practice:
Notice that we’re able to successfully import the values from B1:B9 in the assists sheet into the points sheet by using the QUERY function.