How to Import Multiple Excel Files into Tableau

If you've ever found yourself staring at three, five, or even twelve different monthly sales spreadsheets, you know the struggle is real. You need to see the bigger picture - the quarterly trend, the yearly performance - but all your data is trapped in separate files. You could spend hours manually copying and pasting everything into one giant "master" spreadsheet, but that's tedious, prone to errors, and just no fun. This guide will show you how to use Tableau to combine those separate files automatically, so you can get back to finding actual insights.

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

First, Let's Frame the Mismatch: Manual Work vs. Data Stack

The core problem isn't the data itself, it's the process. When your sales data for January, February, and March live in Sales_Jan.xlsx, Sales_Feb.xlsx, and Sales_Mar.xlsx respectively, your analysis is siloed. The classic approach involves:

• Opening each file one by one.
• Painstakingly copying the data.
• Pasting it into a new, consolidated sheet.
• Double-checking for formatting errors, mismatched columns, and calculation mistakes.

If a number in the January file gets updated, your master sheet is instantly out of date. This manual grind is not just time-consuming, it's a fragile system that breaks easily. Tableau offers a much cleaner, more reliable way to handle this using a feature called a Union.

What is a Union?

Forget complex jargon. A union simply means "stacking" data on top of itself. If you have tables or sheets with the exact same columns (e.g., Date, Product, Revenue, Units Sold), a union will append the rows from one table onto the end of another. It's like taking your January sales data and literally placing the February and March data right below it, all within Tableau, without altering your original Excel files.

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

Before You Start: Get Your Files in Order

To make the union process completely seamless, a little prep work goes a long way. Before you even open Tableau, ensure your Excel files are ready for a smooth integration. Think of it as organizing your ingredients before you start cooking.

1. File and Column Consistency is Crucial

Tableau is smart, but it's not a mind-reader. For a union to work perfectly, your Excel files should follow two simple rules:

• Consistent Column Headers: Each file must have the exact same column names in the same order. Sales Rep is different from SalesRep. Date is different from Sale Date. Any mismatch will cause Tableau to create separate, new columns for the non-matching headers, resulting in a messy dataset with lots of empty cells.
• Consistent Data Types: Ensure the data in each column is the same type. The 'Revenue' column should be formatted as a number in all files, not a number in one and text in another.

2. Create a Dedicated Folder

This is the secret to automating the entire process. Instead of having your monthly files scattered across your desktop or downloads folder, create one specific folder for them. For example, create a folder named Quarterly Sales Data and place Sales_Jan.xlsx, Sales_Feb.xlsx, and Sales_Mar.xlsx inside. This organizational step powers Tableau's most powerful union method.

Step-by-Step: Importing and Unioning Your Excel Files

With your files prepped and organized, you're ready to bring them into Tableau. Follow these steps carefully, and you'll have a combined dataset in minutes.

Step 1: Connect to Your Data

Open Tableau and in the "Connect" pane on the left, click on Microsoft Excel. Navigate to the folder you created in the prep stage and select just one of your files. For our example, let's start by connecting to Sales_Jan.xlsx.

Tableau will open the Data Source page, showing you the sheets available in that first Excel file.

Step 2: Drag "New Union" to the Canvas

In the left-hand pane of the Data Source page (under "Sheets"), you'll see an option called "New Union". Click and drag this option onto the main canvas area where it says "Drag sheets here."

A dialog box will pop up, which is where the magic happens. This is where you'll tell Tableau how to find and combine your other files. You have two main options: manually dragging files in or using a wildcard search.

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

Step 3: Choose Your Union Method (Wildcard is the Winner)

You can manually drag each Excel sheet from the left pane into the union dialog box. This works fine for two or three files, but it's not scalable. If you get a new file next month, you have to manually edit the union again.

The better choice by far is the Wildcard option.

Using a Wildcard Union for Automation

1. In the Union dialog box, select the Wildcard tab.
2. Tableau will likely default to the folder where your first file lives. If not, use the "Search in" dropdown to select the dedicated folder you created (e.g., Quarterly Sales Data).
3. In the "Worksheet" field, tell Tableau the naming pattern of the files you want to include. The asterisk (*) acts as a wildcard that means "match any characters." For our example, you would type: *(or whatever the sheet is named inside your files)
4. For our Excel files with names like Sales_Jan.xlsx and Sales_Feb.xlsx, you'd set the criteria in the dialog box to look for files matching Sales_*.xlsx in the selected folder.
5. Click OK.

Tableau will instantly scan the folder, find all files that match your pattern, and union their data together. If you add Sales_Apr.xlsx to that folder next month and refresh your data source in Tableau, it will be added to your dataset automatically. You've now built a report that updates itself.

Step 4: Verify Your Combined Data

Once the union is complete, you'll see your data in the preview pane at the bottom of the Data Source page. Tableau adds two helpful columns to help you verify everything worked correctly:

• Sheet: Tells you which sheet name the data came from within each file.
• Table Name / Path: Shows you the title of the source file each row came from, giving you proof that all your files were included.

You can click the column header for 'Table Name' and see a list of the Excel files that were successfully unioned. If one is missing, check your folder location and wildcard search criteria.

Troubleshooting Common Union Issues

Even with careful prep, sometimes things go crooked. Here are a couple of common issues and how to fix them.

Help! My Columns are Split and There are Nulls Everywhere!

This is the classic symptom of mismatched column headers. If one file has Revenue and another has Revenue ($), you'll get two separate columns in their dataset, a Revenue column that's null for all rows from the second file, and a Revenue ($) column that's null for all rows from the first file.

The Fix: Go back to your source Excel files and make sure the column names are identical. Alternatively, you can merge the mismatched fields directly in Tableau's Data Source page by multi-selecting both columns, right-clicking, and choosing Merge Mismatched Fields.

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

My Numbers Aren't Calculating Correctly.

This often happens when there's a data type mismatch. If the Units Sold column is a number in one file but text in another (perhaps due to an errant comma or dollar sign), Tableau will default to treating the whole column as text, preventing calculations.

The Fix: In the Tableau Data Source preview grid, click the icon at the top of the column (# for numbers, Abc for strings). You can manually change the data type here. If it fails, you likely have non-numeric text in that column in one of your source files that needs cleaning up.

Final Thoughts

Learning how to union files in Tableau is a huge step up from manual copy-paste methods. It not only saves you a massive amount of time but also creates a scalable, error-resistant process for your reporting. The next time you're faced with a folder of neatly named monthly reports, you'll know exactly how to combine them into one dynamic visualization.

While mastering unions in Tableau is a powerful skill, we know there's still a learning curve and setup time involved in traditional BI tools. We built Graphed because we believe getting insights from all your sources - be they Excel files, Google Analytics, or Shopify - should be as simple as asking a question. Instead of manually configuring unions, you can integrate your platforms and just ask, "Show me my total sales trend this quarter from my Excel files," and get a real-time dashboard built for you in seconds, saving you from the setup entirely.