CSV Join Tool

Join two CSV tables on a shared key column like a VLOOKUP or SQL join. Choose left, right, inner or full join, ignore case and spaces, and see unmatched rows.

  • Free, no sign-up
  • Runs in your browser
  • Your data stays private

How to use the CSV Join Tool

  1. Paste table A and table B.
  2. Enter the key column in each and choose the join type.
  3. Copy the joined table and check the match counts.

Why use this CSV Join Tool

  • Four join typesLeft, right, inner and full outer joins.
  • Forgiving keysIgnore case and spaces so C1 matches c1.
  • One-to-manyKeys that appear several times in B produce several rows.
  • Match reportSee matched rows, unmatched rows and unused lookup rows.

Frequently asked questions

How do I do a VLOOKUP with CSV files?

Use a left join. Every row of table A stays and the matching columns from table B are added.

What is the difference between left and inner joins?

A left join keeps all rows from A. An inner join keeps only rows that match in both tables.

What if column names clash?

Columns from B with the same name get a _2 suffix.

Related tools

More Spreadsheet & CSV tools

User Reviews

–
No ratings yet
Write a review
Your rating *

Your email is never published. Reviews are moderated, and links aren't allowed.

What users are saying

No reviews yet

Be the first to share your experience with this tool — your feedback helps others.