How to Input Data from Another Sheet in Google Sheets

Nothing brings a workflow to a halt faster than hunting for data. If your information is spread across different tabs - or even dozens of different files - in Google Sheets, you’re stuck either copying and pasting information (a recipe for mistakes) or constantly switching between browser tabs just to find a single number. Luckily, Google Sheets has powerful, built-in ways to pull data from another sheet directly into the one you’re working on.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

This article will show you exactly how to do it. We’ll cover the simple method for referencing data within the same spreadsheet and then dive into the powerful IMPORTRANGE function for pulling data from entirely different spreadsheet files.

Referencing Data Within the Same Spreadsheet: The Basics

Let's start with the most common scenario: you have different tabs (or "sheets") within the same Google Sheets file, and you need to connect them. For example, you might have one sheet with raw sales data and another sheet that acts as a summary dashboard. This method is perfect for keeping your work organized and separating your raw numbers from your final reports.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Reference a Single Cell

Pulling the value from a single cell in another sheet is one of the foundational skills in any spreadsheet tool. The formula syntax is simple and memorable:

='Sheet Name'!CellReference

The single quotes around the 'Sheet Name' aren't always required, but they're essential if your sheet name has spaces or special characters (like "Q1 Sales Data" or "Sales-2024"). It's a good habit to use them every time so you never have to worry about it.

Let's walk through an example. Imagine you have a sheet named “Employee List” and another named “Weekly Report.” You want to pull an employee’s name from cell A2 of the "Employee List" sheet into your report.

You could manually type the formula, but there's a much easier way:

• Step 1: Go to your “Weekly Report” sheet and click on the cell where you want the employee's name to appear (let's say it's cell B4).
• Step 2: Type the equals sign: =
• Step 3: Don't press enter! Instead, click on the “Employee List” tab at the bottom of your screen.
• Step 4: Click on the cell containing the name you want, which is cell A2. You’ll see a temporary formula appear in the formula bar.
• Step 5: Press the Enter key.

Google Sheets will automatically take you back to your "Weekly Report" sheet. Cell B4 will now display the employee’s name, and the formula bar will show ='Employee List'!A2. Any styling or formatting from the original cell is ignored, you’re only pulling the raw value. Best of all, this connection is live - if you update the name in the "Employee List" sheet, it will automatically update in your report.

How to Reference a Range of Cells

Often, you don't need just one cell, you need to perform a calculation on an entire range of cells from another sheet. The syntax is very similar, you just specify a range instead of a single cell:

='Sheet Name'!StartCell:EndCell

For example, ='Raw Data'!C2:C150 refers to the range of cells from C2 down to C150 on the "Raw Data" sheet.

This method is rarely used on its own. Instead, it becomes the backbone of other functions like SUM, AVERAGE, VLOOKUP, or COUNTIF. It allows you to build powerful, organized summary sheets that do calculations based on clean, untouched raw data in another tab.

Let's say you have a sheet called “Monthly Sales” that lists every transaction, with the sale amount in column D. On your main “Dashboard” sheet, you want to calculate the total revenue.

