How to merge Excel files into one
- Add two or more Excel or CSV files and put them in order.
- Choose how: sheets in one workbook, or rows stacked into one sheet.
- Click Merge and download the combined workbook.
Sales per branch, monthly statements, class lists, reports from several departments: data often arrives in separate files. This tool brings them together in two ways.
“Each sheet into one workbook” copies every sheet from every file into a single XLSX, keeping values and formatting; handy for sending one file to your accountant. “Stack all rows into one sheet” puts the tables end to end for one consolidated dataset: columns are matched by header name, even if their order differs between files.
When stacking, choose every sheet or only the first sheet of each file, and add a column with the source file name so you know where each row came from (for example, which branch). Before stacking, check that the same column is named the same way in every file (for example “Amount” everywhere), since that is how columns are matched.
Up to 50 XLSX, XLSM or CSV files of 300 MB; deleted automatically after 30 minutes.
Frequently asked questions
How do I merge XLSX files into one workbook?
Drop all the .xlsx files, keep “Each sheet into one workbook” and click Merge: every sheet of every file lands in a single workbook. Choose “Stack all rows into one sheet” to get one combined table instead.
What is the difference between the two modes?
The first keeps each sheet separate inside one workbook; the second puts all rows one under another in a single sheet.
My columns are in a different order. Is that a problem?
No, when stacking, columns are matched by their header name.
Can I tell which file each row came from?
Yes, tick “Add a column with the file name” in stack mode.
Can I merge CSV and Excel files together?
Yes, you can mix XLSX, XLSM and CSV files.
How many files can I merge?
Up to 50 files of 300 MB each, free and with no sign-up.