How to Merge Excel Files Online: The Simple Way to Combine Workbooks

If you have ever had five branch reports, ten survey batches, or a whole folder of monthly returns sitting on your computer, and one manager asking for a single master file, you know the problem. Each file looks fine on its own. Together they are a mess. You need one workbook that holds all of it, with nothing lost and nothing counted twice. This guide shows you how to merge Excel files online, step by step, in a way that works even if you have never used Power Query and do not want to learn it today.

Merging Excel files online means you upload your files to a web tool, pick how they should be joined, and download one workbook. You do not install anything, and you do not need Excel on your computer. The tool does the copy-and-paste work for you, and it does it the same way every time, which matters more than it sounds: the most common way people break a merge is by doing it by hand, file by file, and missing one row somewhere in the middle.

Why people merge Excel files

The need shows up in almost every office job. A retail chain gets one sales report per store. A school gets one attendance sheet per class. A small business gets one supplier price list per vendor. A research team gets one survey export per week. None of these files is wrong. They are just split apart, and the work that needs doing — totals, averages, a list of every customer — needs them together.

There are three good reasons to merge files instead of just opening them side by side. First, totals are only correct when the data is in one place. If you add up five files by hand, you will eventually add one file twice or skip one. Second, finding things is faster in one table: filter once, search once, sort once. Third, one file is easier to share. You send one attachment, not a zip of twelve, and nobody has to guess which file has the row they need.

There is also a reason not to merge: when the files are not the same kind of table at all. A price list and a staff rota do not belong in one table. Merging is for files that describe the same thing — the same columns, or nearly the same columns, repeated across files. If that sounds like your files, keep reading.

How merging works: the three ways to join files

Every merge tool, online or in Excel itself, joins files in one of three ways. Knowing which one you need saves most of the trouble people run into.

Separate sheets. Each file becomes one sheet in the new workbook. Nothing is changed. This is the right choice when the files are different kinds of tables, or when you just want everything in one file to send on. It is also the safest first step: you can look at the result and check that every file arrived.

Append rows. The files are stacked into one long table. This is the right choice when the files are the same kind of table — same columns, different rows. The tool lines the columns up by their header text, so it does not matter if one file puts "Total" in column B and another puts it in column D. The merged table uses the union of all headers, and a column that a file does not have stays blank for that file's rows.

Merge by ID. Rows that share the same ID are folded into one row, and every distinct value is kept. This is the right choice when the same row shows up in more than one file with different details — for example, two survey batches where the same customer answered different questions, or two supplier lists where the same product has a different price in each. Instead of picking one value and dropping the other, the merged row keeps both.

If you are not sure which one you need, start with Separate sheets. It changes nothing, so you can check the files, and then run Append rows or Merge by ID as a second step once you know the data is clean.

How to merge Excel files online, step by step

Here is the whole process with MergeExcel, which needs no account for a first try and no Excel install. The same steps work in any online merge tool, so you can follow along even if you use a different one.

Step 1: Gather your files. Put every file you want to merge in one folder. Check that they are .xlsx, .xls or .csv files. If a file is a PDF, or a scanned image, it is not a spreadsheet yet — convert it first. Count the files: the free plan here merges up to 10 files at a time, and paid plans merge more. If you have more files than the limit, split them into batches and merge the batches.

Step 2: Check the headers. Open the first file and look at the top row. That row is the header row: it names the columns. Now open the second file and compare. Do both files use the same words for the same columns? "Customer ID" in one file and "Cust ID" in another are two different columns to a merge tool, and they will end up as two columns in the result. Fix the spellings before you merge — it takes two minutes now and saves an hour of cleanup later. Also check for blank columns and for header rows repeated halfway down a file; the audit report will flag repeated headers, but it is easier to spot them first.

Step 3: Upload the files. Drag the files onto the upload area, or click to choose them. You can add files one at a time or several at once. The tool shows each file name and size so you can check that the right files arrived. If a file was added by mistake, remove it before you merge.

