JOIN two Excel sheets

Use Left/Inner/Right/Full joins to combine sheets by a key column (ID, email, SKU).

Quick steps

  1. Open the free Merge Sheets tool.
  2. Upload two CSV/XLSX files. Choose the left and right tables.
  3. Select the key column on each table (e.g., email).
  4. Pick join type: Left, Inner, Right, or Full.
  5. Preview the result and download as CSV/XLSX.

Which join should I use?

  • Left Join: keep all rows from the first sheet; add matches from the second. Best VLOOKUP replacement.
  • Inner Join: only rows that match on both sheets.
  • Right Join: keep all rows from the second sheet.
  • Full Join: keep all rows from both sheets.

Try it now in Merge Sheets.

Frequently Asked Questions

What is a join?

A join combines rows from two tables based on a matching key column such as ID or email.

Which join matches VLOOKUP?

A Left Join is the closest to VLOOKUP, keeping all rows from the first table and matching from the second.

Quick Links