How to Use IMPORTRANGE in Google Sheets
IMPORTRANGE lets you pull data from one Google Sheet into another, enabling you to connect spreadsheets and centralize data.
Get the Source Sheet URL
Open the spreadsheet containing the data you want to import. Copy the full URL from your browser address bar.
Use the IMPORTRANGE Formula
In your destination sheet, type =IMPORTRANGE("source_spreadsheet_url", "sheet_name!range"). For example: =IMPORTRANGE("https://docs.google.com/...", "Sheet1!A1:C100").
Grant Access When Prompted
The first time you use IMPORTRANGE, you will see a #REF! error. Click the error and select "Allow access" to connect the sheets.
💡 You only need to allow access once per source spreadsheet.
Reference Specific Sheets and Ranges
Use "Sheet1!A:Z" to import entire columns from a specific sheet. Use "Monthly!A1:F50" to import a specific range from a sheet named "Monthly".
Try These Templates
Frequently Asked Questions
Can IMPORTRANGE import data in real time?
IMPORTRANGE refreshes periodically. Changes in the source sheet may take a few minutes to appear in the destination sheet.
Does IMPORTRANGE work across Google Workspace accounts?
Yes, as long as the source sheet has been granted access.