Step 4: Pick a merge mode. Choose Separate sheets, Append rows, or Merge by ID. For Append rows, you can also ask for a "Source File" column, which records which file each row came from — very useful when a row looks wrong later and you need to find where it came from. If you picked Merge by ID, type the exact header name of your ID column, for example "Customer ID". The name must match a header exactly, including spaces.

Step 5: Run the merge and read the report. Press Merge. A large merge takes a few seconds. When it is done, read the report before you download. It tells you how many rows went in, how many came out, how many duplicates were removed, how many rows were folded by ID, and how many rows were skipped. If the numbers do not match what you expected, stop and look at the audit notes: they list header mismatches, empty sheets and skipped rows, file by file. A merge that is wrong in a small way is worse than a merge that fails loudly, so the report is the most important part of the page.

Step 6: Download and check the result. Download the merged .xlsx file and open it. Check three things: the row count matches the report, the first and last rows look right, and a few rows you know well are present with the right values. Then save your own copy. The online copy is deleted automatically after 72 hours, so the download is your master file now.

Why online merging beats copy-and-paste

Copy-and-paste feels fast for two files. It stops being fast at five, and it stops being safe at ten. Every paste is a chance to paste into the wrong column, to skip a row, or to paste over data that was already there. An online tool does the same moves every time, and it writes a report about what it did. That report is the difference between "I think I merged everything" and "I can show that I merged everything."

There is a second reason: header matching. When you paste by hand, you line columns up by eye. When files have different column orders, your eye gets it wrong sooner or later. A merge tool lines columns up by header text, so order does not matter. And when a column is missing from one file, the tool leaves it blank and tells you, instead of shifting every value one column to the left — which is the classic copy-and-paste disaster, where every value after the missing column lands under the wrong heading.

A third reason is scale. A tool that merges on a server can handle files your browser would struggle to open, and it can merge 50 or 200 files in one run. If you merge every month, that is the difference between an afternoon of pasting and a three-minute job.

What can go wrong, and how to fix it

Most merge problems come from the files, not the tool. Here are the ones that show up most often, and the fix for each.

Headers that almost match. "Customer ID" vs "Cust ID", "Order Date" vs "Date", "Total" vs "Total ($)". The tool treats these as different columns, so your merged table gets both, and half the rows are blank in each. Fix the headers in the source files so the same column has the same name everywhere, then merge again.

A repeated header row in the middle of a file. Some exports put a header row at the top of every page. Those rows end up as data rows unless the tool skips them. MergeExcel skips rows that repeat the header and counts them in the report. If your tool does not, delete those rows from the source file first.

Blank rows and blank sheets. A file with no data rows, or a sheet with nothing in it, contributes nothing to the merge. That is fine — it is listed in the audit report as an empty sheet — but if you expected rows from that file, check that you uploaded the right sheet. Some workbooks hide the data on the second sheet.

Dates that look like text. A date written as "10/03/2026" in one file and "2026-10-03" in another may sort differently, and a date stored as text will not sort as a date at all. If dates matter to your work, make sure every file stores them the same way before you merge. The United States Census Bureau publishes its public data tables with consistent date formats for exactly this reason — a habit worth copying.

Numbers stored as text. A column of amounts where some cells are numbers and some are text will add up wrong, because text is ignored by a sum. After merging, select the amount column in Excel and check that it sums correctly. If it does not, convert the text cells to numbers in the source files and merge again.

The same ID with different values. This is not an error — it is what Merge by ID is for. But you need to know it happened. The audit report counts the cells where one ID had more than one value, so check that count. If it is much higher than you expected, the ID column may not be a real ID: maybe two different customers share a code, or the ID column has typos. The Bureau of Labor Statistics uses stable identifiers in its published datasets for the same reason: an ID only works if it means the same thing in every file.

How to check a merged file properly

A merge is only done when you have checked it. Here is a short checklist that catches most errors in under five minutes.

