IMPORTRANGE for other spreadsheets in Google Sheets - Step-by-Step Guide

Introduction

IMPORTRANGE lets you bring data from one Google Sheet into another automatically. This helps when you want to use or analyze data stored in a different spreadsheet without copying it manually.

When you want to see sales data from a shared spreadsheet inside your own report sheet

When your team updates a master list and you want your sheet to always show the latest version

When you manage multiple project sheets and want to combine key info into one summary sheet

When you want to avoid copying and pasting data that changes often

When you want to keep your data organized but still connected across files

Steps

Step 1: Open

- the Google Sheet where you want to import data

You see the sheet ready to receive data

Step 2: Click

- a cell where you want the imported data to start

The cell is selected and ready for formula input

Step 3: Type

- the formula bar

You start entering the IMPORTRANGE formula

💡 The formula looks like this: =IMPORTRANGE("spreadsheet_url", "range_string")

Step 4: Enter

- the full URL of the source spreadsheet inside quotes as the first argument

The formula knows which spreadsheet to get data from

Step 5: Enter

- the range of cells to import as the second argument, in quotes, like "Sheet1!A1:C10"

The formula knows which cells to bring in

Step 6: Press

- Enter key

The formula runs and shows #REF! with a prompt to allow access if this is the first time

Step 7: Click

- Allow access button that appears in the cell

The data from the other spreadsheet appears in your sheet

Before vs After

Before

Cell A1 is empty in your current sheet

After

Cell A1 and following cells show data imported from the other spreadsheet's specified range

Settings Reference

Spreadsheet URL

📍 First argument of IMPORTRANGE formula

Tells IMPORTRANGE which spreadsheet to pull data from

Default: None

Range string

📍 Second argument of IMPORTRANGE formula

Specifies which cells to import from the source spreadsheet

Default: None

Access permission

📍 Prompt shown in the cell after first use

Grants permission for your sheet to read data from the other spreadsheet

Default: No access until allowed

Common Mistakes

Not putting the spreadsheet URL inside quotes

IMPORTRANGE requires the URL as a text string, so missing quotes causes an error

Always put the URL inside double quotes, like "https://docs.google.com/spreadsheets/d/abc123..."

Using a wrong or misspelled sheet name in the range string

IMPORTRANGE cannot find the range and returns an error if the sheet name does not exist

Check the exact sheet name in the source spreadsheet and type it exactly, including spaces

Not clicking Allow access when prompted

Without permission, IMPORTRANGE cannot show data and will keep showing #REF! error

Click the Allow access button in the cell to grant permission for data import

Summary

IMPORTRANGE imports data from another Google Sheet using its URL and a cell range.

You must allow access permission the first time you use IMPORTRANGE with a new spreadsheet.

Make sure to use correct quotes and exact sheet names to avoid errors.