Duplicate sheet names
When source files contain the same sheet name, the output must use distinct names.
Merge Excel Files and Keep Sheets
Combine Excel files into one workbook while keeping source worksheets separate. Compare output behavior, see an example, and verify formulas, formatting, and workbook features.
How to use this tool
- Select two or more XLSX or XLS files.
- Choose Keep Sheets mode.
- Arrange files in the required order.
- Merge and download the workbook.
- Open the result and verify every worksheet.
Use Keep Sheets when source workbooks have different layouts or when each worksheet must remain a separate tab. Supported sheets are copied into one new workbook and duplicate names are adjusted.
Different layouts
Unlike Append Rows, sheets do not need matching headers.
Workbook verification
Formulas, charts, macros, images, external links, and advanced styling must be checked after download.
Before and after example
Before
- January.xlsx → Summary, Sales
- February.xlsx → Summary, Sales
After
- Combined.xlsx → Summary, Sales, Summary_2, Sales_2
Troubleshooting
A worksheet is missing
The source may be protected, unsupported, or unreadable by the browser library.
Formulas changed
The browser library is not the Excel calculation engine. Verify formulas and cached values.
Charts or macros disappeared
Advanced workbook features are not guaranteed to survive browser-side processing.
Frequently asked questions
Does Keep Sheets combine all rows?
No. It keeps worksheets separate rather than appending them into one table.
Do sheets need the same headers?
No. Each worksheet may have a different structure.
Are macros preserved?
No guarantee is made for macros or other advanced workbook features.
Are files uploaded?
Spreadsheet contents are processed in the current browser tab.
What happens to duplicate sheet names?
They are renamed so the output workbook can contain every supported sheet.
Should I keep the originals?
Yes. Always keep backups and verify the generated workbook.
Related spreadsheet tools
- Merge Excel Files — Append similar tables or switch between both merge modes.
- Merge CSV Files — Combine multiple CSV exports into one worksheet.
- Split Excel by Rows — Break a large first worksheet into smaller files.