Excel File Merger: Combine Spreadsheets into One

An online tool for merging Excel, CSV and ODS files: sheets from several workbooks go into one workbook, and rows of matching reports go into one combined table. Columns are matched by name rather than by order, “Total” rows and repeated headers stay out of the merge, and formatting, number and date formats are kept. You can also pull columns from another table by a key, the way VLOOKUP does.

How to merge Excel files

1
Add the files

Drop the reports — XLSX, XLS, ODS or CSV, several at once.

2
Choose what to do

Rows into one sheet, all sheets into one workbook, or pull columns in by a key.

3
Get the merged XLSX

Look at the preview and what was left out, then download the merged XLSX.

🔥 Trending right now
🗣️ Text to Speech ✨ Video Enhancer ✂️ Trim Audio ✨ Audio Enhancer 🎭 Voice Changer 🎙️ Vocal Remover 🎬 Create Video from Audio 🎬 Trim Video

Combine branch and team reports into one table

Drop Excel, CSV or ODS files here
XLSX, XLS, ODS, CSV — several at once
XLSX, XLS, ODS, CSV ·
Loading file...
0%
Don't know what to try?
950+ tools — open a surprise
🎲 Surprise me

What it does

Columns matched by name
Boston has “Amount, USD” in column five, Chicago has “Amount” in column six: in the merge it is one column. Similar names can be combined with one tap.
No totals or clutter
The title above the table, “Total” rows, headers repeated mid-export and signature lines stay out; a fresh total at the bottom follows the filter.
All sheets into one workbook
Each sheet keeps its formatting, widths, merged cells, frozen panes, Excel tables and pictures; sheet names stay within 31 characters, with no duplicates.
Formulas keep working
A reference to another sheet of the same workbook follows its new name, a row formula like =D5*E5 moves with its row; what cannot follow is kept as a value, and you see how many before downloading.
VLOOKUP between two files
The key (tax ID, SKU, email) is picked by how many rows match; unmatched rows are marked, extra rows of the other table go to a separate sheet.
XLSX, XLS, ODS and CSV together
A CSV from a non-English Excel (Windows-1251, semicolons) reads without garbled text, dates and amounts become dates and numbers; old .xls files from Excel 97–2003 work too.

When it helps

  • Combine weekly sales reports from every branch into one table.
  • Turn twelve monthly sheets of one workbook into a yearly table.
  • Stack exports from accounting, CRM and the bank where columns come in a different order.
  • Pull customers' balances from another file into your client list by tax ID.
  • Send your manager one workbook instead of ten attachments.

Why here

The merge understands what real reports look like: a title above the table, a two-row header, a total at the bottom, an Excel table, a CSV in a legacy encoding. The result was checked by opening it in Microsoft Excel — the workbook opens without “repair”, with formulas, dates and formats in place.

FAQ

The columns are in a different order in each file — will the merge line them up?

Yes: columns are matched by name, not by position. Case, extra spaces, line breaks and a trailing colon do not matter: “Amount:” and “amount” are one column. “Amount” and “Amount, USD” are combined on their own, and for pairs like “Qty” and “Quantity” a Combine button appears. A column missing from one file stays in the merge with empty cells for that file.

Will the “Total” row of every file end up in the merge?

No, unless you clear “Leave out Total rows”. A total is a row that starts with “Total”, “Grand total”, “Sum” and the like, or adds up the column above it with a SUM formula. The merge gets its own Total row with SUBTOTAL, so with a filter it counts only visible rows. Prices, percentages, dates and codes are not added up.

What happens to formulas?

In “All sheets into one workbook” formulas stay formulas: when a sheet is renamed, references to it follow, and Excel tables and names that clash get a number. A formula pointing to another workbook or to a sheet you left out keeps its last value. In the combined table a formula that works within its own row (=D5*E5) is moved with the row; others become values. You see how many became values before downloading.

How do I stack twelve sheets of one workbook into one table?

Add the workbook and choose “Rows into one sheet”: sheets with the same shape as the first table are selected automatically, while a “Lookup” or “Settings” sheet with other columns is not. Keep the sheet name in the Source column to see which month each row came from.

Is this the same as VLOOKUP?

“Pull in by a key” does what people write VLOOKUP between two files for: columns from the other table are added to the main one where the key matches. The key is picked by how many rows match; for tax IDs and phone numbers you can compare digits only. Rows without a match are marked in red, and when a key repeats in the second table the first row is used — and the page says so.

There is a title above the table and a two-row header — will it cope?

Yes. The header is the first row of captions at least half as wide as the table below it, so a title like “October report” and a “Date: 10/28/2026” line above stay a title — you can put it into the Source column. When a merged row sits above the captions (“Sales” over “Qty” and “Amount”), the columns are named “Sales / Qty” and “Sales / Amount”. An Excel table is taken exactly by its own range.

💡 Want us to improve this tool just for you?

We can! Just send us a quick message with your idea. If you'd like to discuss it in detail, leave your email and we'll get back to you. You can stay anonymous.

You May Also Like

🗄️ Microsoft Access Database Recovery 📄 Office document repair 🔓 Office unprotect ⇄ Document Compare 🌐 Document translation that keeps the layout 📮 PST and OST archives 🔏 Electronic Signature Verification 📬 Mail archive reader

How do you rate this tool?

Thank you for your rating!
Want to share more? Leave a comment!
Thank you! Your comment will appear after moderation.
Who is this tool for?
📋 Productivity
Published Updated Author: