CSV relational join

Join two CSV tables by selected keys using inner, left or full joins. Preserve every duplicate-key combination and mark unmatched cells with JSON null.

The example value has been entered. Check it immediately or change the value.

Input is processed in the browser. Refreshing returns a sample value.

Result

Instructions and example

Emit row pairs with exactly matching string keys, retaining unmatched rows with null cells as required by the join mode.

The default left join connects Pen with stock 5 and leaves Book’s right cells null, producing 2 rows.

Each table allows 100 rows and 12 columns; output up to 1000 rows. Input cells are strings and empty keys match; this is not SQL NULL-key behavior.

Frequently asked questions

Which row is chosen when CSV join keys repeat?

Every matching pair is emitted rather than choosing one row.

Why is join output JSON rather than CSV?

It distinguishes unmatched nulls from real empty strings and labels duplicate left/right column names.

Calculation criteria and reference materials

The calculation formula and scope of this tool are disclosed in the above description. Examples can be checked by substituting input values into the formula or following the specified string and calendar handling rules.

Verification of calculation criteria: · Calculation·verification principles · Report errors