• Home

  • Productivity

  • App tips

App tips

3 min read

How to use IMPORTRANGE in Google Sheets

By Jessica Lau · May 7, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

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

The same data-linking method doesn't work in Excel, but there's another way. Learn how to pull data from another sheet in Excel.

Table of contents

  • What is IMPORTRANGE in Google Sheets? 

  • How to use IMPORTRANGE in Google Sheets 

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. 

The syntax for IMPORTRANGE is =IMPORTRANGE(spreadsheet_url,range_string). Here's what each of those inputs mean: 

  • IMPORTRANGE: This is the 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 the IMPORTRANGE function to transfer the data from cells A2 to C10 of the All students spreadsheet to the corresponding cells of the ABC101: Student roster spreadsheet. 

Two open Google Sheets spreadsheet. The Google Sheets spreadsheet titled All students has the cell range A2 to C10 highlighted.
  1. Open the Google Sheet spreadsheet with the data you want to copy. In this example, the source spreadsheet is All students

  2. Open the spreadsheet that you want to pull the data into. In this example, the destination spreadsheet is ABC101: Student roster.

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

    The source spreadsheet's URL highlighted in the browser address bar.

  4. Click the destination cell (the cell where you want the imported range to start from). In this case, that's cell A2 of the ABC101: Student roster spreadsheet. 

    The ABC101 student roster spreadsheet in Google Sheets with cell A2 selected.

  5. 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")

    Complete IMPORTRANGE function entered in cell A2 of the ABC101 student roster spreadsheet in Google Sheets.

    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. 

    Error message in cell A2 of the ABC101 student roster spreadsheet in Google Sheets with a dialog box requesting access to the 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.

Demo of changing data in the source spreadsheet and having those changes automatically reflected in the destination spreadsheet.

Automate Google Sheets

Need to import data from somewhere other than another Google Sheet? Use Zapier's Google Sheets integration to automatically add data from (or to) other apps, like Gmail, Typeform, or Shopify—no manual data entry or formulas required. Learn more about how to automate Google Sheets, or get started with one of these pre-built templates.

Save new Gmail emails matching certain traits to a Google Spreadsheet

Save new Gmail emails matching certain traits to a Google Spreadsheet
  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets
  • Facebook Lead Ads logo
  • Google Sheets logo
Facebook Lead Ads + Google Sheets

Send emails via Gmail when Google Sheets rows are updated

Send emails via Gmail when Google Sheets rows are updated
  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Related reading

  • How to use VLOOKUP in Google Sheets

  • Google Sheets vs. Excel: Which is right for you?

  • How to clean up data in Google Sheets with cleanup suggestions

  • Free Google Sheets templates to boost productivity

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'