Merge Excel Files
Combine multiple Excel files into a single workbook. Add files as separate sheets, append all data together, or join on a key column - with a full result preview before you download.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb · up to 50MB · or paste a file from your clipboard
How to Merge Excel Files
- Upload files - Add two or more Excel files to merge (.xlsx, .xls, .xlsm, or .xlsb).
- Pick the sheet from each file - Workbooks with several sheets get a selector, so the right table from each file is merged.
- Choose a merge mode - Separate sheets, append rows, or join on a key column.
- Check the result preview - Row and column counts, duplicates removed, unmatched join keys, and renamed headers are summarized before anything is downloaded.
- Download - Save the combined workbook as .xlsx.
Merge Modes Explained
Separate Sheets
Each uploaded file becomes a separate sheet in the merged workbook. The sheet names are based on the original file names. Use this when your files contain different types of data.
Append Rows
All data is combined into a single sheet by stacking rows. Columns are matched by header name rather than position, so a file with reordered or extra columns still lands in the right place - the merged sheet contains every unique header found across your files. Optionally remove duplicate rows in the same pass, and add source_file / source_sheet columns so every row records where it came from. Use this to combine exports that share a structure, like monthly reports.
Join on a Key Column
A database-style join, without writing a single VLOOKUP. Pick a column that exists in every file - a customer ID, SKU, order number, or email - and rows with the same key are matched up and combined into one wide row. A left join keeps every row from your first file and fills in matching columns from the others; an inner join keeps only rows whose key appears in every file. When the same key appears more than once in a file, you decide what happens: use the first match, stop with an error, or expand one-to-many like a SQL join. Use the arrows in the file list to control which file is the base of the join.
Other merge sites gate this behind a subscription or cap free joins at a megabyte. Here it runs free in your browser, at any size your machine can handle, and your data never leaves your device.
How to Merge Excel Files Without This Tool
Excel itself can combine workbooks - these are the three built-in routes and where each one struggles:
- Copy and paste - open both workbooks, select the data in one, and paste it under the other. Fine for two small files; error-prone once column orders differ or you have ten monthly exports, because nothing aligns columns by header for you.
- Move or Copy Sheet - right-click a sheet tab, choose Move or Copy…, and pick the destination workbook. This is Excel's manual version of our "separate sheets" mode, one sheet at a time.
- Power Query (Data → Get Data → From Folder) - the most capable built-in option. It can append every file in a folder and refresh later, but it needs desktop Excel on Windows, a consistent folder structure, and some learning curve for the query editor. If you just need one combined file right now, the upload-preview-download flow above is faster.
- VLOOKUP or XLOOKUP formulas - the manual equivalent of our key join. Works, but you write one formula per column you want to bring across and broken references travel with the file. Our VLOOKUP generator writes the formula for you if you prefer the formula route.
After merging, duplicates are the most common cleanup job - the remove duplicates tool dedupes the combined sheet by any columns, and sort Excel orders the result before you share it.
Frequently Asked Questions
You can merge files three ways: append rows (stack data in one sheet, columns matched by header name), add as separate sheets (each file becomes a sheet in the merged workbook), or join on a key column (match rows across files by a shared ID and combine their columns side by side).
Yes, our Excel merge tool is completely free - including the join-by-key mode that other merge sites put behind a paid plan or a 1MB free limit. No hidden fees, no file caps, and no signup required.
Yes. As soon as two or more files are loaded, the result preview shows the merged output and a summary: rows and columns in the result, duplicate rows removed, rows without a join match, and any headers that had to be renamed. Change a mode or option and the preview updates instantly.
You choose. Each uploaded file gets its own sheet selector, so you can merge the March sheet from one workbook with the March sheet from another instead of being stuck with whatever sheet happens to be first.
When appending rows, columns are matched by header name and the output contains every unique header, so files with different column orders or extra columns line up correctly. Cells without data in certain columns will be empty.
Yes - choose 'Join on a key column'. Pick a column that appears in every file (an ID, SKU, or email), and rows with the same key value are combined into one row with columns from every file. Choose a left join to keep all rows from the first file, or an inner join to keep only rows found in every file.
You pick the policy. Keep the first match (default), stop with an error so you can clean the file first, or expand one-to-many so a base row is repeated once per matching row - like a SQL join. The preview summary always reports how many duplicate key values were found.
Yes. In append mode, enable 'Add source columns' and the output gains source_file and source_sheet columns stating exactly where every row originated - useful for auditing combined monthly exports.
Yes. In append mode, tick 'Remove duplicate rows' and rows that are identical across every column are kept only once in the merged sheet. The preview summary shows how many were removed.
Your files are processed entirely in your browser and never uploaded to any server. Your data remains completely private.