IMPORTRANGE copies a range from one Google Sheets file into another. It has two arguments, and both must be text: the file’s URL or ID, and the range, including the sheet name:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/FILE_ID/edit", "Sales 2026!A1:C100")
When it fails, the message under the error tells you which part is wrong. Below are the messages we got in Google Sheets and what fixed each one.
Tested in Google Sheets. On November 11, 2026 we tried correct and broken IMPORTRANGE formulas, imports of up to 18,000 large cells and imports blocked by other data, and copied every message. Where we could not reproduce something, this page says so. How we test
Find your error
| What you see | Cause |
|---|---|
| #ERROR!, Formula parse error. or #REF!, Unresolved sheet name | 1. Missing quotes |
| #REF!, You need to connect these sheets or Please use a desktop web browser to connect this sheet. | 2. The files are not connected yet |
| #REF!, Spreadsheet cannot be found. | 3. Wrong URL or ID, or no access |
| #REF!, Function IMPORTRANGE parameter 1 value is ‘…’. It is not a valid cell/range reference. | 4. Wrong sheet name or range |
| #REF!, Array result was not expanded because it would overwrite data in … | 5. No room for the result |
| Result too large | 6. Too much data in one import |
| Loading… or old data | 7. Too many imports, or a refresh delay |
1. Formula parse error: missing quotes
Both arguments are text, so both need straight double quotes. What you get without them depends on what you typed:
=IMPORTRANGE(FILE_ID, "A1"): an ID without quotes gave Formula parse error.=IMPORTRANGE("FILE_ID", Week 5!A1): a range without quotes whose sheet name has a space also gave Formula parse error.=IMPORTRANGE("FILE_ID", Sheet1!A1): a range without quotes and without spaces is read as a reference to your own file. If that tab doesn’t exist there, you get #REF! with Unresolved sheet name ‘Sheet1’. instead of a parse error.
Two other common culprits are curly quotes (“ ”) copied from a document and commas in a spreadsheet that uses semicolons, such as one set to Spain or Germany. Paste your formula into our formula checker to spot both, and see the full list in Formula parse error: 9 causes.
You can also keep the URL and the range in cells and point to them: =IMPORTRANGE(H1, H2) worked in our test, and it makes long URLs easier to check.
2. #REF!: the files are not connected yet
The first time a file imports from another one, Google Sheets asks for permission. Until someone grants it, IMPORTRANGE returns #REF!. According to Google’s help page, the error shows You need to connect these sheets with an Allow access button, which can take a few seconds to appear after you type the formula.
When we created the formula through Google’s API instead of the browser, the #REF! said Please use a desktop web browser to connect this sheet. The fix is the same: open the destination file in a desktop browser, click the cell and press Allow access.
- If you don’t own the source file, you need access to it first. Open its URL and request access from the owner.
- Google notes that once access is granted, any editor of the destination file can import any part of the source, and the access lasts until the person who granted it loses access to the source.
- If downloading, printing and copying are turned off in the source file’s sharing settings, Google says new IMPORTRANGE formulas can’t import from it, while existing ones keep working.
Importing from the same file needs no permission: in our tests IMPORTRANGE pointing at its own spreadsheet worked straight away.
3. #REF!: Spreadsheet cannot be found
An ID that doesn’t exist returned Spreadsheet cannot be found. Copy the URL again from the browser’s address bar. You can use the whole URL or just the ID, the long code between /d/ and /edit. Both worked in our test, and so did a URL with #gid=… at the end, which IMPORTRANGE ignores when the range includes a sheet name.
4. #REF!: wrong sheet name or range
A sheet name that doesn’t exist in the source file returned Function IMPORTRANGE parameter 1 value is ‘Week5!A1’. It is not a valid cell/range reference. Note that the message says parameter 1 even though the range is the second argument, so don’t let it send you to check the URL.
Fix: copy the tab name exactly, spaces included. A name with a space worked both with and without apostrophes in our tests ("Week 5!A1:C3" and "'Week 5'!A1:C3"), but using apostrophes is the safe habit.
Found in testing: always include the sheet name. Google’s help page says it is optional, but when we left it out of an import from the same file ("A1:C2"), IMPORTRANGE took the cells from the tab that contained the formula, not from the first tab of the file. Without the name, it is not obvious which tab you are reading.
5. #REF!: no room for the result
IMPORTRANGE spills its result over as many cells as the range has. With a value already typed in one of those cells, it returned Array result was not expanded because it would overwrite data in O84, naming the blocking cell. Clear that cell or move the formula to an empty area.
6. Result too large
Google’s help page says each IMPORTRANGE request is capped at 10 MB of received data. We could not reproduce the “Result too large” error ourselves: importing from the same file, 18,000 cells of about 2,000 characters each (roughly 36 MB of text) arrived without an error. The limit may only apply between different files, which we did not test with that much data.
If you get the error, these are the ways to send less data per request:
- Import only the range you need.
"Data!A1:F5000"instead of"Data!A:Z", and only the columns you use. - Split the import into blocks and stack them with VSTACK. This combined two imports of 1,500 rows into one result of 3,000 rows in our test:
=VSTACK(IMPORTRANGE("FILE_ID", "Data!A1:F1500"), IMPORTRANGE("FILE_ID", "Data!A1501:F3000")) - Delete empty rows and columns at the end of the source sheet if you import whole columns.
7. Loading… or data that doesn’t update
According to Google’s help page:
- a change in the source refreshes the open files that import from it, and IMPORTRANGE also checks for updates every hour while the file is open;
- there is a delay between the change in the source and the update, and it gets longer when files import from files that import from other files;
- when there is too much import traffic, cells show Loading… with the message Loading data may take a while because of the large number of requests;
- import functions can’t reference a cell that uses NOW, RAND or RANDBETWEEN, directly or indirectly. Google’s suggested fix is to copy those results and paste them as values.
What to do: reduce the number of IMPORTRANGE formulas. One import of a block of cells is lighter than many single-cell imports, and you can work on the result with QUERY or FILTER. Avoid long chains of files importing from each other. We did not reproduce the NOW restriction within a single file: an import of a cell containing NOW() returned the date and time. Google’s rule may only apply between files.