Merge Excel workbooks
Choose two or more .xlsx or .xlsm files. Workbook order sets worksheet order.
Cell values, formulas, number formats, column widths, and row heights are copied. Charts, images, macros, conditional formatting, and named ranges are not transferred.
One workbook containing all selected sheets
This tool opens each selected Excel workbook and copies its worksheets into a new file named merged.xlsx. Worksheets follow the order of the input files, and their order within each source workbook is retained.
It combines whole worksheets; it does not append rows from similar tables or reconcile columns. If two worksheets have the same name, the later one receives a suffix based on its source file name while remaining within Excel’s 31-character sheet-name limit.
Workbook processing stays on your device
The browser reads the selected files and creates the merged workbook locally. The tool has no upload step:
- Your workbook data is processed by code running in the page.
- The merged file is created in browser memory and downloaded from the same page.
- The static page does not send the selected files to a conversion service.
- The source code is available under the MIT license for inspection.
You can inspect the browser Network panel during a merge to verify that no request contains your workbook data. View the source.
How to merge workbooks
-
Select at least two workbooks
Choose .xlsx or .xlsm files together, or drop multiple files onto the page. Arrange them in the order you want before selecting them.
-
Wait while worksheets are copied
The page opens each workbook in sequence, assigns unique worksheet names where needed, and writes a new XLSX workbook.
-
Save merged.xlsx
The download starts after the new workbook is written. The result panel shows the number of source files and worksheets and provides another download button.
FAQ
Are my Excel files uploaded?
No. Reading, copying, and writing take place in your browser. The selected workbooks are not sent to a conversion server.
What does the tool copy?
It copies cell values and formulas, number formats, column widths, and row heights. Worksheet order is retained. Formulas are copied as written, so references are not rewritten when a duplicate worksheet name has to change.
What is not transferred to the merged workbook?
Charts, embedded images, macros, conditional formatting, named ranges, and other workbook-level features are not transferred. Use Excel or another spreadsheet editor when those features must be retained.
What happens when worksheet names match?
The first worksheet keeps its name. A later collision receives a suffix based on the source file name, followed by a number if needed. Invalid characters are replaced and names are limited to 31 characters.
Does this combine rows from matching tables?
No. Each source worksheet remains a separate worksheet in the result. The tool does not append rows, match columns, deduplicate records, or calculate totals across files.
Can I merge .xls or password-protected workbooks?
The older .xls format is not supported. A password-protected workbook cannot be opened by this tool; remove the password in a spreadsheet editor before merging.
Are macros from .xlsm files retained?
No. .xlsm files are accepted as sources so their worksheet cells can be read, but the output is merged.xlsx and VBA macros are not copied.
Is there a file-size limit?
The tool does not set a fixed byte limit. All selected workbooks and the output use browser memory, so the practical limit depends on the device, browser, and workbook contents.