IMPORTRANGE Formula Generator
IMPORTRANGE pulls live data from another Google Sheets file into the current one. Sheets-only. Requires a one-time authorization the first time you connect two files.
Syntax
=IMPORTRANGE(spreadsheet_url_or_key, range_string)Try it — generate a IMPORTRANGE formula
Examples
Pull a sheet by full URL
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1abc.../edit", "Sheet1!A1:D100")Brings columns A:D from Sheet1 of the referenced file.
Pull using spreadsheet key only
=IMPORTRANGE("1abc...", "Data!A:Z")Key between /d/ and /edit in the URL.
Combine with QUERY
=QUERY(IMPORTRANGE("1abc...", "Sheet1!A:D"), "select Col1, Col3 where Col2='Active'")Filter imported data with QUERY on top.
Tips
- ✓First use triggers an "Allow access" popup — click it to authorize the connection.
- ✓Range string is ALWAYS a string: "Sheet1!A:D", never raw refs.
- ✓If source doc changes access, IMPORTRANGE breaks with #REF!.
Related Formulas
QUERY
QUERY is Google Sheets' most powerful function. It lets you use SQL-like syntax ...
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
ARRAYFORMULA
ARRAYFORMULA applies a formula to an entire column or range at once, eliminating...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free