How to Merge Excel Files: One Workbook With Many Sheets, or One Stacked Sheet
Merge Excel files two ways: every sheet as its own tab, or all rows stacked in one sheet. What is kept, clashing names, header rows and the limits.
Updated November 7, 20269 min read
"Merge Excel files" means two different jobs, and the right one depends on what your files are. If they are different things that belong together (a budget, a forecast, a summary), you want one workbook with every sheet as its own tab. If they are the same table repeated (twelve monthly exports, one file per region), you want all the rows stacked into one sheet. The Excel merge tool does both: add the files, pick "Separate sheets" or "Stack rows into one sheet", check the preview and download one file. It all runs on your device, not our servers.
Two meanings of merging Excel files
Search results for this topic mix the two jobs together, which is why people merge files, open the result and find it is not what they wanted. Decide first, using this table.
| Your files are… | You want… | Choose in the tool |
|---|---|---|
| Different reports for one deliverable | One workbook, one tab per sheet | Separate sheets |
| The same columns, a different period or region each | One long table you can filter or pivot | Stack rows into one sheet |
| Workbooks with charts, Tables and frozen panes you need to keep | Each sheet exactly as it was | Separate sheets |
| A few CSV exports to look at together | One spreadsheet | Either, depending on whether the columns match |
Merging Excel files, step by step
Add at least two files
Open the Excel merge tool and drop in XLSX, XLSM, XLS or CSV files. They can be mixed in one merge. The tool will not run with fewer than two.
Put them in order
Drag the rows in the file list. The order of the list is the order the sheets come out in, and the order the rows are stacked in.
Choose how to combine
Under "How to combine", pick "Separate sheets" or "Stack rows into one sheet". Tick which sheets of each file to include; "All" and "None" are there for files with many tabs.
Set the options for your mode
For separate sheets, choose how the tabs are named. For stacking, choose the header row, how columns are matched and whether to add source columns.
Check the preview and download
The result preview lists the sheets or shows the row and column count before anything is built. Press "Merge & download" for a single file, named merged.xlsx unless you change it.
What is kept when sheets stay separate
In "Separate sheets" mode each sheet is copied across as it already is, not rebuilt from its values, and only the references that have to change are rewritten. As coded, that carries across:
- Fonts, fills, borders, alignment and number formats (currency, dates, percentages, custom formats).
- Column widths, row heights, merged cells, frozen panes and hidden rows or columns.
- Conditional formatting, data validation, autofilters and hyperlinks.
- Excel Tables, renamed where two files used the same table name.
- Defined names. If two files define the same name, the first keeps it for the whole workbook and the second is scoped to its own sheet, which is what Excel does when you copy a sheet between workbooks.
- Images, charts and shapes, copied with the sheets they sit on.
- Formulas, including cross-sheet formulas: a reference to a sheet that had to be renamed is rewritten, so it does not turn into #REF!.
Two exceptions are about the file format, not the tool. A CSV is plain text and has no formatting to keep. A legacy XLS file is read for its values only, so its data merges correctly but its styling does not come along; the tool shows a "Values only" badge when you add one. A macro-enabled XLSM keeps its macro project and the result downloads as .xlsm.
Stacking rows: headers and columns
Real exports are rarely identical. A column gets added in March, two swap places in July. If rows were stacked by position, March's Region would land under January's Product and the sheet would look perfectly plausible while being wrong. So the default under "Match columns" is "By header name": the tool reads each file's header row, builds the union of all columns, and leaves a cell blank where a file did not have that column.
| Setting | What it does | Use it when |
|---|---|---|
| First row is a header + By header name | Columns line up by their header text, even in a different order | Exports from the same system over time |
| First row is a header + Keep the header row only once | One header at the top; each file's own copy is skipped | Almost always; the result is ready to filter |
| Keep the header row only once, switched off | Each file's header row is written inline in the body | You want to see where each file begins |
| No header row / By position | Columns are stacked strictly by position | Fragments of one table with no headers |
| Add a source file / source sheet column | A column recording where each row came from | Whenever you might need to trace a row later |
Matching is on the header text, so "Customer" in one file and "Client" in another become two columns. Renaming one header before you merge is quicker than fixing the result. The stacked sheet is called "Merged" unless you type another name in the sheet name box. Once the files are combined there is no other way to tell which file a row came from, so add the source column; it costs one column.
When sheet names clash
Two files that both contain a sheet called Sheet1 are the normal case, not an edge case. In separate mode, the "Sheet names" setting decides what each tab is called: the sheet's own name, the file name, the file name plus the sheet, or simply numbered. Any clash gets a suffix: _2, _3 and so on, the same way Excel names a copied sheet.
Excel has rules that cause trouble when merging by hand, and the tool applies them for you. Sheet names are limited to 31 characters and cannot contain \ / ? * [ ] : so longer or invalid names are shortened and cleaned. Excel also compares names without case, so "Report" and "report" count as the same sheet and a workbook containing both gets a repair prompt; one of them is suffixed instead. The name is shortened before the suffix is added, so two long names cannot collapse into one. The file-name option works best when your files are named usefully: 2026-01.xlsx beats Copy of Book1 (3).xlsx.
Combine XLSX, XLSM, XLS and CSV files into one workbook or one stacked sheet. Free: up to 5 files, 50 MB each and 150 MB in total, up to 200,000 rows in a stacked sheet. Pro: up to 50 files. Runs on your device, not our servers.
Merge Excel filesLimits, and what the tool refuses
| Limit | Free | Pro |
|---|---|---|
| Files per merge | 5 (at least 2 are needed) | Up to 50 |
| Size of one file | 50 MB | Whatever your device can handle |
| Size of all files together | 150 MB | Whatever your device can handle |
| Rows in one stacked sheet | 200,000 | Whatever your device can handle, up to Excel's own limit |
| Sheets in one workbook | 100 | Whatever your device can handle |
A single Excel sheet holds 1,048,576 rows and 16,384 columns. A stack that would go past either is refused with a message rather than written as a file that will not open; the fix is to keep the sheets separate or merge fewer files. If one workbook is too large on its own, split it first; how that works is covered in splitting an Excel file into several files.
The picker refuses some files up front, so you are not left waiting. Password-protected workbooks cannot be read at all: remove the password in Excel first. ODS files should be saved as XLSX in LibreOffice or Google Sheets first. Word, PowerPoint and PDF files are recognised and named, not merged. If two files use different date systems (the 1904 system stores dates four years apart from the usual one), the tool warns you so dates are not silently shifted.
When the CSV merge is the better choice
If every source is a text export, the CSV merge tool skips the spreadsheet step. It can stack by header name, keep only shared columns, join two files on a key, remove duplicate rows and write CSV, TSV or JSON. On the free plan it takes up to 5 files, 25 MB each, and up to 500,000 rows. Use the Excel merger when you want an XLSX with formatting in the end, and the CSV one when the result is going to a database or script. To turn sheets into text first, use Excel to CSV; the trade-offs are in Excel to CSV and JSON.
To check a workbook before or after merging, the Excel viewer opens it on your device without installing anything.
Checks before you trust the result
- Compare the preview's row count with the sum of your sources. A file that added no rows is reported by name and sheet.
- Scroll to the junction between the first and second file in a stacked sheet and confirm the columns line up.
- Formulas in the merged workbook are recalculated when Excel opens it, so the numbers are computed against the sheets as they now stand.
- Change a setting after merging and the result is marked out of date; press "Re-apply and download" to rebuild it.
Frequently asked questions
How do I combine multiple Excel files into one?
Add the files to the merge tool, choose "Separate sheets" for one workbook with a tab per sheet, or "Stack rows into one sheet" for one long table. Check the preview and press "Merge & download" to get a single XLSX file.
How do I merge Excel files into one sheet?
Choose "Stack rows into one sheet". Every row of every ticked sheet is appended in file order. Columns are matched by header name by default, the header row is kept once, and you can add a source file column to trace each row.
Does merging keep formatting, formulas and charts?
With separate sheets, yes: formatting, Tables, conditional formatting, defined names, charts and formulas are copied across, and formulas follow renamed sheets. When rows are stacked, cell formatting is kept but formulas become their values, and charts, Tables and frozen panes from the sources are not carried into the stacked sheet.
What happens if two files have a sheet with the same name?
The clash gets a suffix such as _2 or _3. Names are compared without case and limited to 31 characters, as Excel requires, so the workbook opens without a repair prompt.
How many Excel files can I merge for free?
Up to 5 files per merge, 50 MB each and 150 MB in total, with up to 200,000 rows in a stacked sheet and 100 sheets in a workbook. Pro raises the file count to 50 and lifts the size caps to what your device can handle.
Why are my merged columns in the wrong place or blank?
Columns are matched by header text, so a differently spelled header becomes a separate column and the other files get blanks there. Rename the header in one file so they match, or switch to matching by position if the files have no headers.