How to merge Excel files

First: decide what "merge" means for your files

Almost every merge is one of two operations. Stacking appends rows vertically — for example, combining January and February sales exports that share the same columns. Joining adds columns by matching records on a shared value, like adding customer names to an orders file using a customer ID. Picking the right operation first saves you from redoing the work. If you are unsure which one you need, see join vs. stack spreadsheets.

Method 1: Copy and paste (simplest, for stacking only)

When two files have identical columns, the fastest merge is manual: open both workbooks, copy the data rows (not the header) from the second file, and paste them below the last row of the first. This works well for one-off jobs with a few hundred rows. It falls apart when columns are ordered differently, headers don't match, or you need to repeat the job every month — every paste is a chance to misalign a column silently.

Method 2: Power Query (built-in and repeatable)

Excel's built-in Power Query (Data tab → Get Data) can append multiple files or merge queries on a matching column. It is the most capable native option: it handles messy headers, remembers your steps, and refreshes when source files change. The tradeoff is a real learning curve — the interface is unintuitive the first few times, and debugging a broken query step can take longer than the merge itself. Choose Power Query when you will repeat the same merge monthly and are willing to invest an hour learning it.

Method 3: VLOOKUP or XLOOKUP formulas (joining by a key)

To pull columns from one file into another, lookup formulas are the classic answer: =XLOOKUP(A2, Orders!A:A, Orders!C:C) fetches a value from a matching row. This works for small, clean datasets, but formulas get fragile fast — #N/A errors from mismatched data types, broken references when columns are inserted, and slow recalculation on large files. If your main pain is lookup formulas, read our VLOOKUP alternative guide.

Method 4: MergeStudio (no formulas, in your browser)

MergeStudio is a free browser tool built for exactly this job: upload your files, pick how to combine them, and download one merged workbook. There are no formulas to write and nothing to install. Processing happens locally in your browser, so your files never leave your device.

1. Open the free merge tool.
2. Add your XLSX, XLS or CSV files — select several at once.
3. Choose the worksheet sources to include (separate files, or tabs inside one workbook).
4. Pick Stack Rows to append, or a join mode (Matches Only, Keep Main Sheet, Keep Everything) to combine on a shared column.
5. For a join, select the matching column for each source — headers don't need identical names.
6. Choose and reorder the output columns, preview the result, and download the merged XLSX.

Which method should you use?

• One-time stack of identical files: copy-paste is fine.
• Monthly repeat of the same merge: Power Query pays off.
• Adding a few columns via a key: XLOOKUP works for small clean files.
• Joining files on a shared column without formulas: MergeStudio is the shortest path — upload, match, download.
• Sensitive data: prefer options that process locally rather than uploading to a server.

For deeper dives, see how to merge Excel files by a common column and how to merge 3, 4, 5 or more Excel files.

Frequently asked questions

Can I merge Excel files with different columns?

Yes. For stacking, map each source's columns to a common set first. For joining, the files only need one shared matching value (like an ID or email); the rest of the columns can differ completely.

Will merging duplicate my rows?

It can, if the matching column contains duplicates — each matching pair produces a result row. Check for repeated IDs before joining, or use Matches Only to keep the output tight.

How do I merge Excel files without Power Query?

Use copy-paste for simple stacks, XLOOKUP for small joins, or a no-formula tool like MergeStudio when you want the result without learning either.

Is it safe to merge files in an online tool?

It depends on the tool. MergeStudio processes everything locally in your browser — files are never uploaded to a server — so sensitive spreadsheets stay on your device.

Can I merge more than two Excel files at once?

Yes. Both Power Query and MergeStudio handle 3+ sources in one workflow; with MergeStudio you map the matching column separately for each source.

What is the fastest way to combine monthly Excel reports?

If the columns are identical, stack the rows. For a recurring monthly job, save the workflow — Power Query queries refresh, and MergeStudio remembers your column mapping for the session.