How to Combine Excel Files into One Workbook (Step by Step)

Combining Excel files means taking several workbooks and making one. The files might be branch reports, class lists, survey exports, or supplier price lists. Whatever they are, the goal is the same: one workbook, every row in it, nothing counted twice, and a way to check that the result is right. This guide walks through the whole job, from preparing the files to checking the finished workbook, and it explains why each step matters — so that when something looks wrong, you know where to look.

The short version is simple. Gather the files, make the headers match, upload them to MergeExcel, pick Append rows, read the audit report, and download the result. The rest of this guide is about doing that well: the checks that catch errors early, the choices that change the result, and the mistakes that turn a ten-minute job into an afternoon of cleanup.

Why combine files at all

A single file is easier to work with than a folder of files. That sounds obvious, but it is worth saying plainly, because it explains every decision in this guide. When the data is in one table, you can sort it, filter it, add it up, and search it in one place. When it is spread across twelve files, every one of those jobs has to be done twelve times, and the answers have to be added up by hand — which is where errors creep in.

Think of a teacher with one attendance sheet per class. To find how many students were absent on Tuesday, she can open six files and add six numbers, or she can open one merged file and filter it once. The second way is faster, and it is also more honest: the number comes from the data, not from a chain of hand additions that nobody can check.

The same logic applies to a shop with one sales report per branch, a charity with one donor list per event, and a research team with one survey export per week. Combining files is not about tidiness. It is about making the numbers checkable.

What "combine" can mean

Before you start, decide what the combined file should look like. There are three answers, and they produce very different results.

One workbook, many sheets. Each file becomes a sheet. The data is untouched. This is combining in the lightest sense: everything is in one file, but it is still many tables. It is the right choice when the files are different kinds of tables, or when you want to send one file instead of a folder.

One long table. The files are stacked row by row, with columns lined up by header. This is what most people mean by "combine Excel files." It works when the files are the same kind of table — same columns, different rows. A month of branch reports becomes one table with a month of rows.

One row per ID. Rows that share an ID are folded together, and every distinct value is kept. This is for files that overlap: the same customers, products or students appearing in more than one file with different details. Our guide to merging duplicate rows explains this mode in depth.

If you pick the wrong mode, the result will look wrong in an obvious way — too many sheets, or a table with the wrong shape — and you can simply run the merge again in another mode. The files are never changed, so a wrong first try costs nothing but a minute.

Step 1: Prepare the files

Good merges start before the upload. Spend five minutes here and you will save thirty later.

Put the files in one folder. Name the folder with the date or the project, so you can find it again. If you have more files than the plan allows in one merge — 10 on the free plan, 50 on Starter, 200 on Pro — split them into batches now, and merge the batches afterwards.

Check the file types. MergeExcel reads .xlsx, .xls and .csv files. A .pdf is not a spreadsheet, and neither is a scanned image. If a file is in the wrong format, convert it first. A .csv file that opens fine in Excel will merge fine here.

Open each file and look at the first row. That row is the header row. It should name every column, with no blank cells. Two things to fix now: headers that mean the same thing but are spelled differently ("Customer ID" and "Cust ID"), and columns that exist in one file but not another. The first kind creates duplicate columns in the result. The second kind is fine — the merged table will leave those cells blank — but you should know about it before you merge, not after.

Look for repeated header rows. Some exports repeat the header at the top of every page. Those rows are not data. MergeExcel skips rows that repeat the header and counts them in the audit report, but if you are using another method, delete them first.

Check for hidden sheets. A workbook can have more than one sheet, and the data you want may not be on the first one. In Separate sheets mode every sheet is copied, so nothing is lost. In Append rows and Merge by ID modes, only the first sheet of each file is used — so if the data is on the second sheet, move it to the first, or save that sheet as its own file.

Step 2: Upload the files

Drag the files onto the upload area on the home page, or click to choose them. The tool lists every file with its name and size. Check the list before you go on: it is easy to add the wrong month's file, or to add the same file twice. Remove any file that does not belong.