• Step 1: On your “Dashboard” sheet, click the cell where you want the total revenue displayed.
• Step 2: Start typing your function, like =SUM(
• Step 3: After the open parenthesis, click on the “Monthly Sales” sheet tab.
• Step 4: Click and drag to highlight the entire range of sales data you want to sum up (e.g., from cell D2 to the last sale). You can also click the entire column header (the letter D) to sum the whole column, which means you won't have to update the formula as you add new sales.
• Step 5: Press Enter.

Google Sheets will automatically write the correct formula for you, something like =SUM('Monthly Sales'!D2:D500). Now your dashboard always shows the latest total revenue without you ever having to manually calculate it again.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Bringing in Data from a Different Spreadsheet with IMPORTRANGE

What if your data isn't in another tab, but in a completely different Google Sheets spreadsheet file? This is common for teams that want to keep "source of truth" data separate from departmental reports or analyses. Attempting to use the Sheet!Cell method won't work here. For this, you need the IMPORTRANGE function.

IMPORTRANGE allows you to import a range of cells from any Google Sheet you have access to, right into your current sheet. The data remains linked, meaning changes in the source spreadsheet are automatically reflected in the destination sheet.

Understanding the IMPORTRANGE Syntax

The function has two parts, both of which are required and must be properly formatted:

=IMPORTRANGE("spreadsheet_url", "range_string")

Let’s break that down:

• "spreadsheet_url": This is the full link to the spreadsheet you want to pull data from. Simply open that spreadsheet file and copy the entire URL from your browser’s address bar. It must be enclosed in double quotation marks.
• "range_string": This tells Google Sheets which tab and which cells to grab. The format is "SheetName!A1:B10". Just like with the URL, this entire value must be in double quotation marks. The sheet name and cell range are formatted exactly as they would be for referencing data within the same spreadsheet.

A complete formula would look something like this:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyzEXAMPLE/edit", "Q1 Sales Data!A1:E50")

Step-by-Step Guide to Using IMPORTRANGE

Using IMPORTRANGE for the first time involves a one-time permission step that often confuses new users. Follow these steps carefully.

1. Get the Source URL: Open the Google Sheet you want to pull data from (the source sheet) and copy the entire URL from your browser's address bar.
2. Identify the Range: Make a note of the exact sheet name (tab name) and the range of cells you want to import from that sheet (e.g., "Master Inventory!A:F" to import the first six columns).
3. Write the Formula: Open the Google Sheet where you want the data to appear (the destination sheet). Click on an empty cell in the top-left corner of where you want your new data to start, and type the full IMPORTRANGE formula using the URL and range string you gathered.
4. Allow Access (And the #REF! Error): After you press Enter, you will almost certainly see a red #REF! error. This is normal and expected. Hover your mouse over the cell with the error, and a small blue button that says “Allow access” will appear. Click it. This is a security feature where you are formally granting permission for the two spreadsheets to connect and share data. You only have to do this once per spreadsheet pair.
5. Watch the Data Appear: Once access is granted, the data you requested will instantly populate, starting from the cell where you put the formula and expanding down and to the right.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Practical Tips and Best Practices for IMPORTRANGE

IMPORTRANGE is incredibly useful, but here are a few tips to get the most out of it:

• Combine it with other functions: IMPORTRANGE can be nested inside other functions to create dynamic reports. For example, you can wrap it in a QUERY to filter, sort, or pull only specific columns from the source data. Just remember, when using QUERY with IMPORTRANGE, you refer to columns as Col1, Col2, Col3, not A, B, C.

Example: =QUERY(IMPORTRANGE("URL", "Sales!A1:G100"), "SELECT Col1, Col5, Col7 WHERE Col7 = 'Shipped'") would only import the order number, total price, and status for orders that have shipped.

• Only import what you need: It can be tempting to import giant ranges of data, but IMPORTRANGE can sometimes be slow to update if you're pulling thousands of cells unnecessarily. Try to be specific about the columns and rows you actually need to keep your sheets feeling fast and responsive.
• The Source of Truth: Always treat the original spreadsheet as your "source of truth." You cannot edit the data that is brought in via IMPORTRANGE. If you try to type over one of the imported cells, you'll break the connection and see a #REF! error. All changes must be made in the original source file.

Final Thoughts

Learning how to link sheets is a fundamental skill that transforms Google Sheets from a simple grid of cells into a powerful tool for building organized dashboards and reports. For data within the same file, a simple 'Sheet Name'!A1 reference is all you need. For connecting completely different spreadsheets, IMPORTRANGE() is your go-to function for creating a live pipeline of information that stays up-to-date automatically.

Pulling data into a single sheet is a huge timesaver, but it’s still just the first step. You still have to format the data, build the charts, and update reports by hand. As you start connecting more data from more places (like Google Analytics, Shopify, or HubSpot), this can quickly become unmanageable. With Graphed , we connect directly to your Google Sheets and other business tools automatically. Instead of writing complex formulas to bring data together, you can just describe the report you need in plain English. We turn hours of pulling and organizing data into a 30-second conversation, so you spend your time getting insights, not just gathering numbers.