ExcelTool.io

Merge Excel Files

Combine multiple Excel files into a single workbook. Add files as separate sheets or append all data together.

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

  1. Upload files - Add two or more Excel files to merge.
  2. Choose merge mode - Select whether to add files as separate sheets or append rows.
  3. Download - Click merge to download your combined workbook.

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. 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. 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.

Frequently Asked Questions

Related Tools