How to Import Data from Another Sheet in Excel

Manually re-typing information from one Excel sheet to another is a surefire way to waste time and introduce errors. Luckily, Excel has several powerful ways to pull data from another sheet, so your numbers always stay in sync. In this tutorial, you'll learn the best methods, from simple links for a single cell to robust queries for entire datasets.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Choose the Right Method for Your Goal

There isn't one "best" way to import data between sheets - it all depends on what you're trying to accomplish. Here’s a quick overview of what we'll cover:

• Direct Cell Reference: The simplest method for linking a few cells. Perfect for pulling a headline number onto a summary page.
• Named Ranges: Cleans up your formulas and makes them easier for anyone to read and understand.
• Lookup Functions (VLOOKUP & XLOOKUP): Essential for finding a specific piece of information in a large dataset, like looking up a product price by its ID.
• The FILTER Function: A modern and dynamic way to pull in all rows that match certain criteria.
• Power Query: The most powerful and scalable option, creating a refreshable connection to your data that can be cleaned and transformed.

Method 1: Direct Cell Referencing (The Quick Link)

This is the most fundamental way to connect cells in Excel. If you have a total sales figure in a cell on one sheet and want to display it on a summary dashboard sheet, a direct reference is all you need. It creates a live link, so if the original number changes, your dashboard updates automatically.

How to Do It:

1. Navigate to the sheet and cell where you want the imported data to appear (e.g., cell A1 on Sheet1).
2. Type an equals sign: =
3. Without pressing enter, click on the tab for the other sheet (e.g., Sheet2).
4. Click on the source cell containing the data you want to import (e.g., cell C10 on Sheet2).
5. Press Enter.

You'll see the formula bar now shows something like this:

=Sheet2!C10

Let's break down that syntax:

• Sheet2 is the name of the source sheet.
• The exclamation point (!) separates the sheet name from the cell reference.
• C10 is the address of the cell containing the original data.

Pro Tip: If your sheet name has spaces in it (like "Sales Data"), Excel will automatically add single quotation marks around the name: 'Sales Data'!C10.

Use This When: You need to mirror a single value or a small, fixed range of cells from one sheet to another. It's great for summary dashboards.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Using Named Ranges for Clarity

While ='Sales Data'!C10 works, it’s not very descriptive. If you come back to that formula months later, you might not remember what C10 represents. Named ranges let you assign a memorable name to a cell or range of cells, making your formulas much more readable.

How to Create and Use a Named Range:

1. Go to your source sheet (e.g., "Sales Data") and select the cell you want to name (e.g., C10, which contains your total sales).
2. Find the Name Box, which is the small box to the left of the formula bar.
3. Click inside the Name Box, type a descriptive name (e.g., TotalSales_2024), and press Enter. Note: Names cannot have spaces. An underscore or mixed case is a good practice.
4. Now, go back to your destination sheet.
5. In any cell, type =TotalSales_2024 and press Enter.

The cell will now pull the data just like a direct reference, but the formula is incredibly clear. This is fantastic for collaboration and building reports that are easy to maintain.

Use This When: You are frequently referencing specific key metrics and want your workbooks to be easy to understand at a glance.

Method 3: Finding Specific Data with VLOOKUP and XLOOKUP

What if you don't want to just link to one cell? What if you have a list of employee IDs on Sheet1 and you need to pull their names and departments from a master employee list on Sheet2?

This is a job for lookup functions.

The Classic: VLOOKUP

VLOOKUP (Vertical Lookup) searches for a value in the first column of a table and returns a value in the same row from a column you specify.

Imagine your data on Sheet2 looks like this:

On Sheet1, you have Employee ID 102 and want to find their name. Here’s the formula:

=VLOOKUP(102, Sheet2!A1:C4, 2, FALSE)

• 102: The value you're looking for.
• Sheet2!A1:C4: The table where you're looking. It will always search in the first column of this range (Column A).
• 2: The column number in your table from which to return a value. "Name" is the 2nd column.
• FALSE: Tells VLOOKUP to find an exact match. You'll almost always use FALSE.