1. Row count. Add up the data rows in your source files. The merged row count should equal that total, minus duplicates removed, minus rows folded by ID, minus rows skipped. The report shows all four numbers. If they do not add up, read the audit notes.
2. Spot-check known rows. Pick three rows you know well — a big order, a customer with an unusual name, the first row of each file — and find them in the merged file. Check every value in those rows.
3. Check the edges. Look at the first five rows and the last five rows of the merged table. Errors cluster at the edges: a header row that slipped in as data, or a file whose rows were cut off.
4. Sum one numeric column. Add up one amount column in the merged file and compare it with the sum of the same column across the source files. If the totals differ, a column was misaligned or a value was stored as text.
5. Filter for blanks. Filter the merged table on a column that should never be blank, like the ID or the name. If rows appear with blanks there, those rows came from a file that was missing that column, or the header did not match.

If all five checks pass, the merge is good. Save the file, and keep the audit report with it — the audit report CSV is a record of what was merged and what was left out, which matters when someone asks about the numbers later.

Merging Excel files vs Power Query

Power Query is the built-in Excel feature for combining files, and it is very good at it. It is also the reason many people search for an online tool instead: Power Query needs Excel, it needs about half an hour to learn, and it needs you to set up a query for each new folder of files. If you already know Power Query and you merge the same folder every week, keep using it — it is free and it stays in your workbook.

An online tool wins in three cases. You do not have Excel, or you are on a computer that is not yours. You need the merge once, and learning a new feature for a one-off job is not worth it. Or the files are large and numerous, and you want the merge done on a server with a report, instead of in a workbook that slows down as it grows. Our guide on merging Excel files without Power Query walks through the trade-off in detail, including the exact cases where Power Query is still the better choice.

Free vs paid: what the limits mean in practice

The free plan merges up to 10 files at a time, with files up to 20 MB, and 10 merges a month. That covers most one-off jobs: a month of branch reports, a term of class lists, a survey with a handful of batches. The audit summary is shown on the result page, so you can check the merge even on the free plan.

Starter, at $9 a month, raises the limits to 100 merges a month, 50 files per merge and 100 MB per file, and adds Merge by ID, deduplication and the downloadable audit report CSV. If you merge every week, or if duplicate rows and conflicting values are a regular problem, that is the plan that pays for itself. Pro, at $19 a month, removes the monthly limit, allows 200 files per merge and 200 MB per file, keeps 90 days of history and adds API access for pipelines. See the full comparison on the pricing page.

One rule applies on every plan: a failed merge never counts. If a file cannot be read, or a merge has no data rows, or the ID column is missing, the run is not charged. You only spend runs on workbooks that were actually merged.

Frequently asked questions

Can I merge Excel files online for free? Yes. The free plan merges up to 10 files at a time, 10 times a month, with no account needed to try. You download the merged workbook from the result page. A free account adds history, so your merges are saved on your account page.

Will merging change my original files? No. The tool reads your files and builds a new workbook. Your originals are never modified, and the uploaded copies are deleted automatically after 72 hours.

Can I merge .csv files with .xlsx files? Yes. CSV files are read the same way as workbooks, and the result is always a .xlsx workbook. See our guide on merging CSV files for the details, including how commas inside quoted fields are handled.

What happens to formulas and formatting? Values are merged; formulas are read as their stored values, and cell formatting is not carried over. The merged workbook is a clean data table, which is what most people need for totals, filters and pivot tables. If you need charts or formatting preserved, merge the data first and add formatting to the result.

How large can the files be? The free plan accepts files up to 20 MB each. Starter accepts up to 100 MB, Pro up to 200 MB. Very large files — hundreds of thousands of rows — merge fine on the server, but take a little longer; the tool reports the time taken on the result page.

Is it safe to upload work files? Files are processed on our own server, never used to train models, and deleted automatically after 72 hours. You can delete any result immediately from the result page. Read the privacy policy for the full picture, and do not upload files you do not have the right to share.

References

• U.S. Census Bureau, Decennial Census data and table formats: https://www.census.gov/programs-surveys/decennial-census.html
• U.S. Bureau of Labor Statistics, published datasets and identifiers: https://www.bls.gov/
• Microsoft Support, Excel help and how-to articles: https://support.microsoft.com/