You can also try the sample files first. They are two small branch reports — one with columns in a different order, and one customer who appears in both files with a different phone number — so they show you exactly how header matching and Merge by ID behave. Run them in each mode once, and you will understand the tool faster than any guide can explain it.

Step 3: Pick the mode and the options

Choose the mode that matches what you decided earlier. Then set the options for that mode.

For Append rows, there are two options. The "Source File" column adds a column that records which file each row came from. Turn it on whenever the files overlap in time or content — it is the fastest way to trace a strange row back to its file. Deduplication removes duplicate rows: choose "all" to remove rows that are identical in every column, or name key columns such as "Customer ID, Order Date" to remove rows that repeat the same key. Deduplication is a Starter and Pro feature, because it changes the data — the free plan stacks rows exactly as they are.

For Merge by ID, type the exact header name of the ID column. "Customer ID" is not the same as "CustomerID" — the name must match a header exactly, spaces and all. If the tool says the column was not found, check the spelling in the source file first; it is almost always a spelling difference, not a bug.

For Separate sheets, there are no options. Every sheet is copied as-is, with its original name where possible.

Step 4: Run the merge and read the audit report

Press Merge. Small merges finish in a second or two; a merge of hundreds of thousands of rows takes longer, and the tool tells you how long it took. When the job is ready, read the report before you download anything. It has four numbers that matter:

• Rows in — the data rows read from all files.
• Rows out — the data rows in the merged workbook.
• Duplicates removed — rows dropped by deduplication.
• Rows folded by ID — rows combined into another row in Merge by ID mode.
• Rows skipped — repeated header rows, blank rows, and rows without an ID.

The arithmetic should balance: rows out equals rows in, minus duplicates removed, minus rows folded, minus rows skipped. If it does not, the audit notes will say why. The notes list header mismatches per file ("Missing columns: Notes, Region"), empty sheets, and skipped rows. Read them. A merge with a header mismatch is not broken — it is a merge you need to understand before you trust it.

The audit report can also be downloaded as a CSV on Starter and Pro plans. Keep it with the merged file. When someone asks, three months later, why a row is missing or why a total changed, the audit report is the answer. Public data publishers do the same thing: the U.S. Census Bureau documents every change it makes to a published table, because a number without a record of how it was made is a number nobody can trust.

Step 5: Check the merged workbook

Download the merged .xlsx file and open it. Do these five checks — they take about five minutes and they catch almost every error.

1. Count the rows. The row count in the file should match the "rows out" number in the report. If it does not, something went wrong in the download, not the merge — try downloading again.
2. Check the first and last rows. Errors cluster at the edges. A header row that slipped in as data will be at the top; a file that was cut off will be missing at the bottom.
3. Spot-check rows you know. Find three rows you know well — a large order, an unusual name, the first row of each file — and check every value.
4. Add up one numeric column. Sum an amount column in the merged file and compare it with the sum of the same column across the source files. If the totals differ, a column was misaligned or a value was stored as text. The Bureau of Labor Statistics publishes its datasets with numeric fields typed as numbers for exactly this reason: text that looks like a number does not add up.
5. Filter for blanks. Filter on a column that should never be blank, like the ID or the name. Rows with blanks there came from a file that lacked that column, or whose header did not match.

If all five checks pass, the merge is done. Save your copy — the online copy is deleted after 72 hours — and move on.

Common mistakes and how to avoid them

Merging files that are not the same table. A price list and a rota do not combine into a meaningful table. If the merged result has many half-empty columns, the files were not the same kind of table. Use Separate sheets instead, or merge in smaller groups of similar files.

Forgetting a file. The most common error of all. Count the files before you upload, and check the file count in the report after the merge. The report says how many files were merged; if that number is smaller than the number you meant to upload, one file was missed.

Two files with the same name. If two files are both called "report.xlsx", the tool stores them under different internal names and shows you the original names, so the merge is still correct. But your own records will be confusing. Rename files with the branch or the month before you upload: "report-north.xlsx" is better than "report (2).xlsx".

