Merge Excel Files

Combine many workbooks into one, sheet by sheet or stacked.

Drop in as many workbooks as you like and get a single file back. Stack matching sheets into one continuous table, or keep every sheet separate with names derived from the source file. Headers are matched by name, so columns in a different order still line up.

Price
Free
Your files
Never uploaded
Runs
In your browser

or drag it here

.xlsx, .xls, .csv, .ods · up to 50 MB · processed locally, never uploaded

Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.

Files stay on your device

What it does well

  • Header matching by name, so column order differences are handled
  • Optional source-file and source-sheet provenance columns
  • Drag to reorder files and control the final row order

How to use Merge Excel Files

  1. 1

    Add every workbook you want to combine — drag a whole folder if you like.

  2. 2

    Choose stacked (one sheet) or separate sheets per source.

  3. 3

    Decide whether to add a column recording which file each row came from.

  4. 4

    Merge and download the combined workbook.

Watch a walkthrough

How to use Merge Excel Files

2 min 18 s · captions included

Watch on YouTube

Common problems and fixes

The header row repeats in the middle of the merged data.

Enable “Skip header rows after the first file”. It detects a repeated header and drops it automatically.

The result exceeds Excel’s row limit.

Turn on auto-split, which rolls over into a second sheet at 1,048,576 rows instead of failing.

Frequently asked questions

More merge & split tools

Combine dozens of workbooks into a single file, or break a large workbook into per-sheet, per-value or fixed-size chunks in seconds.

Browse Merge & Split