IMPORTRANGE for cross-spreadsheet data in Google Sheets - Step-by-Step Guide

Introduction

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

When you want to show sales data from a shared spreadsheet in your personal report.

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

When you manage budgets in one file but want to summarize them in another.

When you need to combine data from multiple project sheets into one overview.

When you want to avoid duplicate data entry across different spreadsheets.

Steps

Step 1: Open

- the destination Google Sheet where you want the data

You see the sheet where you will import 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

Formula is entered but not yet executed

💡 Use this exact formula format: =IMPORTRANGE("spreadsheet_url", "sheet_name!range")

Step 4: Replace

- spreadsheet_url in the formula

The formula points to the correct source spreadsheet

💡 Copy the full URL of the source spreadsheet from your browser address bar and paste it inside quotes

Step 5: Replace

- sheet_name!range in the formula

The formula specifies the exact sheet and cells to import

💡 For example, use "Sheet1!A1:C10" to import cells A1 to C10 from Sheet1

Step 6: Press

- Enter key

Google Sheets asks for permission to connect the sheets if not done before

Step 7: Click

- Allow access button in the prompt

The data from the source spreadsheet appears in your sheet

Before vs After

Before

Destination sheet has no data in the selected cell

After

Destination sheet shows data from the source spreadsheet's specified range

Settings Reference

Allow access

📍 Permission prompt after entering IMPORTRANGE formula

Grants permission to import data from the other spreadsheet

Default: Deny until user allows

Range string

📍 Second argument of IMPORTRANGE formula

Specifies which cells to import from the source spreadsheet

Default: None

Common Mistakes

Not using quotes around the spreadsheet URL or range string

IMPORTRANGE requires both arguments as text strings inside quotes

Always put the URL and range inside double quotes, like =IMPORTRANGE("url", "Sheet1!A1:B10")

Using a wrong or incomplete URL

The formula cannot find the source spreadsheet without the full correct URL

Copy the entire URL from the browser address bar of the source spreadsheet

Not clicking Allow access when prompted

Without permission, the data will not load and the formula shows an error

Click Allow access to enable data import

Summary

IMPORTRANGE imports data from one Google Sheet to another using a formula.

You must provide the full source spreadsheet URL and the exact range to import.

Permission is required once to connect the sheets before data appears.