Compare 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

Try this example