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.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .ods · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
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
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