BYTETOOLS

CSV Join Tool

Join two CSV files on a shared key column online — inner, left or full join like VLOOKUP or SQL, with collision-safe headers and an unmatched-key report.

Drop the left .csv here
Drop the right .csv here

What is the CSV Join Tool?

The ByteTools CSV Join Tool merges two CSV tables on a shared key column, exactly like a VLOOKUP in Excel or a JOIN in SQL.

  • Inner, left and full join modes
  • Fast Map-indexed lookup, VLOOKUP-style
  • Colliding right-table column names suffixed with _2
  • Unmatched-key counts and sample keys reported
  • Optional whitespace trimming around keys
  • 100% private — both files stay in your browser

How to use the CSV Join Tool

  1. 1

    Paste or drop the left CSV and the right CSV — both need a header row.

  2. 2

    Select the key column for each table.

  3. 3

    Choose the join type: inner, left or full.

  4. 4

    Click Join tables and review the match statistics.

  5. 5

    Copy or download the combined CSV.

About the CSV Join Tool

The ByteTools CSV Join Tool merges two CSV tables on a shared key column, exactly like a VLOOKUP in Excel or a JOIN in SQL. Paste or drop both files, pick the key column in each, choose inner, left or full join, and get a single combined table.

An inner join keeps only rows whose key appears in both tables; a left join keeps every left row and fills blanks where the right table has no match; a full join keeps everything from both sides. Duplicate column names from the right table are automatically suffixed with _2 so no data is silently overwritten, and the tool reports how many keys on each side found no partner.

The join is computed 100% locally in your browser using an indexed lookup, so even large files merge quickly and nothing is ever uploaded.

Frequently asked questions

How do I merge two CSV files with a common column?

Paste one file as the left table and one as the right, choose the shared key column in each — for example id or email — pick a join type and click Join tables. Each left row is combined with the right-table row that has the same key.

What is the difference between inner, left and full join?

Inner keeps only rows whose key exists in both files. Left keeps every row from the left file and leaves the right-hand columns blank when there is no match. Full keeps all rows from both files, filling blanks on whichever side is missing.

What happens when the same key appears several times in the right file?

The left row is combined with every matching right row, just like a SQL join, so you may get more output rows than input rows. Unlike Excel's VLOOKUP, no matches are silently dropped.

What if both files have a column with the same name?

The right table's version is renamed with a _2 suffix — for example name and name_2 — so both values survive in the output. The right key column itself is dropped because it duplicates the left key.

Why do keys that look identical fail to match?

Usually invisible whitespace, like a trailing space after an ID. Keep 'Trim whitespace around keys' enabled and both sides are trimmed before comparison. Matching is case-sensitive, so ABC and abc are different keys.

Related tools