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

Source sheet names are added only in Merge sheets into one mode.

Ready. Input stays in your browser. Limit: 20 MB per file.

How to merge Excel sheets into one

  1. Choose exactly one .xlsx workbook, 20 MB or smaller, containing the worksheets you want to append.
  2. Keep Merge sheets into one selected. All non-empty worksheets are processed in workbook order; there is no worksheet picker.
  3. 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.
  4. 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     | February

Limitations 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.