How to Merge Excel Files Without Power Query (and When Power Query Wins)
Power Query is the standard answer to "how do I merge Excel files?" It is built into Excel, it is free, and every guide written in the last few years recommends it. It is also the reason many people search for an alternative: it needs Excel, it needs about half an hour to learn, and it needs you to build a query before you can merge anything. If you need a merge once, on a computer that is not yours, or right now, Power Query is the slow way to do a fast job.
This guide shows how to merge Excel files without Power Query, compares the alternatives honestly — including the cases where Power Query is still the better choice — and helps you decide which tool fits your job. It is not an argument against Power Query. It is a map of the options, with the trade-offs stated plainly.
What Power Query does, in plain words
Power Query is a tool inside Excel that pulls data from files, folders, databases and web pages into a table, and remembers the steps so it can do them again. To merge a folder of files with Power Query, you point it at the folder, tell it which sheet to read and how to handle the headers, and it builds a table from all the files. When a new file arrives in the folder, you press Refresh, and the table updates.
That is powerful, and for a recurring job it is the best option available. It is also a real piece of work to set up. You need to know where the query editor is, how to promote a header row, how to handle files with different columns, and what to do when a file breaks the query. None of that is hard, but all of it takes time — and the first time you do it, you will spend longer learning Power Query than you would have spent merging the files by hand.
Power Query also has limits that matter. It needs Excel — the desktop app, not the free web version, for the full feature set. It runs on your computer, so a folder of very large files can be slow. And it is a query, not a file: the result lives inside a workbook, and sharing it means sharing the workbook and the query with it.
How to merge Excel files without Power Query
There are four ways to merge files without Power Query. They differ in speed, in what they need, and in how much they can handle.
1. An online merge tool. Upload the files to a website, pick a mode, download the merged workbook. This is the fastest way for a one-off merge, and it needs nothing installed. MergeExcel is one such tool: it reads .xlsx, .xls and .csv files, merges them on the server, and returns a .xlsx workbook with an audit report. The free plan merges up to 10 files at a time. You do not need Excel at all — only something to open the result with, which can be LibreOffice or Google Sheets.
2. Copy and paste. Open each file, select the data, copy it, and paste it into one workbook. This works for two files and becomes unreliable quickly: every paste is a chance to paste into the wrong column or skip a row, and there is no report of what happened. It is also slow. For more than a handful of files, do not do this.
3. Excel's Consolidate feature. Consolidate adds up numbers from several tables into one summary. It is good for totals — a budget from branch budgets, a year from monthly totals — but it does not keep the detail rows. If you need the rows, not just the sums, Consolidate is the wrong tool.
4. A small script. If you write code, a few lines of Python with a spreadsheet library can merge a folder of files. This is fast and repeatable, and it is how many data teams do it. It is also not an option for most people, and it produces no audit report unless you write one. If you do write scripts, the same rules apply: check the headers, check the row counts, and keep a record of what was merged.
| Method | Needs | Best for | Limit |
|---|---|---|---|
| Online merge tool | A browser | One-off merges, no Excel, large files | Per-merge file limits by plan |
| Copy and paste | Excel | Two files, once | Error-prone beyond a few files |
| Consolidate | Excel | Totals from identical tables | No detail rows kept |
| Power Query | Excel desktop | The same folder, every week | Learning time, needs Excel |
| A script | Coding skill | Repeatable pipelines | No report unless you build one |
Step by step: merging without Power Query
Here is the whole process with an online tool. The same steps work for any of the methods above, with the tool-specific parts swapped out.
Step 1: Gather the files. Put every file in one folder. Check that they are .xlsx, .xls or .csv files. Count them: the free plan here merges up to 10 at a time, Starter 50, Pro 200. If you have more, split them into batches, as explained in our guide to merging multiple files at once.
Step 2: Make the headers match. Open the first file and look at the header row. Open the second file and compare. Fix any spelling differences now — "Customer ID" and "Cust ID" become two columns if you do not. This step is the same whatever tool you use, including Power Query, and skipping it is the most common cause of a bad merge.
Step 3: Upload and pick a mode. Drag the files onto the upload area on the home page. Pick Separate sheets to collect the files unchanged, Append rows to stack them into one table, or Merge by ID to fold rows with the same ID together. For Append rows, turn on the "Source File" column so you can trace rows back to their files.
Step 4: Read the audit report. Before you download, read the summary: rows in, rows out, duplicates removed, rows folded by ID, rows skipped. Check that the arithmetic balances. Read the audit notes for header mismatches and empty sheets.
Step 5: Download and verify. Open the merged workbook. Count the rows. Spot-check rows you know. Sum one numeric column and compare it with the source files. Save your copy — the online copy is deleted after 72 hours.
The whole job, for a folder of ten files, takes about five minutes including the checks. The same job in Power Query takes about five minutes too — after you have spent half an hour learning it. That is the trade-off in one sentence.
When Power Query is still the better choice
An honest comparison has to say when the other tool wins. Power Query wins in three cases.
You merge the same folder every week. A saved query refreshes with one click when new files arrive. An online tool needs a fresh upload each time. If the job repeats on a schedule, the half hour you spend learning Power Query pays for itself in a month.
The files change shape. Power Query can handle files that arrive with different columns, extra sheets, or inconsistent headers, and it can be taught to clean them — trimming spaces, fixing date formats, removing blank rows — as part of the query. An online tool expects the files to be ready; it reports problems but does not clean them for you.
You need the result to stay live. A Power Query table refreshes when the source files change. A merged file from an online tool is a snapshot: if a source file changes, you merge again. For a dashboard that must stay current, Power Query is the right tool.
If none of those applies — the merge is a one-off, the files are ready, and you need the result now — the online tool is faster. And if you do not have Excel, the online tool is the only option of the two that works at all.
What about Google Sheets?
Google Sheets has its own way to combine files: the IMPORTRANGE function, which pulls a range from another spreadsheet, and the QUERY function, which can stack ranges. They work, but they are fiddly: IMPORTRANGE needs permission for each source file, and stacking more than a few ranges becomes a long formula that is hard to read and easy to break. For a folder of files, exporting them and merging them online is simpler — export each sheet as .xlsx (File, then Download), then merge the exports. See our guide on combining spreadsheets for the export steps.
There is one case where Google Sheets wins: when the files already live in Google Drive and the people who own them keep changing them. Then a live IMPORTRANGE link stays current, and a merged snapshot goes stale. For a one-off merge, the snapshot is fine.
What about desktop merge apps?
A few desktop apps merge Excel files: Bulk File Merger, RDBMerge, and others. They run on your computer, they can handle many files, and some are free. Their limits are different from an online tool's: they need installing, they need Windows or Mac, and they process files on your machine, so a very large merge is limited by your computer's memory. They are a good choice if you merge offline, or if your files cannot leave your computer for policy reasons. They are a worse choice if you merge from different computers, or if you want a report of what happened — most of them produce no audit report.
The deciding question is not which tool is best in general. It is which tool fits the constraints of your job: where the files are, how often the job repeats, whether you have Excel, and whether the result needs a record. Answer those four questions and the choice makes itself.
| Your situation | Best tool |
|---|---|
| One-off merge, no Excel, need it now | Online merge tool |
| Same folder every week, you have Excel | Power Query |
| Files cannot leave your computer | Desktop merge app |
| Files live in Google Drive and keep changing | Google Sheets IMPORTRANGE |
| Totals only, no detail rows needed | Excel Consolidate |
| Two files, once, you have Excel open | Copy and paste |
The checks that matter whatever tool you use
The tool changes; the checks do not. Every merge, by any method, should pass these five checks.
- Row count. The merged rows should equal the source rows minus duplicates, minus rows folded by ID, minus rows skipped. If the tool gives you a report, read it. If it does not — copy-and-paste gives you no report — count the rows by hand.
- Known rows. Find three rows you know and check every value.
- Edges. Look at the first and last rows. Errors cluster there.
- One sum. Add up a numeric column and compare it with the sources. A mismatch means a misaligned column or a value stored as text.
- Blanks. Filter on a column that should never be blank. Blank rows came from a file that lacked that column.
Public data publishers run the same kind of checks on every release. The U.S. Census Bureau documents its quality checks with each dataset, and the National Center for Education Statistics publishes the edit rules it applies to survey data — because a dataset is only trustworthy if it has been checked, and the checks are written down. Your merged file deserves the same treatment, even if the only reader is you.
Frequently asked questions
Can I merge Excel files without Power Query? Yes. Upload the files to an online merge tool, pick a mode, and download the merged workbook. No Excel install and no query to build. Copy-and-paste and Excel's Consolidate feature are other options, but the online tool is faster and produces an audit report.
Is Power Query free? Yes, it is built into Excel for Windows and Mac. The free web version of Excel has a limited version of it. The cost is not money but time: about half an hour to learn it well enough to merge a folder of files.
Do I need Excel to merge Excel files online? No. The merge runs on the server. You need Excel, LibreOffice or Google Sheets only to open the result — and to check it, which you should always do.
What is the easiest way to merge Excel files? For a one-off merge, an online tool: upload, pick a mode, download. For a repeating merge of the same folder, Power Query: build the query once, refresh it every week. The easiest way depends on how often the job repeats.
Can I merge CSV files without Power Query? Yes. CSV files merge the same way as Excel files in an online tool, and the result is a .xlsx workbook. See our guide on merging CSV files for the CSV-specific quirks.
Will an online tool handle 200,000 rows? Yes, on the server. The free plan accepts files up to 20 MB, Starter up to 100 MB, Pro up to 200 MB. A 200,000-row merge takes a few seconds of engine time. See the pricing page for the limits.
References
- U.S. Census Bureau, data quality and documentation: https://www.census.gov/
- National Center for Education Statistics, survey data documentation: https://nces.ed.gov/
- U.S. Bureau of Labor Statistics, published datasets: https://www.bls.gov/
- Microsoft Support, Excel help and how-to articles: https://support.microsoft.com/