Merge Excel Files – Free Online Tool
Combine multiple Excel files into one. Merge spreadsheets with same or different structures.
Example Output
Merge mode is your choice: keep each input as a separate sheet, or stack all rows into one consolidated sheet with a "source file" column.
consolidated.xlsx — one workbook, sheets renamed Jan-Dec, OR a single combined Sales sheet
What is Merge Excel Files?
Combine multiple Excel workbooks into a single .xlsx file — choose between "append as new sheets" (each source becomes a tab) or "stack rows" (all sheets concatenated into one master sheet). Everything runs locally; no uploads, no row limits beyond browser memory.
Why use this tool?
- Instant results — no waiting on a server or upload progress bar
- Touch-friendly UI, fine on phones for on-the-go edits
- No registration, account, or installation required
- Auto-detects encoding (UTF-8, Shift_JIS, GBK, Vietnamese) for CSV imports
- No file upload — confidential reports never leave your computer
How to use
- Upload multiple Excel files
- Choose merge option (sheets or rows)
- Click "Merge Files" button
- Download the combined Excel file
Examples
Monthly → yearly consolidation
Twelve monthly sales workbooks merge into one annual file with 12 sheets, ready for pivot-table analysis.
Multi-region rollup
Five regional workbooks (each with identical column layout) stack into one 50,000-row master sheet with a region column added automatically.
Header alignment
When sheets have slightly different column orders, enable "align by header name" so columns line up correctly even if positions differ.
Common use cases
- Monthly/quarterly financial consolidation
- Merging departmental survey responses into one workbook
- Combining client deliverables before reporting
- Stacking exported reports from multiple tools (Stripe, HubSpot, etc.)
- Building a single-source-of-truth file from many small ones
Troubleshooting
- Sheet names get suffixed (Sales, Sales (2), Sales (3))
- Two source files had a sheet with the same name. The merger appends `(n)` to avoid overwriting. Rename source sheets first if you want clean names.
- Columns misalign in stacked mode
- Enable "align by header name" — by default, stacking goes by column position. Header alignment matches `Email` to `Email` regardless of column order.
- Formulas disappear after merge
- Cell values are merged, but formulas referencing other sheets break. Convert formulas to values (Paste Special → Values) in each source before merging.
Frequently Asked Questions
Two modes: "by sheets" keeps each input file as a separate tab in the output workbook; "by rows" stacks rows from all files into a single sheet (requires matching column headers).
Try these related tools
Explore more Office Tools
Discover other free, privacy-first tools in Office Tools.