How to Insert Data from Another Sheet in Google Sheets

Pulling data from another sheet is one of the most useful skills you can learn in Google Sheets. It transforms static spreadsheets into dynamic, interconnected databases, saving you from the nightmare of manually copying and pasting information. This guide will walk you through the essential methods, from a simple click-and-drag reference to powerful functions that can fetch and filter data from completely separate files.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Simple Cell Referencing

This is the most straightforward method and your starting point for pulling data from a different tab within the same Google Sheets document.

When to Use This Method

Simple referencing is perfect when you need to display the value of a single cell or a small range from another sheet. The connection is live, meaning if the source cell (e.g., cell A1 on 'Sheet1') changes, the destination cell on 'Sheet2' automatically updates. Use it for building summary dashboards, creating quick calculations, or just keeping information synced across your workbook.

Step-by-Step Guide

Let's say you have a sheet named "Q1 Sales" and you want to pull the total revenue figure from cell F50 into a summary sheet named "Annual Overview."

1. Navigate to your "Annual Overview" sheet and click the cell where you want the Q1 total to appear.
2. Type the equals sign (=) to start the formula. Do not press Enter yet.
3. Click on the "Q1 Sales" sheet tab at the bottom of the screen. Your screen will switch to that sheet.
4. Now, click on cell F50 - the cell containing your total revenue.
5. Press the Enter key.

Google Sheets will automatically take you back to your "Annual Overview" sheet. The cell you selected will now display the value from "Q1 Sales"!F50. If you look in the formula bar, you'll see the reference that Google Sheets created for you:

='Q1 Sales'!F50

Let's break down this syntax:

• Single Quotes (' '): If your sheet name has spaces or special characters (like "Q1 Sales"), Google Sheets wraps it in single quotes. If the sheet name was just "Sales," it would be =Sales!F50.
• Exclamation Mark (!): This is the separator. It tells Google Sheets, "Everything before me is the sheet name, and everything after me is the cell reference."

You can also reference an entire range this way. Just type =, switch sheets, and then click and drag to highlight the range you want, like A1:B10. Press Enter, and the entire data range will populate.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: The Powerful IMPORTRANGE Function

What if your data isn't in another tab but in a completely separate Google Sheets file? That's where IMPORTRANGE comes in. This function is essential for pulling data across different spreadsheets, creating a central dashboard from multiple sources.

When to Use This Method

• When you need data from a Google Sheet that has a different URL.
• To sync data from a master sales sheet to an individual team member’s report.
• To consolidate data from separate monthly reports into one year-end summary file.

Understanding the IMPORTRANGE Syntax

The formula for IMPORTRANGE looks like this:

=IMPORTRANGE("spreadsheet_url", "range_string")

It has two required parts (arguments), both of which must be enclosed in double-quotes:

1. spreadsheet_url: The full URL of the source Google Sheet you want to pull data from. You can just copy this from the browser's address bar.
2. range_string: The name of the sheet and the cell range you need, written in the same format as the simple cell reference (e.g., "Sheet Name!A1:G100").

Step-by-Step Guide and Common Issues

Let's imagine you have a spreadsheet with your company's master client list and you want to import their names and email addresses into a separate spreadsheet for a marketing campaign.

1. Get the Source URL: Open the master client list spreadsheet and copy its full URL from your browser. It will look something like https://docs.google.com/spreadsheets/d/1a2b3c4d5e...
2. Identify the Range: In the master client list, let's say the names are in column A and emails are in column B, from row 2 to 101. Your range string will be "Clients!A2:B101".
3. Write the Formula: Go to your new marketing campaign sheet. In cell A1 (or wherever you want the data to start), build the formula:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1a2b3c4d5e...", "Clients!A2:B101")

1. Grant Access (Important First-Time Step): After you press Enter, you will almost certainly see a #REF! error. This is normal. Hover your mouse over the cell, and a small blue button will pop up that says "Allow access." Click it. This creates a one-time authorization, giving your current sheet permission to pull data from the source sheet.

Once you grant access, the client data will instantly appear. The connection is live, so any updates made to the master client list will automatically reflect in your marketing sheet.

Pro Tips for Using IMPORTRANGE

