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.

  1. Paste the main list into List A, one item per line.
  2. Paste the list you want to compare with (or remove) into List B.
  3. 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.
  4. Copy or download the result.
  • Ignore capital letters – Tom and tom are 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.