CSV joiner

Join two CSV tables on a shared key using inner or left joins.

Processed on your device

Input

Open a local UTF-8 text file25 MiB maximum. The file opens in the text box above.Or drop a file here.
Open a second UTF-8 text file25 MiB maximum. The file opens in the second text box.Or drop a file here.

Options

Options
Enter the heading of the column to match in the first table.
Enter the matching column heading in the second table.
Rows are matched using the two key columns.

How to use this tool

  1. Paste the two CSV tables and identify their key columns.
  2. A left join retains unmatched first-table rows; an inner join includes only matches.
  3. Repeated keys create one row per matching pair.

Things to know

  • Output is capped at 100,000 rows. Duplicate output headings receive a right_ prefix and a numeric suffix if necessary.
  • Each CSV input accepts up to 25 MiB, 100,000 data rows, 10,000 columns and 1,000,000 cells. Expanded tables also count empty cells.
  • Generated CSV text is limited to 25 MiB in total, including all split files.

You might also need

More in data & csv