The result would be "Ben Carter."

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Modern Upgrade: XLOOKUP

If you have a modern version of Excel (Microsoft 365 or Excel 2021+), you should use XLOOKUP. It’s more powerful, more flexible, and less error-prone than its predecessor.

Using the same data, here's how you'd get the name with XLOOKUP:

=XLOOKUP(102, Sheet2!A2:A4, Sheet2!B2:B4)

• 102: The lookup value.
• Sheet2!A2:A4: The lookup array (the column where it looks for the value).
• Sheet2!B2:B4: The return array (the column to pull the result from).

XLOOKUP is better because it doesn't break if you insert or delete columns in your source table, a common problem with VLOOKUP.

Use This When: You need to retrieve specific data points from a large table based on a matching key value (like an ID, product SKU, or email address).

Method 4: Pulling Subsets of Data with the FILTER Function

Sometimes you need to import more than one row of data. What if you want to pull a list of all employees in the "Sales" department? The FILTER function is perfect for this.

How to Use FILTER:

Using the same employee table from before, let's create a list of everyone in Sales:

=FILTER(Sheet2!A2:C4, Sheet2!C2:C4="Sales", "No Results")

• Sheet2!A2:C4: The full range of data you want to import from.
• Sheet2!C2:C4="Sales": The condition. It checks which rows in the Department column (C2:C4) are equal to "Sales".
• "No Results": An optional value to show if the filter finds no matches.

This single formula will "spill" into as many rows as needed to show all matching results. If another person joins the Sales team on Sheet2, they will automatically appear in your filtered list. It's completely dynamic.

Use This When: You need to create a dynamic list from another sheet based on one or more criteria. It's incredibly useful for building regional reports, product category lists, or task assignments.

Method 5: Power Query (Get & Transform) for Robust Connections

For complex situations - like importing very large datasets, needing to clean up messy data, or combining multiple sheets - Power Query is the way to go. It’s Excel's built-in tool for extracting, transforming, and loading data.

Using Power Query creates a formal connection to your source data that you can easily refresh with the click of a button, rather than relying on cell formulas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Quick Steps to Use Power Query:

1. From your destination sheet, go to the Data tab on the Ribbon.
2. In the Get & Transform Data group, click Get Data > From File > From Excel Workbook.
3. Browse and select your current Excel file.
4. The Navigator window will appear, showing you all the sheets and tables in your workbook. Select the source sheet you want to pull data from. A preview will appear.
5. If the data is clean and ready, you can click Load. If it needs cleaning (e.g., remove empty rows, split columns), click Transform Data.
6. Clicking Transform opens the Power Query Editor, where you can apply a huge range of data cleanup steps.
7. Once you're done, click Close & Load.

Your data will be loaded into a new sheet as a refreshable Excel Table. To get the latest data from your source sheet, you can just right-click the table and hit Refresh.

Use This When: Your data is large or needs to be reshaped before you work with it. It's the most powerful and scalable solution for data integration inside of Excel.

Final Thoughts

From a simple =Sheet2!A1 formula to a full-fledged Power Query connection, you have a range of tools at your disposal for importing data between sheets in Excel. Picking the right one depends on whether you're linking a single cell, looking up a specific value, filtering a list of matches, or managing a large dataset.

Pulling data from different sheets in one Excel workbook is just the first step. When you start managing analytics across separate platforms like Google Analytics, Shopify, Facebook Ads, and Salesforce, that simple process can turn into a weekly cycle of downloading CSV files and manually piecing everything together. It feels like you're spending more time gathering data than actually analyzing it. We built Graphed to automate that entire headache. Instead of building manual reports, I just connect my sources once and ask questions like, "Show me a dashboard comparing my ad spend to Shopify sales by campaign this month." It provides a single source of truth and gives me time back to focus on strategy.