How to merge Excel files
Choose the files
Choose two or more files (xlsx, xls, ods or csv) and order them with the arrows.
Pick how to merge
All rows into one sheet, or every sheet as it is in one workbook.
Download
Type a file name and press “Merge and download”.
The two ways to merge
| Way | What it does | Good for |
|---|---|---|
| All rows into one sheet | Stacks the rows of every file and matches columns by heading: “City” meets “City” wherever it is, and a new heading adds a column. | Files with the same columns, like each branch’s sales or each month’s report. |
| Every sheet as it is | Copies every sheet into one workbook under its own name, or its file’s name when the file has one sheet. | Gathering separate reports into one file. |
FAQ
How do I merge Excel files into one sheet?
Choose the files, keep “All rows into one sheet” and press “Merge and download”. Each file’s first row is treated as headings, so it isn’t repeated in the middle.
What if the columns are in a different order?
No problem: columns are matched by heading, not position, ignoring extra spaces and letter case. If your files have no heading row, turn the option off to merge by column order.
How do I know which file each row came from?
Keep “Add a column with the source file name”: the file name (and sheet name when merging every sheet) appears in the first column.
Are formulas and formatting kept?
Formula results and number and date formats are kept, but not the formulas themselves, colors or fonts.
Are my files uploaded to a server?
No. The files are read and merged inside your browser and never leave your device.
