To merge Excel files, choose two or more files, put them in the order you want and pick how to merge them. Each file as its own sheet keeps every sheet with its formatting and formulas in one workbook. All rows in one sheet stacks the data of every file into a single list, matching columns by their heading even when they are in a different order.
The files are merged on your device and never uploaded.
How to use the Merge Excel Files
-
1
Choose the files
Two or more XLSX, XLS or CSV files (up to 20). Reorder them with the arrows.
-
2
Pick how to merge
A sheet per file, or all rows in one sheet with an optional “Source file” column.
-
3
Merge and download
Download one Excel file (or a CSV when the rows are stacked).
How it works
Each file is opened in your browser. In sheet mode its sheets are copied into a new workbook as they are, and sheet names come from the file names (with the sheet name added when a file has several). In row mode the first row of each sheet is read as its heading, the data rows are placed under the matching headings, and formulas are replaced by their results.
Features
-
Two ways to merge
Keep each file as a tab, or combine the data into one list.
-
Formatting kept
In sheet mode, fonts, colours, borders, number formats, column widths, merged cells and formulas are kept.
-
Columns matched by heading
“Name, Amount” and “Amount, Name” line up correctly; new columns are added at the end.
-
Mix formats
Combine XLSX, XLS and CSV files in one go.
-
Know where each row came from
An optional “Source file” column shows the file (and sheet) of every row.
-
Private
Everything happens in your browser; nothing is uploaded.
When to use it
- Combining monthly sales or expense sheets into one file.
- Joining attendance or stock lists from several branches into one list.
- Collecting form responses exported as separate CSV files.
- Putting several reports into one workbook to send by email or WhatsApp.
Privacy and file handling
- Where it runs
- Runs in your browser
- File size limit
- 20 MB per file, up to 20 files
Runs entirely in your browser. Your files and text are not uploaded to our servers.
Limitations
- Charts, pictures, pivot tables and macros are not copied.
- In row mode, headings must be spelled the same to be matched (spaces and capitals are ignored).
- Up to 20 files of up to 20 MB each; very large files need a desktop browser.
Frequently asked questions
Is it free?
You can merge 3 times a day for free. After that, each merge uses 1 credit.
Are my files uploaded?
No. The files are merged in your browser and never leave your device.
What if the columns are in a different order?
Choose “All rows in one sheet”: columns are matched by their heading, so the order in each file doesn’t matter.
Can I merge CSV and Excel files together?
Yes. XLSX, XLS and CSV files can be merged in one go.
What are the new sheets called?
Each sheet is named after its file, with the sheet name added when a file has several sheets. You can rename them in the Excel Editor.
Was this tool helpful?
Thanks for the feedback.
Last reviewed