0
0
Google Sheetsspreadsheet~10 mins

IMPORTRANGE for other spreadsheets in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This is the source spreadsheet data with product names and their prices.

CellValue
A1Product
B1Price
A2Apple
B21.2
A3Banana
B30.8
A4Cherry
B42.5
Formula Trace
=IMPORTRANGE("1a2b3c4d5e6f7g8h9i0jklmnopqrstuv", "Sheet1!A2:B4")
Step 1: IMPORTRANGE("1a2b3c4d5e6f7g8h9i0jklmnopqrstuv", "Sheet1!A2:B4")
Cell Reference Map
Current Sheet:
+----+-------+-------+
|    |   A   |   B   |
+----+-------+-------+
| 1  |       |       |
| 2  |       |       |
| 3  |       |       |
| 4  |       |       |
+----+-------+-------+

Source Sheet (ID: 1a2b3c4d5e6f7g8h9i0jklmnopqrstuv):
+----+---------+-------+
|    |    A    |   B   |
+----+---------+-------+
| 1  | Product | Price |
| 2  | Apple   | 1.20  |
| 3  | Banana  | 0.80  |
| 4  | Cherry  | 2.50  |
+----+---------+-------+
The formula imports data from the source spreadsheet's Sheet1 range A2:B4 into the current sheet.
Result
+----+--------+-------+
|    |   A    |   B   |
+----+--------+-------+
| 1  | Apple  | 1.20  |
| 2  | Banana | 0.80  |
| 3  | Cherry | 2.50  |
+----+--------+-------+
The imported data appears in the current sheet starting at the cell where the formula is entered, showing the product names and prices.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the first argument in IMPORTRANGE represent?
AThe name of the sheet in the current spreadsheet
BThe unique ID of the source spreadsheet
CThe range of cells to import
DThe formula to calculate prices
Key Result
IMPORTRANGE("spreadsheet_id", "sheet_name!range") imports data from another spreadsheet by ID and range.