Merge Excel Files

1. 1

   Add two or more spreadsheets

   Drag and drop or browse for XLSX, XLSM, XLS or CSV files. Drag a row to change the order, which sets the order of the sheets in the result.

2. 2

   Choose how to combine them

   Keep every sheet separate for one workbook with many tabs, or stack the rows into a single sheet when the files are all the same kind of data.

3. 3

   Pick the sheets and options

   Tick the sheets you want from each file. For stacked rows, choose whether to match columns by header name and whether to add a column recording which file each row came from.

4. 4

   Preview and download

   Check the preview of the sheets and rows that will be in the result, then download the single XLSX file. Everything is processed on your device.

Combine multiple Excel workbooks into one, with full control over which sheets are included, how they are named and whether they stay separate or stack into a single sheet. Choose the sheets you want from each file, reorder the list by dragging, set the output filename, and preview the exact result before you download. Both XLSX and the older XLS are accepted, CSV files can be mixed in, and everything runs on your device.

• Two ways to combine — keep every sheet as its own tab in one workbook, or stack all the rows into a single sheet.
• Per-sheet selection — tick exactly the sheets you want from each file instead of taking the first one or all of them.
• Column matching by header — when stacking rows, columns line up by their header text even when files order them differently.
• Source columns — optionally record which file and which sheet every row came from.
• Sheet-name template — name the result's sheets after the sheet, the file, or both, with clashes suffixed automatically.
• Live preview — see the sheets and the row count that will be in the output before committing to a download.

Most online Excel mergers read your workbooks into a grid of values and write a new file from those values. Everything that is not a value is lost in the process: the fonts, the fills, the borders, the conditional formatting. This tool copies each sheet across as it already is and only rewrites the handful of internal references that have to change, so what arrives is what you had.

• Cell formatting — fonts, sizes, bold and italic, text colours, fill colours, borders and alignment.
• Number formats — currency, dates, percentages, accounting and any custom format you defined.
• Layout — column widths, row heights, merged cells, frozen panes and hidden rows or columns.
• Conditional formatting — colour scales, data bars, icon sets and cell rules, with the formats they point at.
• Excel Tables — carried across and renamed where two files both used the same table name.
• Defined names — kept and re-pointed, with a name defined in two files scoped to its own sheet rather than dropped.
• Autofilters, data validation and hyperlinks — all preserved, including links that point at a cell inside the workbook.
• Images, charts and shapes — copied across with the sheets they sit on.
• Cross-sheet formulas — rewritten to follow any sheet that had to be renamed, so nothing turns into #REF!.

The two modes answer different questions, and picking the right one is most of the job. Choose separate sheets when the files are different things that belong together; choose stacked rows when they are the same thing measured repeatedly.

Keep every sheet separate

Each selected sheet becomes its own tab in one workbook, in the order of your file list. This is the right choice for a reporting pack, a set of departmental returns, or any collection where the sheets are meaningfully different from one another. It is also the mode that preserves everything — Tables, frozen panes and conditional formatting all belong to a specific sheet, so they only survive when that sheet does.

Stack rows into one sheet

Every row from every selected sheet is appended into a single sheet, one after another. This is what you want for twelve monthly exports, a set of regional sales files, or anything you intend to pivot or filter as one dataset. Columns are matched by header text rather than by position, so a file that added a column in March or swapped two in July still lines up correctly — a column that only some files carry is simply blank in the rows that did not have it.

• Keep the header row once — the header is written at the top and each file's own copy is skipped, so the result is ready to filter.
• Match by header name — the default. Turn it off to stack strictly by column position when your files have no headers.
• Source file and source sheet columns — add either or both to keep track of where each row originated after the files are combined.
• Values, not formulas — stacked rows carry each formula's last calculated value, because moving a row changes what its relative references would point at.

The tool accepts exactly the formats below and refuses everything else at the file picker, with a link to the right converter — you should never pick a file, wait, and then be told it will not work.

Accepted

• XLSX — the modern Excel workbook. Everything is preserved.
• XLSM — a macro-enabled workbook. Everything is preserved and the macro project is carried across, so the result is downloaded as .xlsm.
• XLTX and XLTM — Excel templates, treated exactly as workbooks.
• XLS — the Excel 97-2003 format. Data is read correctly; formatting is not carried, because the old format stores it in a way that cannot be copied across.
• CSV — read as one sheet, with the separator detected automatically (comma, semicolon, tab or pipe). A CSV has no formatting to keep.

