List Compare
Compare two sets of values. Order and repeats are ignored.
Your data stays in your browser
List A
Waiting for data
List B
Waiting for data
Options
Exact comparison is the default.
Normalization changes matching keys only; displayed and copied values retain the first original spelling. Reset keeps List A.
Comparison
No resultAdd two usable lists, then run Compare lists.
Example
Exact comparison
List A
101 102 103
List B
102
Output
Only in A: 101, 103 Only in B: none In both: 102
How it works
- It compares distinct values. Order and repeats are ignored, and each value shows once, with its first spelling.
- Trim before compare and Case-insensitive comparison change matching only, not the values shown.
- For a table, choose the column to compare.
- Copy a group, format it as SQL IN, or use it as the next input.