Pulling Data With IMPORTRANGE
Reference data from another Google Sheets file.
Linking Spreadsheets
Sometimes the data you need lives in a different Google Sheets file: a master list someone else maintains, or last month's report. IMPORTRANGE pulls that data into your current sheet, live.
When the source updates, your sheet updates too. It is the backbone of multi-file dashboards in Google Sheets, and like QUERY it is Sheets-only.
The Two Arguments
IMPORTRANGE needs two things:
- spreadsheet_url the link or key of the source file, in quotes
- range_string the sheet and range to pull, like
'Sheet1'!A1:D10, also in quotes
Both arguments are text strings, so both go in double quotes.
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/ABC123", "Sheet1!A1:D10")All lessons in this course
- Querying Data With QUERY
- Sorting and Grouping in QUERY
- Applying Formulas to Columns With ARRAYFORMULA
- Pulling Data With IMPORTRANGE