How to Import Data from One Spreadsheet into Another

Tired of manually copying and pasting data from one spreadsheet to another? Not only is it tedious, but it's also a surefire way to introduce errors and work with outdated information. Reliably connecting spreadsheets allows you to centralize your master data in one place while using it across multiple reports and dashboards, all without the copy-paste headache.

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 tutorial will walk you through the best methods for importing data from one spreadsheet into another in both Google Sheets and Excel, so your numbers stay current and accurate automatically.

Why Automate Data Imports Between Spreadsheets?

Before we jump into the "how," let's quickly cover the "why." Manually moving data is one of the biggest time sinks for anyone working with spreadsheets. Automating this process does three amazing things:

• Saves Time and Prevents Errors: Automating the connection means you set it up once, and it works for you in the background. It completely removes the risk of human error from mistyping or pasting data into the wrong cell.
• Creates a Single Source of Truth: You can maintain a single "master" spreadsheet (like a product list, a customer database, or a budget tracker) and pull that data into any number of other reports. When the master sheet is updated, every connected report gets the latest information.
• Keeps Reports Live: If you're building a dashboard or a weekly report, a direct connection ensures you're always looking at the most current data without having to hunt down a new CSV export.

How to Import Data in Google Sheets with IMPORTRANGE

For Google Sheets users, the go-to solution is a powerful formula called IMPORTRANGE. It’s specifically designed to pull a range of cells from one Google Sheet into another, creating a live link between them.

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

What You'll Need

To use this formula, you just need two pieces of information from your source spreadsheet (the one you're pulling data from):

1. The full URL of the source Google Sheet.
2. The name of the tab and the cell range you want to import (e.g., "Sales Data!A1:F500").

Understanding the IMPORTRANGE Formula

The syntax for the formula is simple and clean:

=IMPORTRANGE("spreadsheet_url", "range_string")

• spreadsheet_url: This is the full link to the source Google Sheet, which you can copy from your browser's address bar. It must be enclosed in double quotes.
• range_string: This tells Google Sheets which tab and cells to grab. The format is "SheetName!CellRange" (e.g., "Q4 Leads!A1:G150"). This also needs to be in double quotes.

Step-by-Step Guide to Using IMPORTRANGE

Let’s say you have a master list of all company contacts in one Google Sheet and you want to pull just the names and email addresses into a separate "Weekly Outreach" sheet.

1. Get the Source Sheet URL: Open your master contacts spreadsheet and copy the entire URL from the address bar. It will look something like this: https://docs.google.com/spreadsheets/d/1aBcDeFgHiJkLmNoPqRsTuVwXyZ...
2. Identify the Range: In that same sheet, assume the contacts are on a tab named "All Contacts" and the names are in column A and emails are in column B, from row 2 down to row 100. Your range string would be "All Contacts!A2:B100".
3. Write the Formula: Go to your destination spreadsheet (the "Weekly Outreach" sheet). Click on cell A1 (or wherever you want the data to start) and type in your formula:
4. Allow Access: The first time you link two sheets, Google will require a security measure. You'll see a #REF! error in the cell. Hover over it, and a blue button will appear asking for permission to "Allow access." Click it. In a few seconds, your data will load directly into the sheet!

That’s it! Now, any changes made to the names or emails in the "All Contacts" sheet will automatically appear in your "Weekly Outreach" sheet.

Pro Tips for Using IMPORTRANGE

• Combine with QUERY: To make it even more powerful, you can wrap your IMPORTRANGE formula inside a QUERY formula to filter, sort, and select specific columns. For instance, to only import contacts from "California":
• Import Open-Ended Ranges: If your list is constantly growing, you can reference the entire columns instead of a fixed range. For example, "All Contacts!A:B" will import all data from columns A and B, including any new rows you add later.

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

How to Import Data in Excel with Power Query

For Excel users, the most robust and modern way to connect to another spreadsheet is by using Power Query (now known as "Get & Transform Data," found on the Data tab). It's much more reliable than old-school cell linking, especially if file names or locations might change in the future.

Power Query is built into modern versions of Excel for Windows and Excel 365 for Mac.

Step-by-Step Guide to Using Power Query

Let's use the same scenario: importing contact info from a master Excel workbook into your "Weekly Outreach" file.

1. Open Your Destination Workbook: Open the "Weekly Outreach.xlsx" file where you want the data to land.
2. Navigate to Get Data: Go to the Data tab on the Ribbon.
3. Select the Source File: A file browser window will pop up. Locate and select your master contacts Excel file and click Import.
4. Use the Navigator Window: After a moment, a "Navigator" window will appear. It shows you all the sheets and any properly formatted Tables within that source workbook.
5. Load the Data: Select the sheet or table containing your contact info. You’ll see a preview on the right. At the bottom of the window, you have two main options:
6. For our simple example, just click Load.

Your connections are now set up. A new sheet will appear with your contact data, neatly organized in a table.

Refreshing Your Imported Data

Unlike IMPORTRANGE in Google Sheets, Power Query connections in Excel don't always update in real-time. You need to tell Excel to refresh the data.

• Manual Refresh: Go to the Data tab and click the large Refresh All button. Excel will reach out to the source file and pull in the latest version of the data.
• Automatic Refresh: You can also set the query to refresh automatically whenever you open the file. Right-click anywhere in your imported data table, go to Table > External Data Properties, and check the box for "Refresh data when opening the file."

The Classic (But Fragile) Method: Linking Excel Cells

Long before Power Query, the only way to do this in Excel was to link individual cells. While it works for very simple tasks, it’s notoriously fragile and not recommended for critical reports.

How it works:

1. Have both Excel workbooks open.
2. In your destination cell, type the = sign.
3. Switch to the source workbook.
4. Click on the cell you want to pull data from.
5. Press Enter.

Excel will create a formula that looks something like '[Master Contacts.xlsx]All Contacts'!$A$2. The biggest problem? If you move, rename, or delete the source file, that link breaks immediately, leaving you with #REF! errors across your entire report.

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

Final Thoughts

Manually moving data between spreadsheets is a recipe for errors and wasted time. By using built-in features like IMPORTRANGE in Google Sheets or Power Query in Excel, you create a stable, automated connection that keeps your data synced and your reports trustworthy, allowing you to focus on analysis instead of chasing down the latest numbers.

While these methods are powerful for working across spreadsheets, the bigger challenge is often getting all of your business data into one place to begin with, like combining your ad performance from Google Ads, sales from Shopify, and lead data from Salesforce. We actually built Graphed to remove this friction entirely. Our tool lets you securely connect your marketing and sales platforms in a few clicks, so you can stop downloading CSVs and start getting answers from your data using simple, conversational language to build real-time dashboards instantly.