Workbook Merger
Combine workbooks while keeping every sheet intact.
A structure-preserving merge: every sheet from every source file lands in one workbook, with name collisions resolved automatically and a contents sheet linking to each one. Ideal for consolidating monthly reports into a yearly file.
- Rating
- 4.8(1.2K)
- Monthly uses
- 142K
- Price
- Free
or drag it here
.xlsx, .xls, .ods · processed locally, never uploaded
Files stay on your device
What it does well
- Every sheet preserved with its own name and order
- Automatic suffixing when two sheets share a name
- Generated contents sheet with internal hyperlinks
How to use Workbook Merger
- 1
Add the workbooks to consolidate.
- 2
Set the sheet naming pattern — file name, sheet name, or both.
- 3
Enable the generated table of contents if you want one.
- 4
Download the consolidated workbook.
Watch a walkthrough
Common problems and fixes
Sheet names are truncated.
Excel caps sheet names at 31 characters. Shorten the naming pattern — using an index instead of the full file name usually solves it.
Named ranges are missing after merging.
Workbook-scoped names collide across files. Enable “Rescope names to sheet” so each one is kept with a sheet-level scope.
Frequently asked questions
What people say
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
Small thing, but the error messages actually tell you what to fix. Workbook Merger flagged a hidden character that had been breaking my lookups for weeks.
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
More merge & split tools
Combine dozens of workbooks into a single file, or break a large workbook into per-sheet, per-value or fixed-size chunks in seconds.
Browse Merge & Split