FormulaCraft

IMPORTRANGE (cross-sheet)

IMPORTRANGE pulls live data from one Google Sheet into another. Setup, gotchas, and the common combinations with QUERY and VLOOKUP.

4 pages · 1 reference, 1 how-to, 2 error fix

Reference

IMPORTRANGE

Imports a cell range from another Google Sheets spreadsheet using its URL and range string.

How-to guides

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.

Excel ≠ Sheets

Error fixes

Fix #REF!

IMPORTRANGE showing #REF! in Google Sheets means access has not been granted. Click the cell and allow access to fix it.

Fix IMPORTRANGE

IMPORTRANGE not working in Google Sheets? Fix wrong URLs, sheet name typos, range errors, and access issues step by step.