☰

BV Lab

Merge tables

Table joiner

Paste two delimiter-separated tables, choose the key column on each side, pick a join type, and run. Ctrl+Enter runs the join from anywhere on the page.

Delimiter

Data

No data yet.

Delimiter

Data

No data yet.

Join type

Join types (diagram)

Four Venn diagrams. Left join: all of Table A and the overlap with B are highlighted. Right join: all of B and the overlap. Inner join: only the overlap. Full outer join: both circles entirely highlighted.

Table A key

Table B key

Ignore case

No output yet.