Many workbooks in. One master file out.
Drop in your Excel and CSV files. MergeExcel combines them into one clean workbook — as separate sheets, as rows stacked by matching headers, or as duplicate rows merged by ID — and hands back a row-level audit report so you can see exactly what happened.
Drop Excel or CSV files here, or click to choose
.xlsx, .xls, .csv · loading your plan…
Please note: workbooks often contain other people's work. Only upload files you have the right to share — uploads and results are deleted automatically after 72 hours, and you can delete a result immediately from the report below.
What you get from one upload
Three modes, one master file
Separate sheets keeps every file as its own sheet, Append rows stacks tables by matching column headers even when the columns arrive in a different order, and Merge by ID folds duplicate rows together while keeping every different value
Headers matched, not positions
Append rows lines up columns by their header text, so a “Total” in column D of one file and column B of another still lands in the same column — and missing columns are reported, not silently dropped
Duplicates handled honestly
One click removes duplicate rows in Append rows mode — whole-row or by the key columns you name. The audit report says exactly how many rows were removed, and why
Merge by ID keeps every value
Two survey batches with the same Customer ID but different answers? Merge by ID keeps both answers, joined with “ | ”, instead of silently overwriting the first one
An audit report with every merge
Header mismatches, duplicates removed, repeated header rows skipped, empty sheets and rows folded by ID — listed row by row, so you can check the merge instead of taking it on trust
Charged per merge, failed runs free
One successful merge costs one run: Free includes 10 a month, Starter 100, Pro is unlimited. A file that cannot be read, or a merge with no data rows, never counts
Many files in, one workbook out
The result is a plain .xlsx workbook you can open in Excel, LibreOffice or Google Sheets — no special reader, no watermark, no format change. The report on the result page shows the input and output row counts, the duplicates removed, the rows folded by ID and the rows skipped, so you can see what happened instead of taking it on trust.
Questions
What does MergeExcel do with my files?
It reads your .xlsx, .xls or .csv files and builds one merged .xlsx workbook, in the mode you pick: Separate sheets (one sheet per file, kept as-is), Append rows (tables stacked by matching column headers), or Merge by ID (rows with the same ID combined, every distinct value kept). You also get an audit report listing header mismatches, duplicates removed and rows skipped. Uploads and results are deleted automatically after 72 hours.
Which merge mode should I pick?
Separate sheets when you just want all the files in one workbook without touching the data. Append rows when the files are the same kind of table — branch reports, monthly returns, survey batches — and you want one long table. Merge by ID when the same rows appear in several files with different values, and you want one row per ID with every distinct value kept.
What happens when the headers do not match?
Append rows and Merge by ID line columns up by header text, so a different column order is fine. A column that exists in some files but not others is still in the merged table — rows from files without it simply leave it blank — and the audit report lists every missing column per file, so you can see what happened.
How does Merge by ID handle conflicting values?
Rows that share the same ID are folded into one row. For each column, every distinct non-empty value is kept, joined with “ | ”. So if two files disagree on a customer’s phone number, the merged row shows both numbers instead of silently keeping one and dropping the other. The audit report counts the cells where this happened.
How are runs counted?
One successful merge costs one run. The Free plan includes 10 runs a month, Starter 100, Pro is unlimited. The counter resets on the first of each calendar month and unused runs do not roll over. A run that fails — an unreadable file, no data rows, a missing ID column, or a fault on our side — never counts.
What if my files have different numbers of columns?
That is normal for this tool: the merged table uses the union of all headers across the files. Columns that a file does not have stay blank for its rows, and the audit report lists which columns were missing from which file.
Why do I need an account? Merging works without one.
You do not need one to try: guests merge up to 10 files at a time — up to 10 runs a month, files up to 20 MB — and get the merged workbook to download. An account adds history and the rest of the allowance, and anything you merged as a guest in this browser moves into your account when you register.
Do you keep my files?
No longer than needed. Uploads and merged files are deleted automatically after 72 hours, and you can delete any result immediately from the result page or your account page. We never use your files to train models, and we never publish, index or share them. Results are delivered on this site only — we never send them by email.