Home · Free tools · Merge Excel files
Combine Excel files into one
Merge Excel files in the browser: drop the workbooks and get one file back, either way you need it: every file as its own sheet, or every row stacked into a single table with columns matched by header name. No Power Query, no macros, and nothing is uploaded.
Add workbooks
Drop several .xlsx or .csv files here, or click to choose
Doing this every month? Do it once in TableDI 2, save it as a job, and run it again next month. Download TableDI 2 free
Nothing is uploaded. The file is read by JavaScript in this tab and never leaves your computer — no server sees it, and closing the tab throws it away.
One sheet per file, or one table
These are different jobs and people arrive looking for both.
One sheet per file keeps the files distinct inside one workbook. Twelve monthly reports become one .xlsx with twelve tabs — easier to email, easier to archive, and nothing has been reshaped. Sheet names come from the source filenames.
Stack all rows into one table is what you want before analysis: one header row, every record underneath it, ready for a pivot. Columns are matched by header name, so a file whose columns are in a different order still lands correctly, and a file with an extra column widens the table rather than corrupting it.
Why not Power Query
Excel's "From Folder" query is the right answer when you will repeat this every month on Windows with a desktop Excel license, and you are willing to maintain the query. It is a heavy answer for combining eight files once, it is awkward on a Mac, and it is unavailable on a machine that only has Excel for the web.
This page is the light answer: drop the files, take the result, close the tab. Nothing is installed and no query is left behind to break next quarter.
What is carried over, and what is not
- Values, not formulas. A formula cell contributes its last calculated result.
- No formatting. Fills, fonts, column widths and conditional formats are not carried into the new workbook. The output is a clean grid.
- Dates stay dates in the readable sense — a date-formatted cell comes out as
2026-03-15rather than 46096. - Hidden sheets are skipped when a workbook has visible ones.
Combining the same folder every month
At that point the work is not the merge, it is the routine around it. TableDI 2 is a desktop app for file work you redo every period: it keeps your sources, rules and delivery as a job, so next month you drop in the new files and run it again. Everything runs on your own machine. The files that make up the set and the way their columns line up are kept in the job, and the preflight checks next month's files against them before anything is combined.
Questions people ask
How do I combine multiple Excel files into one without VBA?
Drop them on this page and pick a mode. There is no macro to enable, no Power Query to build, and it works the same on macOS, Windows and Linux because it runs in the browser.
Will the merged workbook keep my formulas?
No — formulas are read as the values Excel last calculated. If you need live formulas across combined data, combine the data first and rebuild the calculation once on top of the result.
What if the files have their columns in a different order?
Leave "Match columns by header name" on. Columns are matched on the header text, ignoring case and surrounding spaces, so order does not matter and extra columns widen the table instead of shifting data into the wrong field.
How do I merge several Excel files into one sheet?
Drop them all and choose "one table": every row from every file is stacked into a single sheet, with columns matched by their header names rather than by position, and a column noting which file each row came from. Files with the same columns in a different order still line up.
How do I consolidate worksheets that are inside one workbook?
Drop the workbook once; every sheet in it is treated like a separate file, so "one table" stacks the sheets into a single table. That is the case Excel's own Consolidate dialog handles badly when the sheets are lists rather than summaries.
Are my files uploaded anywhere?
No. The file is read by JavaScript running in this tab, using the browser's own
DecompressionStream to unzip .xlsx and a parser that runs on your machine. The page does load two visitor counters — static.cloudflareinsights.com and this site's own /_vercel/insights — but no request carrying your data appears in the network tab while you use it. Close the tab and the data is gone.
Does it work with old .xls files?
Not directly. The .xls format is a different, binary format from Excel 97. Open it in Excel, LibreOffice or Numbers and save as .xlsx or .csv, then come back. The tool tells you this rather than failing silently.
Related
Doing this every month?
In TableDI 2 you do it once, then save it as a job. Next month you drop in the new files and run it again.
macOS, Apple silicon and Intel; Windows is in progress (what to do meanwhile). Free is not a trial — no account, no card.
Last reviewed 2026-09-11 by the TableDI team. Something wrong on this page? Tell us — it is one inbox, read by the people who build TableDI.