How to use IMPORTRANGE in Google Sheets (step-by-step guide)

I’ll be the first to admit that I get a kick out of manual data entry—it’s when all my childhood years playing typing racer games really pays off. But when you need to copy heaps of data from one spreadsheet to another, the novelty of hitting keys fast and furious wears off pretty quickly. 

That’s where the IMPORTRANGE function comes in.

Here, I’ll walk you through how to use IMPORTRANGE in Google Sheets, so you can automatically pull data from another spreadsheet and keep things consistent. 

Here’s the short version, but for a step-by-step guide with screenshots, keep scrolling.

1. Open the Google Sheet spreadsheet with the data you want to copy and the one you want to pull the data into. 

2. Click the destination cell.

3. Enter =IMPORTRANGE immediately followed by ("[the URL of your source sheet]","[sheet name]![data range]").

4. Press Enter. 

5. If this is your first time connecting the two spreadsheets, click Allow access. 

Table of contents: 

What is IMPORTRANGE in Google Sheets? 

IMPORTRANGE is a function in Google Sheets that allows you to automatically copy data from one spreadsheet to another. 

What is the IMPORTRANGE formula in Google Sheets

The IMPORTRANGE formula in Google Sheets is  IMPORTRANGE is =IMPORTRANGE(spreadsheet_url,range_string). Here’s what each of those inputs mean: 

• IMPORTRANGE: This is the Google Sheets function. 

• spreadsheet_url: This is the URL of the source spreadsheet (the spreadsheet that you’re pulling data from). When you enter the spreadsheet URL, it must be wrapped in quotation marks. 

• range_string: This is the cell range of the data you’re importing. This must also be wrapped in quotation marks. 

How to use IMPORTRANGE in Google Sheets

Here’s the step-by-step version of how to use IMPORTRANGE in Google Sheets. To demonstrate, we’re going to use IMPORTRANGE to transfer the data from cells A2 to C10 of the All students spreadsheet to the corresponding cells of the ABC101: Student roster spreadsheet. 

1. Open the source spreadsheet (the one with the data you want to copy) in Google Sheets. In this example, it’s the All students spreadsheet.

2. Open the destination spreadsheet (the one you want to pull the data into) in Google Sheets. In this example, it’s the ABC101: Student roster spreadsheet.

3. Copy the URL of your source spreadsheet—everything except for edit#gid=0 that automatically appears at the end of your URL. 

   

4. Click the destination cell (the cell where you want the imported range to start from) in your destination spreadsheet.

   

5. In the destination cell, enter =IMPORTRANGE immediately followed by ("[the URL of your source sheet]","[sheet name]![data range]"). Here’s what this would look like in our example: 

   =IMPORTRANGE("https://docs.google.com/spreadsheets/d/1zFG5atdGgrR1lS-VeTo-l7FdBt3DWWp3BoOemI7W9Rs/","Sheet1!A2:C10")

   

   If your spreadsheet contains multiple sheets, it’s crucial to specify which source sheet you want to pull data from. Otherwise, Google Sheets will automatically import data from the first sheet. 

6. Press Enter. 

7. The first time you try connecting data across spreadsheets, you’ll get an error message: #REF!. This is normal. Click Allow access to give your destination spreadsheet permission to access your source spreadsheet. 

   

That’s it. Google Sheets will import the specified data range into your destination spreadsheet. Any updates made to the source cell range will also automatically appear in the destination spreadsheet.

Automate Google Sheets

Need to import data from somewhere other than another Google Sheet? When you use Zapier’s Google Sheets integration, you can connect it with thousands of other apps and build a sophisticated, end-to-end data management system. 

For example, you can automatically store event feedback form submissions in Google Sheets. AI can then analyze the responses for common themes and send a summary to your events marketing team in Slack. It can also flag any comments that meet preset criteria, create a follow-up task in your project management tool, and notify the right teammate in Slack. Learn more about how to automate Google Sheets, or get started with one of these pre-built templates.

Related reading

This article was originally published in May 2024. The most recent update was in March 2026.