Excel Joiner

Joins two Excel/CSV files side-by-side on a shared key column. The bulk, powerful version of Excel's VLOOKUP formula.

What it does

Use this to attach customer details to an order list, look up product prices by code, or paste rep names onto call records. Instead of writing VLOOKUP formulas, you connect two tables in one pass.

Note: This is a horizontal join (it adds columns). To stack files vertically (more rows), use Excel Merge instead.

How to use

  1. Pick the main file you want to keep as the Primary Table (A) (e.g. orders).
  2. Pick the file you want to pull info from as the Lookup Table (B) (e.g. customer list).
  3. Pick a sheet and a key column on each side (what to match on).
  4. Tick the columns from B you want to add into A.
  5. Pick a Join Type (Left Join is usually right).
  6. Click Run.

You get a new Excel file containing A with the chosen columns from B added.

Join types

TypeResult
Left Join (VLOOKUP style)Every row in A is kept. If no match in B, the new columns are blank. Most common choice.
Inner JoinOnly rows that exist in both A and B are kept. Unmatched rows are dropped.
Full Outer JoinEvery row from A or B is kept. Unmatched sides become blank.

Key normalisation options

  • Ignore Case: ali matches ALI.
  • Trim Whitespace: 12345 matches 12345.

Examples

Attach customer info to orders: Orders as A, customer list as B, key customer_id, pick full_name and phone from B, Left Join, run. The order list now shows customer name and phone.

Look up product prices: Order lines as A, price list as B, key product_code, pick unit_price from B, Left Join.

Find rows in both lists: Join two lists with Inner Join to see only customers that appear in both.

Email campaign engagement: A holds everyone who got the email, B holds everyone who opened it, key email, "Ignore Case" on, Inner Join. You get the list of openers.

Watch out

  • The key column on the Lookup side (B) should be unique. Duplicate keys multiply rows.
  • Key columns can have different names on each side, matching is by value not by name.
  • Large files (100K+ rows) may take a while.
  • A numeric key (e.g. customer ID as number) does not match a text key (e.g. "12345"). Types must match.
  • The output is a single Excel file, not CSV.

License

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