How to Combine Multiple Excel Files in Tableau

Wrestling with data split across dozens of monthly or weekly Excel reports is a common headache. Maybe you have separate sales files for each region, monthly performance exports from a platform, or P&Ls for different business units. Getting all that data into one place for a cohesive analysis often means a tedious cycle of copying, pasting, and praying you didn't miss a row. This guide shows you a much better way: combining those files directly inside Tableau, automating the process entirely.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Bother Combining Files in Tableau?

You might be wondering if it's worth learning a new process when you've already perfected your copy-paste-and-merge routine in Excel. The short answer is yes, absolutely. Moving this task into Tableau isn't just a different way of doing things - it's a fundamentally better workflow.

Here’s why:

• It Saves a Ton of Time: The most obvious benefit is the elimination of manual, repetitive work. Instead of spending 30 minutes every Monday morning combining last week's reports, you set up the connection once. From then on, any new file you drop into your folder can be automatically added to your dataset with a simple refresh.
• It Drastically Reduces Errors: Manual data consolidation is ripe for human error. A misplaced decimal, an accidental deletion of a row, or a copy-paste mistake can throw off your entire analysis. By automating the process in Tableau, you ensure every file is processed the same way every time, maintaining data integrity.
• It's Scalable: Your current process might work for three files a month, but what happens when it becomes 30? Or when your data grows from hundreds to thousands of rows? A manual approach quickly becomes unsustainable. Tableau's union feature is built to handle this growth, seamlessly incorporating new files without extra effort.
• It Keeps Your Analysis Live: When you connect to a folder of files, your Tableau dashboard can stay current. Did a teammate just upload the latest sales report? Just refresh your data source in Tableau, and your dashboards will update instantly with the new information. No need to rebuild anything.

In short, you move from being a data janitor who manually wrangles spreadsheets to an analyst who focuses on finding insights. It's a small shift in process with a massive impact on your efficiency.

Step 1: Get Your Excel Files Ready

Before you even open Tableau, a little preparation goes a long way. Tableau is powerful, but it relies on consistency. To ensure a smooth, error-free union, your Excel files need to have a uniform structure. Think of it like stacking Lego bricks - they only fit together if they have the same shape.

Store Them in a Single Folder

The first and most important rule is to put all the Excel workbooks you want to combine into one dedicated folder on your computer or a shared network drive. Tableau will point to this specific location to find the files, so don't scatter them across your desktop or in various subfolders (unless you intend to include subfolders, which is an option!).

For example, you might create a folder called "Monthly Sales Reports" and place files like Sales_2023_Jan.xlsx, Sales_2023_Feb.xlsx, and Sales_2023_Mar.xlsx inside.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Ensure Consistent Column Structure

This is the most critical part of the preparation. Every Excel file you intend to merge must have the exact same column headers, in the same order. If one file has a column named "Revenue" and another calls it "Sales Amount," Tableau will treat them as two separate columns, creating null values and messy data.

For our sales report example, every file should look like this:

Date | Region | Product_ID | Units_Sold | Revenue

Things to check:

• Column Headers: They must be identical. "Sale Date" is not the same as "Date". Be mindful of extra spaces or typos.
• Column Order: Keep the columns in the same sequence across all files for cleanliness. While Tableau can sometimes handle different orders, it's a best practice to keep them consistent.
• Data Types: Ensure a column contains the same type of data in every file. The Revenue column should always be numbers, and the Date column should always be formatted as a date.

Use The Same Sheet Name

Within each Excel workbook, the data you want to combine should live on a sheet with the same name. For example, if your sales data is on a tab called "SalesData" in the January report, it must also be on a tab named "SalesData" in the February, March, and all other reports.

If you have multiple sheets but only need to union one, this tells Tableau exactly which one to grab from each workbook.

Step 2: Combining Files in Tableau Using a Wildcard Union

Once your files are organized, the magic happens in Tableau's Data Source tab using a feature called a "wildcard union." This tells Tableau to search a folder and automatically pull together any files that match a pattern you define.

Follow these steps:

1. Connect to Your Data

