---
title: "How to use IMPORTRANGE in Google Sheets: A step-by-step guide"
description: "IMPORTRANGE in Google Sheets lets you import data from one spreadsheet to another. Here's how to use it so you can stop entering the same data over and over."
image: "https://images.ctfassets.net/lzny33ho1g45/MwyA0Tk0B0af2mS4VboIf/c06a778dee2d7a0a24b464b0d88250c3/google-sheets-hero-green.png"
---

# How to use IMPORTRANGE in Google Sheets: A step-by-step guide

IMPORTRANGE in Google Sheets lets you import data from one spreadsheet to another. Here's how to use it so you can stop entering the same data over and over.

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](https://vendors.selectsoftwarereviews.com/redirect/1767831752373x549042478702919700?p=1715808885462x244895206427328500), 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?](#what)
- [What is the IMPORTRANGE formula in Google Sheets?](#formula)
- [How to use IMPORTRANGE in Google Sheets](#how)
- [Automate Google Sheets with Zapier](#automate)

## What is IMPORTRANGE in Google Sheets? 

IMPORTRANGE is a function in [Google Sheets](https://zapier.com/blog/google-sheets-tutorial/) 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](https://zapier.com/blog/google-sheets-functions/).
- **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](https://zapier.com/blog/formula-parse-error-google-sheets/): `#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](https://zapier.com/apps/google-sheets/integrations), 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](https://zapier.com/blog/automate-google-sheets/), or get started with one of these pre-built templates.

**Related reading**

- [How to use VLOOKUP in Google Sheets](https://zapier.com/blog/vlookup-in-google-sheets)
- [Google Sheets vs. Excel: Which is right for you?](https://zapier.com/blog/google-sheets-vs-excel/)
- [How to clean up data in Google Sheets with cleanup suggestions](https://zapier.com/blog/google-sheets-data-cleanup/)
- [Free Google Sheets templates to boost productivity](https://zapier.com/blog/google-sheets-templates/)

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