Home · Free tools · Merge Excel files
Combine Excel files into one
Drop the workbooks. 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
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 pipeline around it. TableDI is a desktop spreadsheet workspace that runs entirely on your machine: it imports the files into one table, keeps the formula columns and charts you built on top, and can go get the data itself on a schedule — from an HTTP endpoint, a database over JDBC, or a mailbox — so there is no folder of downloads to merge next time.
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.
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. There is no
server call in the page — you can watch 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
Do this on your own machine instead
TableDI is a desktop spreadsheet workspace that runs entirely on your machine. Import the file, fix it, chart it — nothing is uploaded, and there is no account to create.
Free forever, not a trial — no account, no card. macOS and Windows. What the paid tier adds.
Last reviewed 2026-09-01 by the TableDI team. Something wrong on this page? Tell us — it is one inbox, read by the people who build TableDI.