Combine several .xlsx, .xlsm or .csv files into one workbook: every sheet copied in with its formatting, or one sheet from each file stacked into a single table with its columns lined up by header.
Nothing is uploaded. Your files are merged in your browser and never sent anywhere.
This tool lets you merge Excel files into one workbook in your browser: drop in two or more .xlsx, .xlsm or .csv files and either copy every worksheet of every file into one workbook, formatting included, or stack each file's rows onto a single sheet. The usual case is twelve monthly exports from the same system, each with its one sheet called Sheet1, that someone now wants as one file for the year.
merged (xlsx.com).xlsx, and your own files are left unchanged."Put all of these in one file" means Every sheet. "Give me one list I can filter and pivot" means Stack.
| Every sheet, one workbook | Stack into one sheet | |
|---|---|---|
| Sheets in the result | Every worksheet of every file, in file order | One sheet, named Merged |
| Which sheets are read | All worksheets, hidden ones included | One per file: the first visible sheet, or the one you name |
| Formatting | Kept: number formats, fonts, fills, borders, merged cells, widths, heights, frozen panes, notes, pictures, conditional formatting | Values and number formats only |
| Formulas | Kept when they refer only to their own sheet | All become their calculated values |
| Where a row came from | The sheet tab, named after the file when names clash | Column A, "Source file" |
Hidden sheets stay hidden in the merged workbook, and it opens on the first visible sheet. Stack mode's header row is bold, frozen and has filter buttons; completely empty rows are skipped.
A formula that reads only its own sheet stays a live formula. If the sheet had to be renamed, a reference to its own old name is updated with it: 'Sheet1'!B1 becomes 'January - Sheet1'!B1.
A formula that reads another sheet becomes its last calculated value, even when that sheet came from the same file. A Summary tab reading =SUM(Data!C2:C400) arrives as the number it last showed, and the result says how many formulas this happened to. The tool removes dropdown lists, conditional formats and in-workbook links that point at another sheet, so none can end up pointing at another file's sheet of the same name. It leaves out validation built on a relative cell reference, or with a formula as its number limit, rather than copy it wrong. The result counts both.
Excel tables come across as tables. When two files both have a table called Sales, the tool renames the second Sales_2 and updates the formulas on its sheet that use it. Some tables with calculated or totals columns can't be read correctly; those arrive as plain ranges with their values and formatting, and the result says how many.
Named ranges that belong to one sheet come along. If another file already used the name, formulas using it hold their values instead. Excel recalculates the merged workbook on opening.
Before you merge, the page lists what won't come across: charts, shapes and text boxes, pivot tables, slicers, sparklines, form controls and chart sheets are left out, and comment threads arrive as plain notes. An .xlsm's macros and any data connections stay behind. The merged file is always .xlsx.
The tool names each clashing sheet after its file: the file name alone for a one-sheet file, "file - sheet" for a file with several. A sheet whose name no other file uses, ignoring case, keeps it.
Twelve one-sheet exports, January.xlsx to December.xlsx, all holding Sheet1, give tabs named January to December. Q1.xlsx and Q2.xlsx, each with a Summary among several sheets, give "Q1 - Summary" and "Q2 - Summary". Names stay within Excel's 31-character limit; anything still clashing gets " (2)", " (3)".
Excel's Move or Copy names the copy "Sheet1 (2)", leaving twelve tabs to rename.
In Stack mode each sheet's header is its first row with anything in it, and columns line up by header, not position. Matching ignores upper and lower case and spaces at either end, so "Amount", "amount" and "Amount " share a column, spelled the first way the tool saw it. The tool adds a column only some files have on the right, leaves it blank for the files without it, and lists it in the result.
Power Query's Combine Files builds its column list from one sample file, the first by default, so a column that appears only in later files is dropped without a warning. It also matches headers case-sensitively, so a later file's "region" doesn't line up with the sample's "Region".
What the tool won't fix: headers spelled differently. "Qty" and "Quantity" end up as two columns, so rename one in its file before merging. A report title above the headers becomes the header row instead of the real one.
CSVs can go in alongside workbooks. The tool reads them the way the CSV to Excel converter does: it detects the delimiter (comma, semicolon, tab or pipe) and the encoding, numbers and ISO dates like 2026-03-04 become real numbers and dates, and codes with leading zeros stay text, so ZIP code 02134 doesn't lose its zero. In Every sheet mode each CSV's sheet is named after its file.
Move or Copy, for keeping sheets as tabs. Open both workbooks, right-click a sheet tab in the source, choose Move or Copy, pick the destination under To book, tick Create a copy and click OK. To copy a whole file, pick Select All Sheets from that menu first. Sheets copied together keep the formulas between them live, which this tool doesn't, so a workbook whose summary sheet reads its data sheets is better merged this way. The costs: a formula reading a sheet you didn't copy becomes a link to the source file, shown as =[January.xlsx]Rates!B2 while that file is open and as its full path once it's closed. A named range defined in both workbooks brings up the "name already exists" prompt, once per name. And Excel won't move or copy a group of sheets when any of them holds a table, so those go one at a time.
Power Query, for stacking a folder. Put the files in their own folder, then Data > Get Data > From File > From Folder, pick the folder and choose Combine > Combine & Load. Power Query adds a Source.Name column with each row's file name. Its strength is repetition: drop next month's file in the folder, click Data > Refresh All and the table updates. Keep the headers identical across files, for the sample-file reason above.
To clear orders repeated across files, run the merged file through Remove Duplicates, untick Source file and tick only the order ID column: Source file differs for every file, so with it ticked a repeat in a second file never matches the first. To go the other way and turn one workbook into a file per sheet, use Split Excel by Sheet.
Drop the files on this tool, choose Every sheet, one workbook, and download merged (xlsx.com).xlsx with every worksheet of every file in it. In Excel itself, open all the files, right-click a sheet tab, pick Move or Copy, choose the destination workbook under To book and tick Create a copy, then repeat for each file.
Use Stack into one sheet: it takes one sheet from each file and puts the rows one under another on a sheet called Merged, with the file name of each row in a Source file column. Columns with the same header line up. In Excel, Data > Get Data > From File > From Folder does the same job with Power Query.
Copy whole sheets rather than rows. The Every sheet mode keeps number formats, fonts, fills, borders, merged cells, column widths, row heights, frozen panes, notes, pictures and conditional formatting. Stacking into one sheet keeps only values and number formats, so dates stay dates but colours and borders are dropped.
Yes. Drop the CSVs in with or without .xlsx files: each CSV becomes one sheet named after the file, or its rows are stacked with the others. The delimiter and encoding are detected, and codes with leading zeros such as 02134 stay text.
Stack them by header name, not by position. The tool matches headers ignoring upper and lower case and spaces at either end, and adds a column only some files have on the right, blank for the rest. Headers spelled differently, like Qty and Quantity, still end up as two columns, so rename one before merging.
Both workbooks define a named range with the same name, and Excel asks which one the copied formulas should use, once for every clashing name. Click Yes to use the destination's name or No to rename the copy's. Check Formulas > Name Manager in both files first to see how many clashes are coming.