How to Use IMPORTRANGE in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Intermediate · 7 min read · includes 2 free exercises

In short: IMPORTRANGE pulls a range of cells from another spreadsheet into this one. The formula is =IMPORTRANGE(spreadsheet_url, range_string). The first time you use a new source, you must click Allow access.

What IMPORTRANGE does

IMPORTRANGE connects two spreadsheets. You keep the data in one file and show it in another, and the copy updates when the source changes. People use it to build a summary file from several team sheets, or to share part of a sheet without sharing the whole file.

IMPORTRANGE syntax

=IMPORTRANGE(spreadsheet_url, range_string)

A step-by-step example

Suppose the source spreadsheet has the URL https://docs.google.com/spreadsheets/d/abc123/edit and you want cells A1 to C10 of the sheet named Sheet1. In the destination spreadsheet, type:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123/edit", "Sheet1!A1:C10")

(The URL above is a made-up example. Use the address of your own source file.) Here is what happens:

  1. Sheets opens the source spreadsheet.
  2. It reads A1:C10 on the sheet named Sheet1.
  3. It writes those 30 cells into your sheet, starting at the cell with the formula.

Allow access the first time

The first time a sheet pulls from a new source, Sheets shows a #REF! error. If you own the source, point at the cell and click Allow access. If you do not own it, you need to request access and wait for the owner to approve. After access is granted, any editor of the destination spreadsheet can import from that source.

Keep the URL and range in cells

You can store the URL and the range text in cells, so they are easy to change:

A
1https://docs.google.com/spreadsheets/d/abc123/edit
2Sheet1!A1:C10

With the URL in A1 and the range in A2, the formula becomes:

=IMPORTRANGE(A1, A2)

Common IMPORTRANGE problems

Try it yourself

Type your formula into the box, starting with =, then press Check. The exercises check the formula text; they do not connect to a real spreadsheet.

Exercise 1: Import a range

Write a formula that imports cells A1:C10 of the sheet named Sheet1 from the spreadsheet at https://docs.google.com/spreadsheets/d/abc123/edit.

Hint: the first argument is the URL in quotation marks, the second is "Sheet1!A1:C10".

Exercise 2: Use cell references

The URL is in cell A1 and the range text is in cell A2. Write the IMPORTRANGE formula that uses those two cells.

Hint: no quotation marks are needed when you point at cells.

What to learn next

Syntax and rules in this guide were checked against Google's IMPORTRANGE help page. See all guides.