Table reconciliation

Paste two tables straight from Excel or a CSV file. Pick the key column in each, choose which columns to compare, and see every match, difference and missing row at once. It's INDEX/MATCH without the formulas.

Runs entirely in your browser. Nothing you paste is uploaded.
A
B

Match rows by

A
=
B

Compare these columns

“Copy B columns in A's row order” does what INDEX/MATCH does: one line per row of A, in the same order, with #N/A where the key is missing in B. Paste it next to table A. If a key appears more than once in B, the first row is used, exactly like INDEX/MATCH, and the row is flagged. Cells with line breaks copied from Excel (Alt+Enter) are read correctly. Blank rows at the end are ignored. “NULL counts as blank” also accepts null and (null). With both options on, NULL, blank and 0 all count as equal, and so does 0,00 when numbers are compared by value. Keys are never affected.