How to use IMPORTRANGE in Google Sheets

IMPORTRANGE lets you pull data from one Google Sheet into another. It is perfect for building dashboards and keeping source data clean.

1. Basic syntax

=IMPORTRANGE("spreadsheet_url", "Sheet1!A1:D100")

• spreadsheet_url is the full URL of the source spreadsheet.
• Sheet1!A1:D100 is the range you want to import.

2. Authorize access (first time only)

The first time you use IMPORTRANGE, Sheets shows #REF! with an Allow Access button. Click it once and you are done.

3. Import with named ranges

Named ranges are easier to read and maintain:

=IMPORTRANGE("spreadsheet_url", "sales_last_90_days")

4. Common errors and fixes

• #REF! and no button: Check you used the full URL, not just the ID.
• #VALUE!: The sheet name or range is wrong.
• Slow performance: Import smaller ranges or use helper tabs to limit data.

5. Pro tips

• Use QUERY on top of IMPORTRANGE to filter or aggregate.
• Use ARRAYFORMULA to keep calculations dynamic.

If you want, I can set up a template that uses IMPORTRANGE plus clean visuals for reporting.