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.

Rating
4.9(3.5K)
Monthly uses
486K
Price
Free

or drag it here

.xlsx, .xls, .csv, .ods · processed locally, never uploaded

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

What people say

Fast, no signup wall, no watermark. I have sent the Merge Excel Files link to half my department.
Ines Duarte · Accountant ·
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
Grace Adeyemi · Project Manager ·
Our IT team blocked every other online tool because they upload files. This one does not, so merge excel files finally got approved for use on real data.
Fiona Byrne · Office Manager ·

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