How to Upload Data to Excel

Uploading data is the first step to turning raw numbers into meaningful insights, but simply copying and pasting information into a spreadsheet can be messy and hard to update. Excel has powerful, built-in tools that let you import data directly from different sources, creating a seamless connection that you can refresh with a single click. This guide will walk you through the best ways to get your data into Excel, from simple text files to live web pages.

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

Why Should You Import Data Instead of Copy-Pasting?

While copy-paste is quick for a one-time task, using Excel’s dedicated import tools offers significant advantages, especially for recurring reporting tasks. Think of it as creating a live pipeline for your data rather than just taking a static snapshot.

• Data Integrity: Importing reduces the risk of human error. No accidental deletions of rows, no formatting mistakes from copying, and no missed data. The data arrives exactly as it is in the source.
• Refreshable Connections: This is the biggest benefit. When your source data changes - be it an updated CSV file, a new entry in a database, or a refreshed table on a website - you can update your Excel sheet instantly by clicking "Refresh." No need to repeat the entire import process.
• Data Cleaning on Autopilot: Excel's powerful tool called Power Query works behind the scenes during the import process. It lets you automate cleaning and transformation steps (like removing columns, filtering rows, or changing text cases) so they are applied automatically every time you refresh the data.
• Handling Large Datasets: Excel can sometimes struggle when you paste millions of rows directly into a sheet. The import tools, particularly Power Query, are optimized to handle larger datasets more efficiently.

The Modern Way: Using 'Get & Transform' (Power Query)

Modern versions of Excel (Excel 2016 and newer, and Microsoft 365) have consolidated all data import features into a single, powerhouse toolset called Get & Transform Data, which is powered by Power Query. This is your command center for connecting to almost any data source you can think of.

You'll find everything you need on the Data tab in the ribbon. The main sections are:

• Get & Transform Data: A group of buttons for creating new connections to sources like text/CSV files, websites, and databases.
• Queries & Connections: This is where you manage your existing data connections and refresh them.

Nearly every import method we discuss will start from the Data > Get Data menu. Let's look at the most common scenarios.

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 Upload Data From a CSV or Text File

This is by far the most common import task. Whether you've exported data from a CRM, an analytics tool, or a payment processor, it often comes as a Comma-Separated Values (.csv) or text (.txt) file.

Bringing this data into Excel is straightforward:

Step 1: Start the Import Process

Go to the Data tab on the ribbon. Click on From Text/CSV.

Step 2: Select Your File

A file browser window will open. Navigate to the folder where your CSV or text file is saved, select it, and click Import.

Step 3: Adjust Import Settings in the Preview Window

Excel will analyze the file and show you a preview of your data in a new window. Here, you have a few essential options:

• Delimiter: This is the character used to separate your columns. For CSV files, Excel almost always correctly detects the comma. If you're using a different delimiter (like a tab, semicolon, or pipe |), you can select the right one from the dropdown menu. You'll see the preview update in real-time.
• Data Type Detection: Excel will try to automatically guess the data type for each column (e.g., Text, Whole Number, Date). The default "Based on first 200 rows" usually works well, but if you have messy data, you can choose "Based on entire dataset" for more accuracy or "Do not detect data types" if you want to set them all manually later.

Step 4: Load or Transform the Data

At the bottom-right of the preview window, you have three choices:

• Load: This is the most direct option. It will load the data into a new worksheet in Excel, formatted as an official Excel Table. This is the right choice most of the time.
• Transform Data: This is the powerful choice. It opens the Power Query Editor, a dedicated tool for cleaning and reshaping your data before it even lands in Excel. You can remove columns, filter out unwanted rows, replace values, split columns, and much more. Every step you take is recorded and will be re-applied automatically every time you refresh the data source.
• Cancel: This option closes the window without importing anything.

After clicking Load, your data will appear in a new sheet, perfectly organized into a table that you can now analyze, chart, or use in pivot tables.

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

Method 2: How to Import Data From Another Excel Workbook

Sometimes your data lives in another Excel file. For example, you might want to create a high-level summary dashboard that pulls information from a separate, more detailed workbook that a colleague updates regularly.

Here’s how to set up that connection:

1. In the Excel file where you want the data to end up, go to the Data tab.
2. Click Get Data > From File > From Workbook.
3. Locate and select the source Excel file from which you want to pull data, then click Import.
4. A Navigator window will appear, showing you all the contents of that source workbook. You'll see a list of available worksheets and any official Excel Tables within that file.
5. Click on a sheet or table name to see a preview of its data on the right.
6. Check the box next to the item(s) you want to import. A useful feature is the Select multiple items checkbox at the top, which lets you bring in several tables or sheets at once.
7. Just like with a CSV file, you can now choose to Load the data directly or Transform Data in the Power Query Editor if it needs cleaning.

Now, whenever the source workbook is updated and saved, you can go to your summary workbook, click Data > Refresh All, and all the imported tables will update with the new information.

Method 3: Importing Live Data From a Website

This is an incredibly useful Excel trick that many users don't know exists. You can pull any structured table of data from a website directly into Excel - and keep it updated.

It's perfect for tracking stock prices, sports statistics, exchange rates, or other public information from sources like Wikipedia or financial sites.

Step 1: Find the URL and Get Data

Copy the URL of the webpage that contains the data table you want to import. Then, in Excel, go to the Data tab and click From Web.

Step 2: Paste the URL

A small window will pop up. Paste the URL into the text box and click OK.

Step 3: Select the Table to Import

Excel will analyze the webpage and open the Navigator window, which shows a list of all the tables it found on that page. It sometimes also suggests tables it thinks are relevant.

• Click on each table name in the list (e.g., Table 0, Table 1). A preview will load on the right.
• You can also click the Web View tab at the top of the Navigator to see a preview of the actual webpage, with the selected table highlighted.

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

Step 4: Load or Transform the Data

Once you’ve found the correct table, check the box next to it and click Load. The table will instantly be pulled into a new worksheet. The best part? You can just hit the Refresh All button on the Data tab to get the latest version from the website at any time.

Refreshing Your Imported Data

The core advantage of using Excel's data import tools is that they create refreshable connections. Once your data is imported, maintaining it is incredibly simple.

• Manual Refresh: Navigate to the Data tab and click the large Refresh All button. Excel will reach out to all of your data sources (whether it's a local CSV file, another workbook, or a website) and pull in the latest information.
• Automatic Refresh: You can also make your data update itself. Right-click anywhere in your imported data table, go to Table > External Data Properties. In the dialog box that appears, you can set the data to Refresh every X minutes or, a very popular option, Refresh data when opening the file.

Final Thoughts

Mastering an Excel import goes beyond copy and paste, enabling you to build dynamic, refreshable reports that save you hours of manual work. By harnessing Power Query to connect to files, tables, and even websites, you can automate your data gathering process and ensure you’re always working with the most up-to-date information.

Of course, as your reporting needs grow, you might find yourself juggling dozens of data connections across many platforms. Managing these manual updates and file imports across things like Google Analytics, your ad platforms, and your CRM can be very cumbersome. That's precisely why we built Graphed. We connect directly to all your favorite marketing and sales tools and let you create powerful, live dashboards just by typing what you want to see - no need to manually import a single CSV or configure a web query ever again.