AI & automationField note

How to use IMPORTRANGE in Google Sheets

Pull a reliable range from another spreadsheet, grant access once and combine it with QUERY without creating a fragile chain.

PhilisWritten by PhilisPublished July 18, 2026Last updated July 27, 20269 min
Connect two Sheets with IMPORTRANGE — SheetSteps
QUICK ANSWER

Use =IMPORTRANGE(spreadsheet_url, "Sheet name!A1:D100"). The first connection returns #REF! until you click Allow access. Import only the bounded range you need.

IMPORTRANGE lets one spreadsheet read cells from another. It is useful for team reports, consolidated dashboards and separating source data from presentation.

It is not a database sync. Long chains, entire-column imports and dozens of separate formulas can make a workbook slow and difficult to trace.

Regional rollup spreadsheet used in this article
A working sheet built for this article. The numbers are sample data.
01
INSTRUCTIONS

How to use IMPORTRANGE in Google Sheets

  1. 01
    Copy the source URL

    Open the source spreadsheet and copy its URL or spreadsheet ID.

  2. 02
    Choose a bounded range

    Write the exact source tab and cells, including quotes around tab names with spaces.

  3. 03
    Enter IMPORTRANGE

    Put the URL or a cell reference first and the range string second.

  4. 04
    Allow access

    Click the #REF! cell and approve the connection when prompted.

  5. 05
    Check source permissions

    The account authorizing the formula must be able to open the source file.

  6. 06
    Transform once

    Import a clean block, then use QUERY or FILTER around that result rather than repeating many calls.

02
AI & AUTOMATION

Write the range string correctly

The range string contains the source tab name, an exclamation mark and the A1 range. Put the whole string in quotes.

If the tab name contains spaces, wrap it in single quotes inside the string.

fx=IMPORTRANGE(A2,"'Sales Data'!A1:D500")
03
AI & AUTOMATION

Fix #REF! and permission errors

A new source-destination pair needs permission. Hover over the #REF! result and click Allow access. If the button does not appear, confirm you can open the source while signed into the same Google account.

A renamed or deleted source tab also produces an error. Update the range string to the current tab name.

04
AI & AUTOMATION

Keep imported models fast

Avoid A:Z or entire-column imports when the source has many rows. Choose a reasonable bound and extend it deliberately.

If several tabs need the same source, import it once into a staging tab and reference that local range elsewhere.

05
COMMON QUESTIONS

Questions people ask

Does IMPORTRANGE update automatically?＋

Yes, but not instantly. Google refreshes imported entries on its own schedule, and large dependency chains may update slowly.

Can I import only matching rows?＋

Yes. Wrap IMPORTRANGE with QUERY or FILTER, but import a stable rectangular range first.

Why is IMPORTRANGE slow?＋

Large ranges, many separate formulas and chains where one imported file depends on another are the usual causes.

READ NEXT

More from SheetSteps