Merge multiple Excel files into one table

Append rows from several workbooks or worksheets while aligning columns with the same headers.

Windows 10/11 · Works with .xlsx files · Source files stay unchanged

BEFORE

Workbook	ID	Amount
First	A01	120
Second	A02	80

AFTER

ID	Amount
A01	120
A02	80

Illustrative sample data, not a software screenshot. Rows from both sources are appended to one table, aligned by headers.

How do I combine Excel files without copying each one?

For a few files, copy only the data rows under one header. For repeated jobs, use Power Query or select the source worksheets in DExcel and append rows by matching headers.

Simple example

Two files with 2 and 3 rows become one table with 5 rows. Combining rows does not automatically sum repeated categories.

Scope: Append rows is different from joining tables by a key. Confirm the source sheets, headers and total row count.

BEFORE

What takes time today

Monthly files copied and pasted one by one

Columns may appear in a different order

Missing columns create broken results

AFTER

What you get instead

One combined .xlsx workbook

Headers aligned automatically

Missing values kept blank instead of shifting data

HOW IT WORKS

Choose. Configure. Save.

Add up to 20 .xlsx files, or choose multiple worksheets from one workbook.

Select Vertical Append and confirm the worksheets that should participate.

Save a new combined workbook without changing the source files.

Test it with your own workbook.

Free Windows preview · .xlsx files · Review your new workbook in Excel or WPS.