Local spreadsheet workflows
Combine multiple Excel files into one workbook
Combine multiple Excel files into one download when you need a single handoff workbook. Choose separate output sheets to keep sources apart, or append rows when all source headers match exactly.
Both modes read only the first sheet of each input file. Separate sheets is the default and names output sheets from filenames. Neither mode copies a complete multi-sheet source workbook or preserves its formatting and charts.
Combine your XLSX files
Ready. Input stays in your browser. Limit: 20 MB per file or pasted input.
How to combine multiple excel files into one
- Choose at least two .xlsx files, each 20 MB or smaller. Put the intended data on the first sheet of every file.
- Choose Separate sheets to retain one source table per output sheet, or Append first-sheet rows for one combined table.
- For append mode, check that the first rows match exactly in value and column order. Separate-sheet mode does not require matching headers.
- Select Merge to XLSX and download merged.xlsx. Check the output sheets against the first sheets of your source files.
Need other source tabs? Split a workbook into single-sheet XLSX files before merging them.
Example input and output
east.xlsx, first sheet:
id | amount
E1 | 10
west.xlsx, first sheet:
id | amount
W1 | 20
Separate sheets: merged.xlsx has east and west worksheets.
Append rows: merged.xlsx has one Merged sheet:
id | amount
E1 | 10
W1 | 20Limitations to check first
Only .xlsx inputs and output are supported, not .xls or CSV. Each file has a 20 MB limit. Only the first sheet of each file is read, even in Separate sheets mode. The output contains values; formulas use cached results, and formatting and charts are not preserved. Excel worksheet limits and browser memory apply.
Practical tips
Choose separate sheets for tables with different layouts. For append mode, align headers before merging rather than expecting automatic column mapping. To include other source tabs, use the Split Excel File tool in sheet mode first, then select the resulting single-sheet files here.
Frequently asked questions
Does combining include every worksheet from each file?
No. Both modes read only the first sheet of each file. To include other sheets, split the source workbook by sheet first, then merge the resulting single-sheet XLSX files.
Can I keep the source tables on separate tabs?
Yes. Separate sheets mode creates one output worksheet per input file, using its first sheet. Output names come from filenames and are sanitized, shortened or suffixed when necessary.
When should I use append mode instead?
Use append mode when you need one table and the first-sheet headers match exactly in the same order. It creates one Merged sheet, keeps the first header and appends subsequent data rows.
Are formulas and formatting copied?
The merge creates values-only worksheets. Formula cells use stored results rather than preserving formulas; cells without a stored result become blank. Formatting and charts are not preserved.
Are my workbooks uploaded?
No. Workbook reading, merging and XLSX generation happen locally in your browser; files are not uploaded. Select at least two XLSX files, each 20 MB or smaller. Browser memory and Excel worksheet limits also apply.
More ways to work with these records
Merge Excel Files · Merge Excel Sheets into One · Append Excel Files
Related tools
Compare Excel files · CSV to JSON Converter · JSON to Excel Converter · Excel to JSON · Merge Excel Files · Excel Splitter