Merging the merged file again. If you merge a result file together with its own source files, every row appears twice, and deduplication will hide the mistake by removing the copies — or it will not, if you did not turn deduplication on. Keep source files and results in separate folders.

Trusting the merge without checking. The audit report exists because merges can be wrong in quiet ways. A header spelled two ways produces two half-empty columns, and the totals still look plausible. Read the report every time. It takes thirty seconds.

How combining online compares with doing it in Excel

Excel has three built-in ways to combine files: copy-and-paste, the Consolidate feature, and Power Query. Copy-and-paste is fine for two files and dangerous for ten. Consolidate is good for adding up numbers from identical tables, but it does not keep the detail rows. Power Query is the strongest option inside Excel — it can pull a whole folder of files into one table, refresh when files change, and handle messy headers — but it takes time to learn, and it needs Excel.

An online tool trades Power Query's power for speed. You do not learn anything, you do not install anything, and you get a report of what happened. That is the right trade when the merge is a one-off, when you do not have Excel on the computer you are using, or when the files are large enough that opening them all in Excel would be slow. If you merge the same folder every week and you already know Power Query, stay with it. Our guide on merging without Power Query compares the two in detail.

There is one more comparison worth making: online tools that run in the browser versus tools that run on a server. Browser tools are limited by your computer's memory — a very large file can freeze the tab. Server tools, like this one, process the files on the server, so a 200 MB file is no problem. The trade-off is that your files leave your computer, which is why the deletion policy matters: uploads and results here are deleted automatically after 72 hours, and you can delete any result immediately. Read the privacy policy for the full picture.

When to upgrade from the free plan

The free plan covers most one-off jobs: 10 merges a month, up to 10 files per merge, files up to 20 MB, and both basic modes. You will know you need Starter when one of three things happens regularly: you merge more than 10 files at a time, you need Merge by ID because the same rows appear in several files, or you need to remove duplicates and download the audit report. Starter is $9 a month for 100 merges, 50 files per merge, files up to 100 MB, and all three modes. Pro is $19 a month for unlimited merges, 200 files per merge, files up to 200 MB, 90 days of history and API access. The full comparison is on the pricing page.

A useful rule: if you merge more than twice a month, or if a bad merge would cost you more than an hour of cleanup, the paid plan is cheaper than the free one. Your time is the expensive part of this job, not the subscription.

Frequently asked questions

How do I combine Excel files into one workbook for free? Upload up to 10 files on the free plan, pick Append rows, and download the merged workbook. No account is needed to try. A free account adds history, so your merges are saved on your account page.

Can I combine .xls and .csv files together? Yes. The tool reads .xlsx, .xls and .csv files in the same merge, and the result is always a .xlsx workbook. See our guide on merging CSV files for how CSV quirks like quoted commas are handled.

Will my formatting survive the merge? Cell values are merged; cell formatting is not carried over. The result is a clean data table. If you need formatting, add it to the merged file afterwards — it is faster to format one table than to fix formatting across many files.

What if two files have the same sheet name? In Separate sheets mode, sheet names are made unique automatically — the second one gets a number, so nothing is overwritten. In Append rows and Merge by ID modes, sheet names do not matter, because only the first sheet of each file is used.

How do I combine files that have different columns? Use Append rows. The merged table uses the union of all headers, and rows from files that lack a column leave it blank. The audit report lists every missing column per file, so you can see exactly what happened.

Can I save a merge setup and reuse it next month? Saving merge configurations is a Starter and Pro feature. On the free plan, the mode and options are chosen fresh each time — which takes about ten seconds, since there are only a few settings.

References

• U.S. Census Bureau, data documentation and table formats: https://www.census.gov/
• U.S. Bureau of Labor Statistics, published datasets: https://www.bls.gov/
• U.S. National Archives, guidance on managing electronic records: https://www.archives.gov/records-mgmt
• Microsoft Support, Excel help and how-to articles: https://support.microsoft.com/