Pulling Data With IMPORTRANGE

Sometimes the data you need lives in a different Google Sheets file: a master list someone else maintains, or last month's report. IMPORTRANGE pulls that data into your current sheet, live.

When the source updates, your sheet updates too. It is the backbone of multi-file dashboards in Google Sheets, and like QUERY it is Sheets-only.

IMPORTRANGE needs two things:

• spreadsheet_url the link or key of the source file, in quotes
• range_string the sheet and range to pull, like 'Sheet1'!A1:D10, also in quotes

Both arguments are text strings, so both go in double quotes.

Instead of the full URL you can use just the key, the long ID in the middle of the link. Both work identically.

The key is the part between /d/ and the next slash in a Sheets URL. Using the key keeps formulas shorter and tidier.

The first time you reference a new file, IMPORTRANGE shows a #REF! error with the message You need to connect these sheets.

Hover the cell and click Allow access. This one-time grant links the two files. After approving, the data flows in. This is a security feature, not a bug.

IMPORTRANGE returns an array, so it spills across multiple cells starting where you put it. Place it in an empty area with room to expand.

If cells below or to the right are occupied, you will get a spill or #REF! error. Give it space, like a fresh corner of a tab.

You do not have to import a whole table. Narrow the range string to bring in exactly what you need, such as one column.

This pulls only the names from column A of the source. Smaller imports keep your sheet fast and focused.

IMPORTRANGE pulls everything in the range, but you can wrap it in QUERY to filter at the same time. The imported array becomes QUERY's data argument.

Note that inside QUERY you reference imported columns as Col1, Col2, and so on, not by letter.

This is the key gotcha when combining the two functions. Because the data comes from a formula and not a real range, QUERY cannot see sheet letters.

So A becomes Col1, B becomes Col2, counting from the first imported column. Remember this and the combo works smoothly.

Imported data refreshes automatically, roughly every hour or when the file is opened or edited. It is live but not instant to the second.

Many large IMPORTRANGE calls can slow a sheet. Import only the ranges you need, and consider one import feeding several formulas rather than many separate imports.

Watch for these:

• #REF! with connect sheets means you still need to click Allow access
• #REF! from a spill means the landing area is not empty
• #ERROR! often means the range string has bad quotes or a wrong sheet name

Double-check the sheet name exactly matches the source tab.

A common setup: one tab holds a single IMPORTRANGE that mirrors a source table. Other tabs and formulas then reference that local mirror, not the import directly.

This keeps permissions in one place, speeds things up, and makes your formulas reference simple ranges like Import!A:D instead of long URLs.

Check your IMPORTRANGE understanding.

You can now pull data across files:

• IMPORTRANGE(url_or_key, range_string) imports live data
• The first use needs a one-time Allow access click
• Results spill, so give them empty space
• Wrap in QUERY to filter, using Col1, Col2 names
• Import only what you need and mirror it once for speed

That completes the Google Sheets QUERY and ARRAYFORMULA toolkit.