Pull Data From Another Spreadsheet With IMPORTRANGE

Excel & Google Sheets

How it works

IMPORTRANGE is Google Sheets only: paste the source file's URL as the first argument, and the sheet-and-range — the whole thing in one quoted string, "Orders!A1:D20" — as the second, and the block spills into your report and keeps updating as the source changes. The first time you connect two files, the cell shows #REF! with an Allow access button: click it once and the grant is permanent for that source-and-destination pair (you need at least view permission on the source, and every user grants for themselves). Excel's equivalent is a direct cross-workbook reference like ='[Workbook.xlsx]Orders'!A1, which pulls a cell from another workbook — fine for a value or two, but for importing whole tables the robust Excel route is Power Query (Data > Get Data), a menu-driven feature rather than a formula.

"spreadsheet_url"

The full URL of the source file, in quotes — copy it straight from the browser address bar.

"Orders!A1:D20"

Sheet name and range as one quoted string. Leave off the sheet name to use the first sheet.

When to use it

Use it to feed a reporting file from a team's working file: orders into a revenue dashboard, project status into a client summary, invoice lists into a finance rollup — the source team keeps editing, your report stays current.

Common mistakes

• ✕Stuck on #REF! — the permission loop.

  ✓Click the cell and press Allow access. If no button appears, you don't have view permission on the source file — access is granted per user, so every viewer of the report needs it.

• ✕Forgetting the quotes around the range.

  ✓=IMPORTRANGE(url,Orders!A1:D20) fails — the second argument is one text string. Write it as "Orders!A1:D20", quotes included.

• ✕Data already sitting where the import needs to land.

  ✓IMPORTRANGE spills the whole block; anything in the way triggers a #REF! "result was not expanded" error. Give it an empty area and don't type into the imported cells — they're read-only.