How to Combine Excel Files into One Workbook: The Complete Checklist

This is the guide to print out — or keep open in a tab — while you combine Excel files into one workbook. It covers the whole job in order: what to check before you start, how to run the merge, and how to verify the result. Each step says why it matters, so you can skip the ones that do not apply to your files and still know what you skipped.

If you want the short version first: gather the files, make the headers match, upload them to MergeExcel, pick Append rows, read the audit report, download the result, and check it. The checklist below is that sentence, expanded into the checks that make it reliable.

Before you start: the file checklist

Do these checks before you upload anything. They take ten minutes for a folder of files, and they prevent the problems that cost an hour each.

1. Count the files. How many files are there? The free plan merges up to 10 files at a time, Starter 50, Pro 200. If you have more, plan the batches now: merge in groups, then merge the group results. Our guide to merging multiple files at once shows the batch plan in detail.

2. Check the file types. The tool reads .xlsx, .xls and .csv files. Anything else — a PDF, a scanned image, a file with the wrong extension — will fail the merge. Convert it first, or leave it out.

3. Open each file and find the header row. The header row is the first row, and it should name every column. If a file has a title row above the header ("Sales Report — October"), delete the title row from a copy of the file. If a file has no header row at all, add one — a table without headers cannot be merged by header, and the tool will treat the first data row as the header.

4. Make the headers match. The same column must have the same name in every file: same words, same spelling, same spaces. "Customer ID" and "Cust ID" are two columns to a merge tool. Fix the spellings now. This is the single most valuable check in this guide.

5. Check the sheet tabs. A workbook can have many sheets, and the data may not be on the first one. Append rows and Merge by ID read only the first sheet of each file. If the data is on the second sheet, move it to the front — or use Separate sheets mode, which copies every sheet. See our guide on merging sheets from different files for the full picture, including hidden sheets.

6. Look for blank columns and blank rows. Delete empty columns that serve no purpose, and delete blank rows that contain stray spaces. A row that looks blank but contains a space is not blank to a tool, and it will be merged as an empty row.

7. Check the types. A column should be numbers in every file, or dates in every file, or text in every file. Mixed types produce wrong totals: a sum ignores text cells. In Excel, select a column and look at the status bar — if the sum is blank for cells that look like numbers, those cells are text. Convert them before you merge.

8. Save copies. Work on copies of the files, and keep the originals in a separate folder. Merging never changes your files, but a backup means a mistake costs you a re-merge, not a re-export.

Running the merge: the steps

Step 1: Upload. Drag the files onto the upload area on the home page, or click to choose them. The tool lists each file with its name and size. Check the list — the wrong month's file, or the same file twice, is easy to add and hard to notice later. Remove anything that does not belong.

Step 2: Choose the mode. Three choices, and the right one depends on what the files are:

• Separate sheets — one sheet per file, unchanged. Use it when the files are different kinds of tables, or when you want to inspect the files before deciding.
• Append rows — one long table, columns lined up by header. Use it when the files are the same kind of table. This is the mode most people need.
• Merge by ID — one row per ID, every distinct value kept. Use it when the same rows appear in several files with different details. It is a Starter and Pro feature.

If you are unsure, start with Separate sheets. It changes nothing, and you can run a second merge in another mode afterwards.

Step 3: Set the options. For Append rows, the "Source File" column records which file each row came from — turn it on whenever the files overlap, because it is the fastest way to trace a strange row. Deduplication removes duplicate rows: "all" removes rows identical in every column, and a key like "Customer ID, Order Date" removes rows that repeat the same key. Deduplication is a Starter and Pro feature. For Merge by ID, type the exact header name of the ID column.

Step 4: Run the merge. Press Merge. Small merges finish in a second or two. A merge of hundreds of thousands of rows takes longer, and the tool reports how long it took. The job runs on the server, so you can keep the page open or come back later — the result appears in "Recent merges" and on your account page.

Step 5: Read the audit report. Do not skip this. The report has the numbers that tell you whether the merge is right:

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

The arithmetic should balance: rows out equals rows in, minus duplicates, minus folded rows, minus skipped rows. Then read the audit notes. A header mismatch note names the file and the missing columns. An empty-sheet note names the file that contributed nothing. A skipped-row note counts the repeated headers. Decide for each note whether it is expected or a mistake to fix.

Verifying the result: the five-minute check

Download the merged .xlsx workbook and open it. These five checks take about five minutes and 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, download the file again — the merge is probably fine and the download was interrupted.

2. Check the edges. Look at the first five rows and the last five rows. 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 known rows. Pick three rows you know well — a large order, an unusual name, the first row of each file — and find them in the merged file. Check every value in those rows, not just the first column.

4. Sum one numeric column. Add up 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, a value was stored as text, or a duplicate was removed that should not have been. The U.S. Bureau of Labor Statistics publishes its datasets with numeric fields typed as numbers for exactly this reason: a total is only meaningful if every value in the column is a number.

