Merge Excel Files Online
Merge and concatenate multiple Excel files into one, directly in your browser.
How to merge Excel files
- Click the upload area to add your first file. It is loaded in the browser and listed with its row and column count.
- Click + Add File to add the next file, one at a time. Use Remove next to any file you added by mistake. If the files do not all have the same columns, a note says so. They still merge, matched by column name.
- Once two or more files are listed, click Merge Files. Rows are stacked in the order the files were added, and the total row count is shown.
- Check the preview of the first 200 rows, then click Download merged to save merged_result in the same format.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
Two regional teams send in their July expense sheets. The south team lists the columns in a different order and adds a category column the north team does not use. The north file is shown below.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| rep | expense_date | amount |
|---|---|---|
| Ines | 2026-07-01 | 120.5 |
| Ines | 2026-07-08 | 33 |
| Marek | 2026-07-02 | 210 |
Settings
- File 1: north expenses (shown above)
- File 2: south expenses, columns amount, rep, expense_date, category, with rows (54.2, Kofi, 2026-07-03, meals) and (18, Kofi, 2026-07-09, parking)
Result
| rep | expense_date | amount | category |
|---|---|---|---|
| Ines | 2026-07-01 | 120.5 | NULL |
| Ines | 2026-07-08 | 33 | NULL |
| Marek | 2026-07-02 | 210 | NULL |
| Kofi | 2026-07-03 | 54.2 | meals |
| Kofi | 2026-07-09 | 18 | parking |
Columns are matched by name, not position, so the south file's amount values land under amount even though that column comes first in its file. Column order follows the first file, and category is added at the end because only the second file has it. North rows get NULL for category. Rows keep file order: first file, then second.
Working with Excel files
Each workbook contributes its first sheet only. This suits the common case of one workbook per branch, month or submitter, all built from the same template. Headers are matched by name. A template where someone renamed "Qty" to "Quantity" produces two separate columns, each partly empty, so check the column list after merging. The header must be in row 1 of each first sheet.
Values are read as they are displayed in each workbook. If one person formatted amounts as currency and another did not, that column becomes text in the merged result. Formulas contribute their last calculated values. The result is one workbook with a single Sheet1, which must stay under Excel's limit of 1,048,576 rows. If the combined data is larger, convert the workbooks to CSV and merge those instead. Formatting and other sheets in the source workbooks are not copied. Removing a workbook from the list before merging takes it out of the result.
Frequently Asked Questions
Can I merge several sheets from the same workbook?
Not directly. Only the first sheet of each workbook is read. Extract each sheet with the Excel Sheet Extractor first, then merge the extracted files.
Why did my merged Excel file end up with two similar columns?
Columns are matched by header text. If one workbook says Qty and another says Quantity, they are treated as different columns. Rename one of them first so they match.
Do all files need exactly the same columns?
No. Columns are matched by name, ignoring case. A column missing from one file is filled with NULL for that file's rows, and columns can appear in any order.
Is this a join on a key column?
No. Merge stacks rows from one file under another, which SQL calls UNION ALL. To match rows from two files on a shared ID, use the SQL Query tool with a JOIN.
Are duplicate rows removed when merging?
No. Every row from every file is kept. Run Remove Duplicates on the merged file if the inputs overlap.
Related Tools
Deduplicate Excel Files Online
Remove duplicate rows from Excel files instantly in your browser. No upload, no server — 100% private.
Sort Excel Files Online
Sort Excel files by any column, ascending or descending, directly in your browser.
Aggregate Excel Files Online
Group and aggregate Excel files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Merge CSV Files Online
Merge and concatenate multiple CSV files into one, directly in your browser.
Merge Parquet Files Online
Merge and concatenate multiple Parquet files into one, directly in your browser.
Merge JSON Files Online
Merge and concatenate multiple JSON files into one, directly in your browser.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.