Compare two lists
Compare two lists and see what is only in A, only in B, in both or in either. Remove one list from another in seconds.
Your text is processed in your browser and never sent to our server.
0 unique items
0 unique items
Items of List A that are not in List B – List B removed from List A.
0 items
How to remove one list from another
Have a list of all customers and a list of people who unsubscribed? Paste both and this tool shows what is only in the first list, only in the second, in both, or in either – instantly and without formulas.
- Paste the main list into List A, one item per line.
- Paste the list you want to compare with (or remove) into List B.
- Pick a result: Only in A (A minus B), Only in B, In both or All. The counters show how many items each result has.
- Copy or download the result.
- Ignore capital letters –
Tomandtomare treated as the same item; the spelling from the first list is kept. - Trim spaces – spaces and tabs around items are ignored (on by default), so copied cells with trailing spaces still match.
- Ignore empty lines – blank lines are skipped (on by default).
Example
List A (newsletter subscribers) and List B (unsubscribed):
List A List B anna@example.com peter@example.com peter@example.com zuzana@example.sk maria@example.com
Only in A (A − B) – who still gets the newsletter:
anna@example.com maria@example.com
Frequently asked questions
How do I remove one list from another in Excel?
With List A in column A and List B in column B, put =COUNTIF(B:B, A1)=0 into C1, fill it down and filter column C for TRUE. In Excel 365 a single formula does it: =FILTER(A1:A100, COUNTIF(B1:B100, A1:A100)=0).
How do I compare two lists in Google Sheets?
Use =FILTER(A2:A, A2:A<>"", COUNTIF(B2:B, A2:A)=0) for items only in column A, or =FILTER(A2:A, COUNTIF(B2:B, A2:A)) for items in both. Note that COUNTIF ignores letter case.
Are duplicates kept in the result?
No. Each result lists every item once, in the order it first appears. If you only need to clean up a single list, the duplicate remover is simpler. To filter lines by a word instead of a whole list, use remove lines containing.
Why do two items that look the same not match?
They usually differ in an invisible way – a trailing space, a different letter case or an accent (“Jan” vs “Ján”). Keep Trim spaces on, turn on Ignore capital letters, or remove accents first with the diacritic remover.
Is it safe to compare e-mail lists here?
Yes. Both lists are compared in your browser; nothing is uploaded to our server. Your lists are only remembered in your own browser so they survive a page reload.