Merge Excel combines several spreadsheets into one workbook. It reads .xlsx, .xls, .ods and .csv files, and it works in your browser, so the files are never uploaded.
How to merge Excel files, step by step
- Press Choose spreadsheets and pick two or more files, or drop them anywhere on the page. Press Try an example to see how it works first.
- Pick how to merge. One sheet stacks every row into a single sheet. A tab each keeps every sheet whole, side by side in one workbook.
- Untick any sheet you want to leave out, and check the preview.
- Press Download workbook to save the merged .xlsx file, or CSV for a plain list.
Stacking rows from different files
When the first row holds column names, columns are matched by name, so Name, name and NAME line up even when the files put them in a different order. A column that only some files have is added, and the other rows are left blank there. The column chips above the preview show which columns are only in some of the sheets. Repeated header rows and empty rows are left out, and the Source column tells you which file and sheet each row came from.
Dates, money and other number formats are kept, so a date still reads as a date in the merged file.
Keeping each sheet as a tab
A tab each copies every sheet as it is into one workbook. Tabs are named after the file, and after the sheet when a file has more than one, with a number added when two names would clash.
Questions
Are my spreadsheets uploaded?
No. The files are read and merged by your browser, on this device.
Are formulas kept?
The merged workbook keeps the values the formulas last worked out, not the formulas themselves.
How many rows can I merge?
Up to 100,000 rows in one sheet. A very large merge can take a few seconds on an older phone.
Can I merge CSV files too?
Yes. Mix CSV, Excel and OpenDocument files in one merge. To tidy a CSV first, use the CSV cleaner.