Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
IMPORTRANGE
IMPORTRANGE lets you pull live data from a different Google Sheets file into the current sheet by specifying the source spreadsheet's URL and the range you want. The data updates automatically when the source changes, making it ideal for consolidating data from multiple sheets without copying and pasting.
Topic:IMPORTRANGE (cross-sheet)Excel
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/SPREADSHEET_ID","Sheet1!A1:C10")Google Sheets
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/SPREADSHEET_ID","Sheet1!A1:C10")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Copy the full URL of the source Google Sheet from your browser's address bar.
- 2Enter =IMPORTRANGE("<URL>","<SheetName!Range>") — on first use, click 'Allow access' when prompted.
- 3The imported range spills into the sheet automatically; any edits to the source file update the import within minutes.
Need a version for your data?
Try: “Pull data from another Google Sheets file into my current spreadsheet”
More on IMPORTRANGE (cross-sheet)
See all →How-to
How to use IMPORTRANGE from another spreadsheet
Pull live data from a different Google Sheets file using IMPORTRANGE, or replicate the pattern in Excel with Power Query.
Error fixFix #REF!
IMPORTRANGE showing #REF! in Google Sheets means access has not been granted. Click the cell and allow access to fix it.
Error fixFix IMPORTRANGE
IMPORTRANGE not working in Google Sheets? Fix wrong URLs, sheet name typos, range errors, and access issues step by step.