Google Sheets function
IMPORTRANGE function in Google Sheets
IMPORTRANGE in Google Sheets imports a cell range from another Google Sheets spreadsheet. The source URL identifies the spreadsheet, and the range string names the sheet and cells. Use it to reference shared source data without copying values by hand.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=IMPORTRANGE(spreadsheet_url, range_string)Arguments
| Argument | Required | What it means |
|---|---|---|
spreadsheet_url | Yes | The URL of the spreadsheet containing the source range. |
range_string | Yes | The source sheet name and range, written as a string. |
Examples
Import an order table
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Amount | Source spreadsheet | |
| 2 | A-1 | 40 | https://docs.google.com/spreadsheets/d/abc123 | |
| 3 | A-2 | 65 |
=IMPORTRANGE(D2,"Orders!A1:B3")Result: Order | Amount; A-1 | 40; A-2 | 65
After access is granted, IMPORTRANGE returns the three rows from the Orders range in the source spreadsheet.
Common mistakes
Omitting the source sheet name from the range string.
Write the range as a string such as "Orders!A1:B3".
Expecting a first connection to work before access is granted.
Select Allow access when Sheets asks to connect the two spreadsheets.