Compare Two Lists

Compare membership across both complete lists, then inspect the combined values and the entries unique to each side.

List Differences

1. Paste one value per line into First list and Second list. Row order does not determine whether a value belongs to both sets.
2. Select Case-sensitive to distinguish uppercase and lowercase values. With it off, values are converted to uppercase for comparison and output.
3. Click Compare to process the current input.
4. Review Only in the first list and Only in the second list. The field labeled Matches in both lists actually contains the combined unique values, including values present in only one input.
5. Click Copy under the output you want to keep. Use Clear where shown to clear the text fields; option selections stay as set.

For Apple and Banana in First list, and Banana and Pear in Second list, the default combined output is APPLE, BANANA, PEAR. The first-only value is APPLE; the second-only value is PEAR.

Understand the result labels

Matches in both lists is a union, not an intersection. The Matches counter counts that union. No matching rows counts values unique to either side, rather than counting all input rows.

Membership comparison ignores row position

The returned sets are sorted and repeated values appear once in each result. Use corresponding-row comparison when the position of a value matters. Spaces remain significant; there is no trim-spaces control.