Excel Merge

Combines multiple Excel/CSV files into one. Three modes: vertical stacking, separate sheets, or horizontal side-by-side.

What it does

Use this to roll up monthly sales reports into a yearly file, combine customer lists from different regions, or bring several CSV exports into a single workbook.

How to use

  1. Drag files into the list.
  2. Pick a Merge Mode: Vertical, Separate Sheets or Horizontal.
  3. Set Sheets to Merge: first sheet, all sheets, or specific sheet name.
  4. Adjust the data-processing options if needed.
  5. Click Run.

You get one Excel file.

Merge modes

ModeWhat it does
Vertical MergeStacks every file's rows on top of each other. Best when files have the same structure.
Separate SheetsPuts each input file as its own tab in the output. For multiple reports in one workbook.
Horizontal MergeJoins side-by-side on a shared ID column. Similar to VLOOKUP.

Sheet selection

  • First Sheet: Only the first sheet of each file is taken.
  • All Sheets: Every sheet of every file is taken.
  • Specific Sheet Name: If every file has a sheet named (e.g. Sales), only that one is used.

Data processing options

  • Smart Merge: Aligns columns by name. Works even if files have different column orders. On by default.
  • Filter Empty Rows: Drops fully empty rows from the output.
  • Remove Duplicate Headers: Prevents the header row from repeating, keeps only one.

Examples

Roll up monthly sales into a yearly file: Add the 12 monthly xlsx files, Vertical Merge, run with defaults. One file with all twelve months.

Region reports as separate tabs: Add Marmara, Aegean and Central xlsx files, pick Separate Sheets. One workbook with three tabs.

Add orders next to customer details (horizontal): Add the two files, Horizontal Merge, Link Column customer_id. Order info gets attached next to customer info.

Pull a sheet out of each department file: Add all department files, pick "Specific Sheet Name", type Summary. Only the Summary sheet from each file is merged.

Watch out

  • In vertical mode, mismatched column names are handled by "Smart Merge", but very different structures still produce messy output.
  • Horizontal mode offers a basic VLOOKUP-like join. For real key-based joins use Excel Joiner.
  • In Separate Sheets mode the tab name comes from the filename, name clashes get a number appended.
  • Encrypted Excel files are not handled.

License

Free tier has a monthly merge cap. Office plan removes it.