Combine multiple Excel files into one: monthly reports, branch sales, survey responses or anything else. Stack all the data into a single sheet, or keep each file’s sheets as separate tabs in one workbook. Your files never leave your computer.
No files yet.
Stacking matches columns by their header names, so the columns can be in any order in each file.
Two ways to merge
| Option | What you get | Best for |
|---|---|---|
| Stack all data into one sheet | One long table, with an optional Source file column | Monthly or branch files with the same columns |
| Keep each sheet as a tab | One workbook containing every sheet | Collecting reports in one place |
When stacking, columns are matched by their header names, so they can be in a different order in each file. Columns that only some files have are kept, and left blank for the others.
Combine files inside Excel with Power Query
For files you combine every month, Power Query does it automatically: put the files in one folder, then use Data → Get Data → From File → From Folder → Combine. Add next month’s file to the folder and click Refresh. See Power Query in Excel.
To stack two tables that are already in one workbook, Excel 365’s VSTACK function works too:
=VSTACK(Jan!A2:C100,Feb!A2:C100)Are my files safe?
Yes. Your files are opened and converted inside your own browser. They are never uploaded to this site or anywhere else, which matters for salary sheets, bank statements and customer data. You can even disconnect from the internet after the page loads, and the tool still works.
Frequently asked questions
Which file types can I merge?
Excel files (.xlsx, .xls, .xlsm), OpenDocument (.ods) and CSV files, in any mix.
Is there a limit on the number of files?
No fixed limit. Very large files depend on your computer’s memory.
Are formulas kept?
Values are kept. When stacking, formulas become their results, because the data moves to a new sheet.