How to use it
- Choose the files (.xlsx, .xlsm, .csv) and set their order.
- Choose a mode: keep each sheet, or append into one sheet.
- For appending, set the number of header rows and whether to add a source column.
- Click "Merge files" and download the result.
Keep each sheet
Every sheet is copied into the new file, named after its file. Cell formatting, column widths, merged cells and same-sheet formulas are kept; formulas pointing at other sheets become values.
Append into one sheet
Rows are stacked under the first sheet’s header; later headers are skipped and formulas become values. An optional "Source" column records each row’s file and sheet. Sheets with different headers are listed so you can check the columns.
Frequently asked questions
What is not copied?
Images, charts, pivot tables, macros, conditional formatting and data validation. Old .xls files must be saved as .xlsx first.