How to compare two lists
- Paste the first list into List A and the second into List B, or open a file into either with its File menu.
- Press Compare lists.
- Copy the result you need. Swap A and B switches the two lists.
What you get
- Only in List A: items in the first list that are missing from the second
- Only in List B: items in the second list that are missing from the first
- In both lists: the items they have in common
- Combined: everything from both lists, with each item once
Each result has its own Copy button. Items can be one per line, or separated by commas or tabs; each list’s format is detected on its own, so you can compare a column from a spreadsheet with a comma separated list from an email.
Common uses
- Who was invited but hasn’t replied, or who registered but didn’t attend
- Which email addresses are in one mailing list but not the other
- Which products, SKUs or IDs are missing from an export
- Which students haven’t handed in an assignment
How matching works
Spaces at the start and end of items are ignored. Capitalization is ignored too unless you untick Ignore capitalization. Duplicates within a list are shown once. Results keep the order of the original lists, so you can alphabetize them afterwards if you like.
Who hasn’t replied?
List A (invited): Amy Bob Carl Dana Eve List B (replied): bob Dana Frank
Only in A: Amy, Carl, Eve Only in B: Frank In both: Bob, Dana
Questions
Is there a size limit?
Lists with tens of thousands of items compare almost instantly. Everything runs in your browser, so the only limit is your computer’s memory.
Are my lists uploaded?
No. The comparison happens on your own device and nothing is sent anywhere.
How do I find what’s in list A but not in list B?
Paste the lists into List A and List B and press Compare lists. Only in List A shows the items from A that are missing from B, and Only in List B the other way round. To take one list out of another and keep the first list’s order and format, use Remove one list from another.
Will it match items with typos or small differences?
No. Items must match exactly, apart from spaces at the ends (and capitals, while Ignore capitalization is ticked). To find near matches like “Jon Smith” and “John Smith”, use Find near matches.
Can I compare columns in Excel this way?
Yes. Copy one column into List A and the other into List B. It’s much quicker than writing a VLOOKUP or MATCH formula.