To use IMPORTRANGE in Google Sheets, enter a formula containing the source spreadsheet’s URL and cell range in an empty destination cell, press Enter, then click Allow access. The selected data expands into neighboring cells, so leave enough empty space for the result.
Open both spreadsheets on a computer using a Google Account that can access the source file. You also need editing permission in the destination spreadsheet.
The short version
- Basic setup: Enter the source URL and range in an IMPORTRANGE formula in an empty destination cell.
- First connection: Click Allow access when the initial connection prompt appears.
- Range choice: Import specific cells, rows, columns, a named range, or a table reference.
- Updates: Imports need internet access, and changes do not synchronize instantly.
| Task | Approach |
|---|---|
| Connect two spreadsheets | Enter IMPORTRANGE and authorize the connection |
| Keep source details editable | Supply the URL and range through cells |
| Choose cells, rows, or columns | Use an A1 range reference |
| Import a named selection | Reference a source named range |
| Import table data | Use a table or table column reference |
| Use local argument separators | Replace commas with semicolons where required |
| Adjust language or locale | Review spreadsheet settings |
| Keep several imports separate | Give each formula an empty output area |
| Combine imports with an array | Stack results or place them side by side |
| Stack imports with a function | Use VSTACK |
| Select, filter, or sort columns | Wrap the import in QUERY |
| Filter a local imported range | Use FILTER with a helper tab |
| Generate a formula | Ask Gemini with an eligible account |
| Fix missing source permission | Request access from the source owner |
| Start from a mobile device | Complete setup on a computer |
| Prepare an Excel source | Convert it to Google Sheets |
| Trigger an import reload | Re-enter the import formula |
| Check spreadsheet calculation | Review automatic or manual calculation |
| Fix volatile source dependencies | Replace affected source formulas with values |
| Keep a fixed copy | Paste the imported output as values |
| Check copying restrictions | Have the source owner review permitted roles |
| Revoke an authorized connection | Remove the authorizing user’s source access |
| Resolve external sharing restrictions | Have an administrator review sharing policy |
| Resolve trust rule restrictions | Have an administrator review Drive trust rules |
Connect your source and destination spreadsheets
Open the source spreadsheet and copy its URL from the browser’s address bar. Switch to the destination spreadsheet and select an empty cell with room below and to the right for the imported rows and columns.
Enter the following formula, replacing SOURCE_URL with the copied URL. Replace Sheet1 with the source tab’s name and A1:C10 with the cells you want to import.
=IMPORTRANGE("SOURCE_URL","Sheet1!A1:C10")Press Enter, then select the formula cell when the initial #REF! connection prompt appears. Click Allow access to connect the spreadsheets and load the selected data.
The URL identifies the source spreadsheet, while the second argument identifies its tab and cells. Keep quotation marks around both arguments when typing them directly into the formula.
Choose the cells you want to import
Change the second argument to select your data: "Sheet1!B2" imports one cell, and "Sheet1!A1:C10" imports a fixed block. Use "Sheet1!A:C" for whole columns, "Sheet1!1:2" for whole rows, or "Sheet1!A5:C" for columns A through C from row 5 onward. Open-ended ranges can increase the import workload, so keep the selection limited to what you need.
For a tab name containing spaces, put single quotation marks around its name inside the double quotation marks. To import the first 100 rows of columns A through C from Sales Data, enter this formula.
=IMPORTRANGE("SOURCE_URL","'Sales Data'!A1:C100")You can omit the tab name and supply only a range such as "A1:C10". Sheets then uses the source spreadsheet’s first sheet, so include the name when you need a particular tab.
To store the source details separately, enter the source URL in A1 and the range text Sheet1!A1:C10 in B1. Keep both cells outside the intended output area, then enter this formula in another empty cell.
=IMPORTRANGE(A1,B1)The cell references need no quotation marks because Sheets reads their contents. Change A1 to choose another source or B1 to choose another range, then click Allow access if a new source connection prompts you. You can also keep just the URL in A1 and use =IMPORTRANGE(A1,"A1:C10").
Import a named range or table
In the source spreadsheet, select the cells, open Data > Named ranges, enter Sales_total as the name, then click Done. Return to an empty destination cell and enter the following formula, using the name that exists in the source.
=IMPORTRANGE("SOURCE_URL","Sales_total")To make a table in Google Sheets, select the source data and choose Format > Convert to table. Use the table’s actual name and column heading in your destination formula. This example imports the Sales Amount column from DeptSales.
=IMPORTRANGE("SOURCE_URL","DeptSales[Sales Amount]")Check the source column heading before typing the reference, especially after you rename columns in Google Sheets. You can also use Table1[#ALL] for the complete table or Table1[#DATA] for its data, replacing Table1 with the actual table name.
Bring together data from several spreadsheets
For separate results, place each IMPORTRANGE formula in its own empty destination area. Leave enough room below and to the right of each formula, and authorize every new source connection.
To combine results vertically, first authorize each source with a standalone IMPORTRANGE formula. Then enter the following VSTACK formula, replacing both URL placeholders and matching the ranges to your source data.
=VSTACK(IMPORTRANGE("URL_ONE","Sheet1!A1:C10"),IMPORTRANGE("URL_TWO","Sheet1!A2:C10"))This example keeps the first source’s header and starts the second source at row 2 to skip its header. Keep the column layouts aligned so the stacked rows have the same meaning.
An array formula can also stack equally wide imports. The semicolon between the functions in this example places the second result below the first.
={IMPORTRANGE("URL_ONE","Sheet1!A1:C10");IMPORTRANGE("URL_TWO","Sheet1!A1:C10")}For equally tall imports placed side by side, replace that separator between the functions with a comma. Decimal-comma locales use a backslash for the horizontal array separator instead.
Filter and sort the imported results
Use QUERY to select columns, filter rows, and sort imported data in one formula. Authorize the source with a standalone IMPORTRANGE first, then replace it with the following example.
=QUERY(IMPORTRANGE("SOURCE_URL","Sheet1!A1:C100"),"select Col1, Col3 where Col3 > 100 order by Col3 desc",1)This returns the first and third imported columns, keeps rows whose third-column numeric value exceeds 100, and sorts that value from highest to lowest. The final 1 tells QUERY that the input has one header row.
For a helper-tab approach, import the source into A1 of a destination tab named Imported. In another tab, enter the following formula. FILTER returns only the rows where its condition, Imported!C2:C100="Paid", evaluates to true.
=FILTER(Imported!A2:C100,Imported!C2:C100="Paid")Create the formula with Gemini
If your account has an eligible Google Workspace or Google AI plan, or Workspace Experiments access, you can ask Gemini to draft the formula. Availability also depends on your account and supported language. On a computer, click Ask Gemini, then enter this request.
Create an IMPORTRANGE formula using the URL in A1 and the range text in B1.Press Enter, review the formula, select its destination cell, then click Insert. Alternatively, type = in a cell and press Ctrl + Alt + g on Windows or ChromeOS, or Command + Ctrl + g on Mac. You still need to authorize the source connection.
Resolve connection and formula problems
For an initial #REF! connection prompt, select the formula cell and click Allow access. If you cannot access the source, open its URL using the Google Account that will authorize the import and request permission from the owner.
If you own the source, select the file in Drive, click Share, and enter the recipient’s email address. Choose Viewer or another appropriate role, then click Send or Share. Once access is granted, return to the destination and authorize the connection.
When the result cannot expand, check the destination cells below and to the right of the formula. Move the import to an empty area or clear enough space for its complete output, including space shared with other imports.
A formula parse problem may mean your spreadsheet requires different argument separators. Use the following version when its locale requires semicolons.
=IMPORTRANGE("SOURCE_URL";"Sheet1!A1:C10")To inspect the locale, open File > Settings and look under General at Locale. Change it if appropriate, then click Save settings. Spreadsheet settings affect your collaborators too.
For localized function names, first use a non-English Google Account display language. Return to File > Settings, then under Display language, uncheck Always use English function names. Click Save Settings.
If your source is an Excel file, double-click it in Google Drive and choose File > Save as Google Sheets. Open the resulting Google spreadsheet and use its URL in the import formula.
Refresh the import or keep a fixed copy
IMPORTRANGE requires internet access, and each request is capped at 10 MB. Keep ranges limited to the data you need, and allow time for changes to appear without expecting immediate or precisely scheduled synchronization.
To trigger a reload, overwrite the formula cell with the same IMPORTRANGE formula, or delete and re-enter it. Refreshing the browser tab does not itself force an import reload. Formula reloads remain subject to network, calculation, and usage limits.
To check calculation behavior, open File > Settings > Calculation. Under Calculation Mode, select Automatic mode or Manual mode, then click Save settings. With manual calculation enabled, select Calculate at the top when needed, but this does not guarantee an immediate external-data refresh.
If the import fails because its source depends on NOW, RAND, or RANDBETWEEN, copy the affected source results and replace them using Paste special > Values only. Import those static cells, remembering that they will stop updating automatically. Google allows TODAY as an exception.
For a fixed copy of the import, copy the complete imported output and select a destination within the same spreadsheet. Choose Edit > Paste special > Paste values only to retain the values without a live import formula.
Paste onto the original output area to replace the import in place. The values-only shortcut is Ctrl + Shift + v on Windows or ChromeOS, or Command + Shift + v on Mac.
Resolve sharing restrictions and revoke access
If you own the source, open Share > Settings and inspect People who can download, copy, print, and access and its permitted roles. Google’s IMPORTRANGE help says that once download, print, and copy options are disabled in a source sheet, new IMPORTRANGE formulas can’t export its data, while formulas set up before that change continue working. Do not rely on a copying restriction to revoke an existing connection.
To revoke the connection, open Share in the source file and find the user who authorized the import. Open the dropdown beside their name, select Remove access, then click Save. Google says the destination’s import permission persists until that authorizing user is removed from the source. If they can still open the file through a group or the file’s General access setting, review those too, because either can keep giving them access.
If access crosses organization boundaries, your administrator may need to review external sharing. With the Drive & Docs administrator privilege, open the Admin console and select Menu > Apps > Google Workspace > Drive and Docs > Sharing settings > Sharing options. Select the relevant organizational unit or configuration group.
Choose On to permit external sharing, Off to prohibit it, or Allowlisted Domains to restrict it. Click Save, or Override where applicable, using the policy appropriate for your organization.
Where Drive trust rules are enabled, they replace ordinary external-sharing settings and can control both sharing and receiving files. With the required administrator privileges, open Menu > Rules, then click Add a filter > Rule type > Trust. Review the rules governing the source owner and intended recipient.
Frequently Asked Questions
Can you set up IMPORTRANGE on an iPhone or Android phone?
Google’s instructions for Android and iPhone or iPad direct you to a computer for cross-spreadsheet references. Although mobile apps support general formula editing, use the computer workflow to complete the IMPORTRANGE connection and source authorization.
Does authorizing an import expose only the selected range?
No, destination editors can use IMPORTRANGE to retrieve other ranges from the same source after authorization. Consider who can edit the destination before connecting a private spreadsheet.
Does IMPORTRANGE work with Sheets files stored in Dropbox or Box?
Google lists IMPORTRANGE as unsupported for Sheets files stored through Box, Dropbox, or Egnyte. Those storage integrations cannot serve as a working alternative for this import workflow.
Who can use manual calculation in Google Sheets?
You need Editor access to use manual calculation. It is unavailable in the mobile app, so manage it from Google Sheets on a computer.
Which Workspace editions support Drive trust rules?
Trust rules are available with Frontline Plus, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, and Enterprise Essentials Plus. You also need the appropriate trust-rule administrator privileges to manage them.











