List tools
Compare Two Lists
See what changed, what overlaps, and what repeats without using formulas.
Processed locally. Your input and output are never uploaded.
Tool overview
Compare Two Lists tool overview
Compare Two Lists builds five result sets from two pasted inputs. Matching can ignore case and surrounding whitespace while the displayed values still come from the original lists.
Reconcile exports and membership lists
- Compare old and new inventory lists
- Find missing campaign keywords
- Check membership between two exports
- Identify duplicates inside either source list
Compare List A and List B
- Paste the first collection into List A and the second into List B.
- Choose line or custom-delimited input.
- Set case, whitespace, order, and sorting rules.
- Switch result tabs to inspect each set and its count.
Case and whitespace matching rules
- Only in A and Only in B are directional differences.
- In both lists contains the first List A representation of shared keys.
- Duplicate tabs show repeated values after the first occurrence.
- Preserve order follows source order unless sorting is enabled.
Understand only-A, only-B, and shared values
Before
Input · List A: apple pear banana banana Input · List B: pear plum banana plum
Result
apple
Normalization, duplicates, and display order
- Matching rules can make visually different values equivalent.
- Custom delimiter mode supports one separator at a time.
- Duplicate output reports repeated occurrences, not just unique duplicate keys.
Questions
Compare Two Lists FAQ
Can I compare comma-separated values?
Yes. Switch the input mode to custom delimiter and use a comma.
Are my lists sent anywhere?
No. Both lists are compared locally in the current browser tab.