List difference tool
Transformed in your browser · nothing is uploaded
Set operations on two lists: what is in the first only, what is in both, and both combined without duplicates. Separate the lists with a blank line.
How to use the list difference tool
Three questions come up constantly with two exports and they are genuinely different: who unsubscribed (in the old list, not the new), who is on both, and the combined mailing list. Doing this in a spreadsheet means VLOOKUP and a column of error values, which works and is more effort than it needs to be. Values are trimmed before comparing, which matters because spreadsheet exports carry trailing spaces that make identical values compare as different. Comparison is exact and case-sensitive; for email addresses, lowercase both lists first with the case converter.
Questions
A blank line between them. Everything before it is the first list, everything after the second.
Yes. For email addresses, lowercase both lists first.
Yes, which matters; spreadsheet exports carry trailing spaces that make identical values differ.
A diff cares about order and position. This treats each list as a set, which is what you want for exports.
No, which matters when the lists are customer emails.