Open Tableau and in the "Connect" pane on the left, select Microsoft Excel. Navigate to the folder where you stored your prepared files and select just one of them. It doesn't matter which one you choose, this just establishes the initial connection.

2. Set Up the Union

After selecting a file, you'll land on the Data Source page. You'll see the sheet(s) from your selected workbook listed on the left.

• Do not drag a sheet onto the canvas yet. Instead, find the New Union object on the left and drag it onto the canvas where it says "Drag sheets here."

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

3. Configure the Wildcard Union

A dialog box will pop up. This is where you tell Tableau how to find and combine your files.

• Click on the Wildcard tab.
• Search in: Make sure the folder path shown is the one containing all your Excel files. If not, edit it. You also have an option to "Include subfolders" if your files are organized that way.
• Matching pattern: This is the key part. You use an asterisk (*) as a wildcard to represent any characters.
• Sheets: From the dropdown, select the specific sheet name that contains the data in each file (e.g., "SalesData").

Click OK. Tableau will quickly scan the folder, find all files that match your pattern, and stitch the data from the specified sheet into a single table.

4. Verify the Union

Look at the data preview grid. You should now see the data from all your files stacked on top of each other. Even better, Tableau adds two very helpful new columns to your data source:

• Path: This column contains the full file path for each row of data, so you know exactly which Excel file it came from.
• Sheet: This shows the name of the sheet each row originated from.

These columns are invaluable for troubleshooting and can even be used in calculations. For instance, you could create a calculated field to extract the month and year directly from the filename in the Path field, saving you a step in data prep.

Troubleshooting Common Union Problems

Things don't always go perfectly on the first try. Here are solutions to a few common issues you might run into.

Mismatched Column Names or Data Types

Problem: You see extra columns filled mostly with Null values, or a field you expected to be a number shows up as a globe icon (string).

Cause: This happens when column headers aren't identical (e.g., Region vs. Store_Location) or if data types are inconsistent ($1,000 as text vs. 1000 as in a number).

Solution: The best fix is to correct the inconsistency in the source Excel files. Open the problem files and align the column names and data formats. Alternatively, for mismatched names, you can select the two columns in Tableau's Data Source tab, right-click, and choose Merge Mismatched Fields.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Files Are Not Included in the Union

Problem: You check the Path field and realize some of your Excel files are missing from the dataset.

Cause: This is usually an issue with your wildcard pattern or the specified sheet name. Your wildcard might be too specific, or the missing file might have the data on a differently named sheet (e.g., "Sheet1" instead of "SalesData").

Solution: Double-check your naming conventions for both files and sheets. Edit the union by clicking the dropdown arrow on the union object in the data source canvas and adjust your wildcard pattern or selected sheet name.

Alternative: The Manual Union for Specific Files

What if you don't need to combine all files in a folder, or your file names are completely random? For situations where you just want to combine 2-3 specific files, a manual union is quicker.

Here's how:

1. Connect to your first Excel file and drag its main data sheet onto the canvas.
2. Now, go back to the connection list and add a connection to your second Excel workbook.
3. Drag the sheet from the second workbook and drop it directly below the first sheet on the canvas. An orange "drag table to union" message will appear, signaling that you're about to stack them.
4. Repeat the process for any other files you want to include.

This method offers precise control but isn't as scalable or automated as the wildcard union. It's the perfect tool for a quick, one-off analysis combining a small, specific set of files.

Final Thoughts

Automating the consolidation of multiple Excel files with Tableau's Union feature is a game-changer for anyone who regularly works with segmented data. It frees you from the drudgery of manual data prep, reduces errors, and creates a streamlined, refreshable workflow that allows you to focus on analysis rather than assembly.

This challenge of bringing scattered data together is something we see all the time, extending far beyond just Excel files. Most marketing and sales teams are pulling data from a dozen different apps, from Google Analytics and HubSpot to Shopify and Facebook Ads. We built Graphed to solve this bigger problem. By connecting all your data sources in one place, you can skip the exporting and consolidating stages entirely and use simple, natural language to instantly build the dashboards and reports you need, getting you from data chaos straight to valuable insights in seconds.