• The imported data is read-only. If you try to type over a cell in the destination range, you'll break the connection for that cell and see a #REF! error. You must make all edits in the original source file.
• For better organization, you can put the source URL in a separate cell (e.g., C1) and reference it in your formula like this: =IMPORTRANGE(C1, "Clients!A2:B101"). This makes it easier to update the source sheet without digging through your formula.

Method 3: Combining IMPORTRANGE with QUERY for Advanced Control

IMPORTRANGE is great, but it pulls everything in the range you specify. What if you only want rows that meet certain criteria? By nesting IMPORTRANGE inside the QUERY function, you gain surgical control over the data you import.

Why Combine These Functions?

QUERY acts like a filter and sorter for your data. Combining it with IMPORTRANGE means you can fetch data from another spreadsheet and filter it before it even gets displayed. This is fantastically efficient.

Use this combo to:

• Import only the sales records from a specific region.
• Pull a list of projects that are marked "Completed."
• Fetch all transactions over $500 from a massive transaction log.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Example in Action: Pulling Specific Sales Data

Imagine your source spreadsheet has a sheet called "All Sales" with thousands of rows. The columns are: Date (Column A), Product (Column B), Region (Column C), and Amount (Column D). Your goal is to import only the sales from the "North" region into your dashboard.

Here's how to build the combined formula:

1. Start with IMPORTRANGE

First, write the IMPORTRANGE function to pull the whole dataset. This will serve as the 'data' part of our QUERY function.

IMPORTRANGE("YOUR_SPREADSHEET_URL", "All Sales!A:D")

2. Wrap it in QUERY

Now, wrap that function inside QUERY. The IMPORTRANGE function acts as the first argument.

=QUERY(IMPORTRANGE("YOUR_SPREADSHEET_URL", "All Sales!A:D"), "query_statement_here")

3. Write the Query Statement

This is where the magic happens. We need to tell QUERY what to select. We want all columns where the value in the third column (Region) is 'North'.

The query statement will be: "SELECT * WHERE Col3 = 'North'"

• SELECT * means "select all columns."
• WHERE Col3 = 'North' is our filter condition.

Heads up! This is the most important rule when using QUERY with IMPORTRANGE: you must refer to columns by their number (Col1, Col2, Col3, etc.), not their letter (A, B, C). Col1 refers to the first column of the imported range (in this case, column A), Col2 refers to the second (column B), and so on.

The Final Formula:

Putting it all together, the final formula in your dashboard sheet will be:

=QUERY(IMPORTRANGE("YOUR_SPREADSHEET_URL", "All Sales!A:D"), "SELECT * WHERE Col3 = 'North'")

When you press Enter (and allow access if it's the first time), only the sales data from the North region will appear. It's clean, efficient, and fully automated.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Other Helpful Functions for Your Toolkit

While IMPORTRANGE and QUERY are the heavy hitters, a few other functions are great for related tasks.

VLOOKUP

VLOOKUP (Vertical Lookup) is ideal when you need to find a specific piece of information in a large table. For example, you have a product ID in one sheet and want to pull the corresponding product price from a master product list in another sheet. It's perfect for fetching a single value related to a specific key, but not for importing entire tables.

=VLOOKUP("Product ID", 'Product List'!A:B, 2, FALSE)

FILTER

The FILTER function is a simpler, more intuitive alternative to QUERY for basic filtering. It does exactly what it says: it returns the rows from a range that meet your specified condition. You can't perform the advanced sorting or column selection that QUERY allows, but for a quick filter, it's often easier to read.

=FILTER('Raw Tasks'!A:C, 'Raw Tasks'!C:C = "High Priority")

Final Thoughts

Learning how to reference data across sheets transforms Google Sheets from a calculation tool into a connected system. Start with simple cell references for tasks within the same file, graduate to IMPORTRANGE to connect entirely separate spreadsheets, and combine it with QUERY for ultimate precision and control. Mastering these functions automates tedious work and ensures your reports are always in sync.

Manually setting up IMPORTRANGE and writing complex QUERY statements is powerful, but it can quickly become time-consuming, especially when pulling data from more than just another Google Sheet. We built Graphed because we wanted to eliminate this friction entirely. Instead of wrestling with formulas, you can connect all your sources like Google Analytics, Shopify, and Facebook Ads with a single click, and then use plain English prompts to instantly build the dashboards and reports you need, getting you from data to decision in seconds.