How to Merge Multiple Excel Files Into One
Updated 2026-10-11 · Free · Works in your browser
Quick answer
To merge multiple Excel files into one workbook, drop all the files into the free online merger: each workbook is appended in order, keeping its sheets intact along with styles, data validation, tables, images, and charts. Everything runs in your browser. After merging, run a duplicate-removal pass if the files shared overlapping rows.
Skip the reading — jump straight to the free tool: Merge Excel →
How to Merge Excel Files Online (Free)
- Open the merge tool and drop in the workbooks you want to combine. Files are processed locally in your browser — nothing is uploaded.
- Arrange the order if it matters: files are appended top-to-bottom in the list, each workbook contributing its sheets in sequence.
- Start the merge — every workbook is appended to the result, its sheets preserved as-is.
- Download the combined .xlsx and check the sheet tabs: source workbooks become consecutive sheet groups in one file.
Merging preserves far more than values: styles, data validation, smart tables, images, charts, and protection settings are carried over from the source files.
Three Kinds of “Merging” — Pick the Right One
Most confusion around merging comes from mixing up three different jobs:
| You want to… | Use | Result |
|---|---|---|
| Combine several workbooks into one file, sheets kept separate | Merge Excel Files | One .xlsx with all sheets appended |
| Stack several sheets of the same file into one long table | Merge Sheets Into One | One sheet, rows stacked vertically |
| Combine two tables by a shared key column (like VLOOKUP) | Join Excel Tables | One table with matched columns side by side |
If monthly exports each contain one sheet of sales rows and you want a single running list, that is the second case — stacking. If you have quarterly workbooks and want everything in one file for archiving, that is the first.
How to Merge Workbooks in Excel Manually (For Reference)
- Open both workbooks in the same Excel instance.
- Right-click a sheet tab in the source workbook and choose Move or Copy.
- In the “To book” dropdown pick the target workbook, select where the sheet lands, and check Create a copy.
- Repeat for every sheet — then fix broken external references, because formulas pointing at the source file will show #REF! or prompt for links.
Manual moving works for two files with three sheets, but at ten workbooks it becomes click-work, and external references are where files silently break. The online merge keeps each sheet self-contained so nothing needs re-linking afterwards.
Watch duplicate sheet names when merging manually — Excel renames them with (2) suffixes, which can break formulas that reference sheet names.
After Merging: Clean Up the Combined File
Merged files usually inherit their sources’ mess. Two cleanup passes cover most cases:
- Remove duplicate rows — combining files that share overlapping records (the same customers, orders, or dates) almost always creates duplicates.
- Compare against a source file if you need proof of what changed between versions before the merge.
Tools Used in This Guide
Frequently Asked Questions
How many files can I merge at once?
The free tier merges up to 2 files per pass; Pro removes the limit. For a long list, merge in batches and merge the results.
Will formulas still work after merging?
Formulas within each sheet are preserved as written. Cross-file references become a problem only in manual merging — because each merged sheet keeps its own data, in-file formulas keep working.
Are images, charts, and tables preserved?
Yes — styles, data validation, smart tables, images, charts, and protection settings are carried over from the source workbooks.
Do the sheets stay separate?
Yes. This is workbook merging: every sheet from every file becomes a sheet tab in the output. To stack rows into one table instead, use Merge Sheets Into One.
Is my data uploaded to a server?
No. Merging happens entirely in your browser; the files never leave your device.
Related Guides
Ready to try it on your own file?
Open Merge Excel — It's Free