5. Filter for blanks. Filter the merged table on a column that should never be blank, such as the ID or the name. Rows with blanks there came from a file that lacked that column, or whose header did not match. The audit report will name the file.

If all five checks pass, the merge is done. Save your copy — the online copy is deleted after 72 hours — and keep the audit report with it. On Starter and Pro plans the audit report downloads as a CSV, which is the record of what was merged and what was left out. When someone asks about the numbers later, that CSV is the answer.

After the merge: what to do with the workbook

A merged workbook is a starting point, not a finished product. Here is what usually comes next, and what to watch for at each step.

Sort and filter. The merged table is in file order: all of one file's rows, then all of the next file's rows. Sort it by date, by ID, or by whatever your work needs. Sorting is safe — it moves whole rows, and it cannot change the values.

Add totals. A total row at the bottom, or a pivot table on a new sheet, turns the merged table into a report. Build totals from the merged table, not from the source files — the merged table is the one you checked.

Remove the Source File column. If you added it for tracing, you can delete it before you share the file. Or keep it: it is honest, and it shows where every row came from, which a reader may appreciate.

Check for duplicates one more time. Sort the merged table by the ID column and look for rows that sit next to each other and look alike. Near-duplicates — the same customer spelled two ways, the same date in two formats — survive automatic deduplication, and a sorted table makes them visible. Our guide on merging duplicate rows explains the near-duplicate problem and how to reduce it before you merge.

Share one file. Send the merged workbook, not the folder of sources. One attachment is easier to open, easier to check, and impossible to confuse with an older version. If the recipient needs to know how the file was made, send the audit report CSV with it.

Troubleshooting: when the result looks wrong

The merged file has too few rows. A file was not read, a sheet was not the first sheet, or a file was empty. Check the audit report: it says how many files were merged and lists empty sheets. Check the file count against the number you uploaded.

The merged file has too many rows. Duplicates were not removed, or a result file was merged together with its own sources. Check whether deduplication was on, and check that the source folder did not contain an earlier merged result.

Columns are half empty. Headers were spelled differently across files, so the tool created two columns. Fix the headers and merge again. The audit report lists the mismatch per file.

Totals are too low. A column has numbers stored as text in some files. The sum ignores text cells. Convert the text to numbers in the source files and merge again — or convert the column in the merged workbook, and check the total.

A customer appears twice with different values. That is not an error — it is what Merge by ID is for. Run the merge again in Merge by ID mode with the right ID column, and the two rows will fold into one with both values kept. If you used Append rows and deduplication, the two rows are not identical, so neither was removed — which is correct behaviour for deduplication.

The merge failed. Read the error code. UNREADABLE_FILE means a file could not be read as a spreadsheet — check the file type and try opening it in Excel. EMPTY_FILE means a file was 0 bytes. NO_DATA_ROWS means no file contained any data rows. MISSING_ID_COLUMN means the ID column name did not match any header. A failed merge never counts against your monthly allowance, so fix the problem and run it again.

How much does it cost?

The free plan combines up to 10 files at a time, 10 times a month, with files up to 20 MB. That covers most one-off jobs. Starter is $9 a month: 100 merges, 50 files per merge, files up to 100 MB, plus Merge by ID, deduplication and the downloadable audit report. Pro is $19 a month: unlimited merges, 200 files per merge, files up to 200 MB, 90 days of history and API access. A failed merge never counts on any plan. The full comparison is on the pricing page.

A useful rule: if you combine files 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. The expensive part of this job is your time, not the subscription.

Frequently asked questions

How do I combine Excel files into one workbook? Gather the files, make the headers match, upload them to an online merge tool, pick Append rows, read the audit report, and download the merged workbook. The full checklist is in this guide.

Can I combine Excel files into one workbook for free? Yes. The free plan merges up to 10 files at a time, 10 times a month. No account is needed to try. A free account adds history, so your merges are saved on your account page.

What is the difference between combining into one workbook and one table? One workbook can hold many sheets — that is Separate sheets mode. One table is a single long table — that is Append rows mode. Most people who say "one workbook" mean one table, but if your files are different kinds of tables, one workbook with many sheets is the right answer.

How do I combine files with 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 the missing columns per file.

Can I combine .xls, .xlsx and .csv files together? Yes. The tool reads all three in the same merge, and the result is always a .xlsx workbook. See our guide on merging CSV files for the CSV-specific details.

Is my data safe when I combine files online? Files are processed on our own server, never used to train models, and deleted automatically after 72 hours. You can delete any result immediately from the result page. Read the privacy policy for the full picture, and do not upload files you do not have the right to share.

References

• U.S. Bureau of Labor Statistics, published datasets: https://www.bls.gov/
• U.S. Census Bureau, data documentation: https://www.census.gov/
• National Center for Education Statistics, data files and documentation: https://nces.ed.gov/
• Microsoft Support, Excel help and how-to articles: https://support.microsoft.com/