Merge multiple Excel files into one sheet

You don't want a workbook with ten tabs — you want one sheet with all the rows stacked together, under a single header. That's what this guide covers: combining several Excel files into one continuous sheet, with columns lining up correctly.

The 30-second way: append rows online

SheetToolkit's Merge tool has a mode built exactly for this, called Append rows:

  1. Open the Merge tool and drop in your files (.xlsx, .xls or .csv, mixed freely).
  2. Leave the mode on Append rows — every row from every file is stacked into one sheet, under one shared header.
  3. Columns are matched by header name, not position. A file with Email | Name instead of Name | Email still lands correctly, and a missing column simply stays blank instead of shifting your data.
  4. Optional: tick Add source column to record which file each row came from — invaluable when you merge monthly exports. Tick Remove duplicate rows to dedupe in the same pass.
  5. Download your single-sheet .xlsx.

Everything runs locally in your browser — no upload, no account. Free up to 3 files.

The Excel-native way: Power Query

For a recurring merge of consistent files:

  1. Place the files in one folder → Data → Get Data → From File → From Folder.
  2. Combine & Transform → Excel appends them into one query → Close & Load into a single sheet.
  3. Add new files to the folder and click Refresh next time.

It expects identical headers in every file — mismatched names create stray columns. Setup takes a few minutes but pays off if you do this monthly.

The manual way: copy-paste

Fine for two small files: copy the data rows (not the header) of file B and paste below the last row of file A. Beyond that, it's slow and the classic mistake — columns in a different order — silently corrupts your data. Check the column order before every paste.

Common pitfalls when stacking files into one sheet

  • Different column orders → data lands in the wrong column. Fix: merge by header name (Method 1 does it automatically).
  • Repeated header rows in the middle of your data → filter them out, or use a tool that skips them.
  • Duplicates across files → the same record exported twice ends up twice. Use the dedupe option while merging, or remove duplicates afterwards.
  • Mixed formats (.csv + .xlsx) → Excel handles this poorly by hand; an online merge tool doesn't care.

FAQ

How do I combine multiple Excel files into one sheet without copy-paste?
Use a merge tool with an "append rows" mode, or Power Query's From Folder. Both stack all rows under one header automatically.
Will the columns line up if my files have different column orders?
With SheetToolkit, yes — columns are matched by header name. With copy-paste, no — that's the most common source of silent errors.
Can I keep track of which file each row came from?
Yes — enable the "Add source column" option and each row gets tagged with its source filename.
How many files can I merge at once?
Free: up to 3 files. Power Query: a whole folder. For bigger one-off jobs, SheetToolkit Pro removes the limit.

Related guides