Skip to content
LovTools
EN

CSV Join (Merge Two Tables)

Join two CSVs on a key column — inner, left or full outer — like VLOOKUP or SQL JOIN.

Processed locally on your device — nothing is uploaded.

About the CSV Join (Merge Two Tables)

Have customers in one file and orders in another? Joining links rows that share a key, like VLOOKUP or a database JOIN. Paste both tables, name the key column in each and choose the join: inner keeps only matching rows, left keeps every row of the first table, and full outer keeps everything from both.

Keys can be matched ignoring case and stray spaces, one-to-many matches create one row per match, and columns that appear in both tables are renamed so nothing is overwritten. Preview the result and download the joined CSV.

How to use the CSV Join (Merge Two Tables)

  1. Paste the two CSV tables.
  2. Choose the key columns and the join type.
  3. Preview and download the joined CSV.

Features

  • Inner, left and full outer joins
  • Different key names per table
  • Case-insensitive matching
  • One-to-many rows
  • Name clashes handled

Supported formats

  • Plain text

Frequently asked questions

What happens to rows without a match?

In a left join they keep their data with blank columns from the second table; in an inner join they are dropped.

Is my text sent anywhere?

No. Everything runs in your browser, so nothing you paste is uploaded or stored.

Added · Last reviewed · Maintained by Sohail Khax · How we test tools