Local spreadsheet workflows
Merge Excel sheets into one table
Merge Excel sheets into one table from all worksheets of a single XLSX file, locally in your browser. Choose Merge sheets into one to append matching tables in workbook order and download merged.xlsx.
The first non-empty worksheet supplies the header once; later headers must match exactly in value and order. Completely empty worksheets are skipped. Add source sheet column is on by default and appends worksheet names in a final Source sheet column.
Combine worksheets from one XLSX file
Ready. Input stays in your browser. Limit: 20 MB per file.
How to merge Excel sheets into one
- Choose exactly one .xlsx workbook, 20 MB or smaller, containing the worksheets you want to append.
- Keep Merge sheets into one selected. All non-empty worksheets are processed in workbook order; there is no worksheet picker.
- Make row one of every non-empty sheet the same header, with exactly matching values and column order. Keep Add source sheet column on to trace rows, or uncheck it to omit that column.
- Select Merge to XLSX and download merged.xlsx. Its Merged sheet keeps the header once and appends every sheet's data rows. Inspect the result against the source workbook.
For all tabs of one workbook, choose Merge sheets into one with exactly one XLSX file. Matching headers are required; completely empty worksheets are skipped.
Example input and output
One workbook has tabs January and February:
January: id | amount February: id | amount
A1 | 10 A2 | 20
Merge sheets into one, with Add source sheet column on:
id | amount | Source sheet
A1 | 10 | January
A2 | 20 | FebruaryLimitations to check first
This mode requires exactly one .xlsx file, 20 MB or smaller. All non-empty worksheets are included; there is no sheet selection. Headers must match exactly; there is no key-based join or duplicate removal. A workbook with no non-empty worksheets is rejected. Excel worksheet limits and browser memory apply. The other modes require at least two files and read only the first sheet of each file.
Practical tips
Remove title rows or notes above headers before merging. Keep Add source sheet column checked for traceability. Files are not uploaded. Output is values-only: formatting and charts are not preserved; formulas become cached results without recalculation, and missing cached results become blank cells. Keep your original workbook.
Frequently asked questions
Can this directly merge all tabs of one workbook?
Yes. Choose Merge sheets into one and exactly one XLSX file. All non-empty worksheets are appended in workbook order into Merged; the first non-empty sheet supplies the header once.
Can I trace each row to its source worksheet?
Yes. Add source sheet column is on by default and appends a final Source sheet column containing the worksheet name. Uncheck it to omit that column.
Do the sheet headers have to match?
Yes for Merge sheets into one and append modes. The first rows must match exactly in value and column order. The tool does not map different headers or join records by an ID column.
Does the final table keep repeated headers or duplicate records?
Merge sheets into one keeps the first non-empty worksheet header and skips the checked header of subsequent worksheets. Duplicate data rows are retained; there is no automatic deduplication.
What are the privacy, format and size limits?
Processing runs locally in your browser; files are not uploaded. Only XLSX is supported, each file must be 20 MB or smaller, and browser memory and Excel worksheet limits apply. The output is values-only, not a copy of formulas, formatting or charts.
More ways to work with these records
Merge Excel Files · Combine Multiple Excel Files 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
Compare guides
Choose the guide for your comparison task: Compare Excel files without uploading · Compare Excel formulas and detect formula replaced by value changes · Export an Excel difference report CSV · Compare two Excel files · Excel diff for XLSX workbooks · Compare Excel files on Mac. · Compare two Excel sheets · Beyond Compare alternative for Excel · Microsoft Spreadsheet Compare alternative