Formula guide · Google Sheets · Updated May 13, 2026
IMPORTRANGE Not Working in Google Sheets
Fix IMPORTRANGE errors caused by permissions, wrong URLs, bad range names, or delayed loading.
Quick Answer
Most IMPORTRANGE problems come from missing access permission, an incorrect spreadsheet URL, or a range name that does not match the source sheet.
Copyable Formula
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/example","Orders!A:D")Syntax
=IMPORTRANGE("spreadsheet_url","Sheet1!A:D")Google Sheets
Worked Example
| Symptom | Likely fix |
|---|---|
| #REF! | Allow access |
| No data | Check sheet name and range |
| Loading | Wait or reduce imported range |
Result: Once permission and the range reference are correct, the imported rows appear in the destination sheet.
Steps
- Confirm the source spreadsheet URL is correct.
- Check the source tab name and range.
- Click Allow access when Google Sheets asks for permission.
- Import only the columns you need when the source is large.
Common Mistakes
- Changing the source sheet name without updating IMPORTRANGE.
- Importing entire sheets when a smaller range would be faster.
- Stacking many IMPORTRANGE formulas across one file and slowing the workbook.
Excel vs Google Sheets Notes
This page is focused on Google Sheets. Excel may require a different function, pivot table, or Power Query workflow.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.