Refused, with somewhere to go

• ODS (OpenDocument) — open it in LibreOffice or Google Sheets and save as XLSX first.
• Numbers — export to Excel format from Numbers, then merge.
• Password-protected workbooks — remove the password in Excel first; an encrypted file cannot be read at all.
• Word and PowerPoint files — a .docx dropped here is recognised and named, with a link to the Word merger.

Merging turns a folder of spreadsheets into one thing you can share, analyse or archive. The alternative — opening each file and copying sheets by hand — is slow, and it is where the mistakes come from: a sheet pasted twice, a row missed at the bottom, a formula that quietly points at the wrong tab afterwards.

• Monthly and quarterly reporting — stack twelve exports into one dataset and pivot it once instead of twelve times.
• Team and departmental returns — collect everyone's submission into a single workbook with each contributor on their own tab.
• Client and project handoffs — send one file instead of a folder, with the formatting the client is used to still intact.
• Archiving — one workbook per year is easier to store, search and open than a hundred loose files.
• Preparing data for analysis — a single sheet with aligned columns and a source column is the shape every pivot table and BI tool wants.

An .xlsx file is a package of parts: one part per worksheet, plus shared tables that all the sheets point into for their formatting and their text. Merging correctly is a matter of copying the sheet parts across and then fixing every reference that has moved. That is what happens here, and it is why formatting survives.

What happens when you press Merge

• Each file is opened, not loaded — only the index and the sheet list are read, so listing the sheets of a 50 MB workbook is instant.
• The shared tables are combined — the formatting table and the text table from every file are merged and de-duplicated into one of each.
• Each sheet is copied across — as the bytes it already is, with only its references to those tables rewritten to their new positions.
• References are followed — formulas, defined names, conditional formatting rules, data validation and chart series all get any renamed sheet corrected.
• A sheet that needs nothing changed is not touched at all — it travels through still compressed, which is why the common case is close to instant.
• The workbook is packed and handed to you — compressed properly, so the download is a fraction of the size of what went in.

Sheets are copied across intact rather than rebuilt, so formatting survives and large workbooks merge in well under a second.

A few details decide whether a merged workbook opens cleanly, and they are the ones that are easy to get wrong by hand.

Details that matter

• Sheet names are limited to 31 characters and cannot contain \ / ? * [ ] : — longer or invalid names are shortened and cleaned automatically.
• Excel treats sheet names as case-insensitive — "Report" and "report" are the same name to Excel, so one of them is suffixed rather than left to trigger a repair prompt.
• The order of your file list is the order of the sheets — drag a row to change it before merging.
• Two files can 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.
• Formulas recalculate on open — the merged workbook asks Excel to recalculate, so the numbers you see are computed against the sheets as they now stand.
• Mixed date systems are flagged — a workbook saved with the 1904 date system stores dates differently, and you are warned rather than left with dates four years out.

A little preparation makes the difference between a merge you can use immediately and one you have to tidy up.

Tips

• Make the headers match before stacking — "Customer" in one file and "Client" in another become two columns. Renaming one first is quicker than fixing it afterwards.
• Add the source column when stacking — once the rows are combined there is no other way to tell where one came from, and it costs one column.
• Name the files usefully — with the file-name template the file names become the sheet names, so 2026-01.xlsx beats Copy of Book1 (3).xlsx.
• Deselect the sheets you do not need — a workbook full of scratch tabs merges faster and reads better without them.
• Use the preview — it shows the exact sheet list and row count, which is the quickest way to spot a file that was empty or a sheet you forgot to tick.
• Split first if a file is too large — the Excel splitter will break an oversized workbook into parts that fit.

Common uses

• Combining monthly or weekly exports into one dataset for a pivot table
• Collecting a team's individual submissions into one reporting workbook
• Consolidating regional or store-level sales files before analysis
• Building a year-end archive from twelve monthly files
• Merging a data sheet, a lookup sheet and a summary sheet into one deliverable
• Bringing several CSV exports together as one spreadsheet

• Split Excel
• Excel Viewer
• Excel to CSV
• Merge CSV
• PDF merger
• Merge Word