Merge Multiple Excel Files
Upload multiple Excel files and combine them into a single workbook. Stack all rows into one sheet, or keep each file as a separate sheet. Everything runs in your browser — your files never leave your device.
Drop Excel files here
or click to browse — select multiple files at once
100% private — your files never leave your browser
How to Merge Excel Files
Upload files
Drop multiple .xlsx or .xls files at once, or click to browse and select several files.
Reorder
Use the arrows to set the order of files. The first file sets the column headers in stack mode.
Choose mode
Select "Separate sheets" to keep each file's sheets distinct, or "Stack rows" to combine all data in one sheet.
Download
Click Merge & Download to get your combined Excel workbook instantly.
Common Uses for Merging Excel Files
- Monthly reports: Stack January, February, March exports into one annual dataset for pivot tables and analysis
- Regional data: Combine data from different offices, countries, or teams into a single master file
- Survey results: Merge survey exports from different time periods into one response dataset
- Consolidating workbooks: Take multiple single-sheet workbooks and combine them as separate sheets in one file
- Database exports: Merge multiple table exports into one workbook with one sheet per table
Frequently Asked Questions
How many files can I merge at once?
There is no hard limit — the tool is constrained only by your browser's available memory. Merging 10–20 files of moderate size works well in most browsers.
What is the difference between "Separate sheets" and "Stack rows"?
Separate sheets: each sheet from each file becomes its own sheet in the output workbook — useful for consolidating monthly files where each month should stay separate. Stack rows: all rows from the first sheet of each file are combined into a single sheet — useful for building a master dataset from multiple exports.
Are my files uploaded to a server?
No. All files are processed entirely in your browser using JavaScript. They never leave your device.
What happens to duplicate header rows when stacking?
In stack mode, the tool detects whether subsequent files have the same header row as the first file, and automatically skips it. This means you get a clean dataset without repeated column headers in the middle.
Can I reorder the files before merging?
Yes — use the up and down arrows next to each file in the list to change the order. The files are merged in the order shown.
Will formulas be preserved after merging?
Formulas that reference cells within the same sheet will be preserved. However, formulas that reference other sheets or external files will likely break after merging, since the sheet structure changes. Values are always preserved correctly.
Stack Rows vs Separate Sheets: Which to Choose
| Stack rows into one sheet | Keep as separate sheets | |
|---|---|---|
| What it produces | One sheet with all rows combined | One sheet per source file (or per sheet) |
| Headers | First file sets headers; duplicates in later files are skipped | Each sheet keeps its own headers |
| Use when | Building a master dataset for analysis, pivot tables, or import | Consolidating monthly reports where each month stays separate |
| Column requirement | All files must have the same columns in the same order | Files can have different columns |
| Typical example | Jan.xlsx + Feb.xlsx + Mar.xlsx → one full-year data sheet | Region-A.xlsx + Region-B.xlsx → one workbook, two sheets |
Merging 2, 3, or More Excel Files
The process is identical whether you are merging 2 files or 20. There is no extra configuration step for merging 3 files compared to merging 2 — just upload all of them at once:
- Select all files in one step: In the file picker, hold Ctrl (Windows) or Cmd (Mac) and click each file to select multiple at once, or drag them all onto the upload area together.
- Set the order: Use the arrows next to each file to set the order they will be merged. The first file's header row becomes the header row in the output (Stack mode).
- One click merges them all: Click Merge & Download — all files are processed in a single pass regardless of how many you have selected.
When merging many files (10+), the main constraint is your browser's memory. A set of 20 files at 2 MB each (40 MB total) works fine in any modern browser. If you run into issues with very large sets, merge in two batches: merge 10 files into one output, then merge that output with the next 10.
What Happens When Files Have Different Column Headers
In Stack rows mode, all files must have the same column structure. If a later file has different column names or a different column order, its data will be misaligned in the output — the tool places each row's values into the column positions set by the first file, regardless of header names. Before merging, verify that all files share identical column headers.
If your files have slightly different header names (e.g., "Customer Name" in one file and "Client Name" in another), standardise the headers in Excel first using Find & Replace, then re-run the merge.
In Separate sheets mode, columns are not affected — each sheet keeps its own headers and data exactly as they appear in the source file. This mode is safe to use even when the files have completely different structures.