Compare two lists and find the differences

Paste list A and list B, one item per line, and the tool splits them into items in both, only in A and only in B. Turn on close-spelling matching to pair up entries like Jon Smith and John Smith.

Everything runs in your browser. Your text and files stay on your device and are never uploaded.

0 lines

0 lines

Paste two lists to see what they share and where they differ.

How to use it

  1. Paste list A in the left box and list B in the right box, one item per line. A column copied from Google Sheets or Excel works as is.
  2. Pick what counts as the same item: ignore upper and lower case, extra spaces or punctuation.
  3. Read the three result lists: In both, Only in A and Only in B.
  4. Tick Match close spellings to pair near matches such as typos, then move the closeness slider and review the pairs.
  5. Copy any list or download it as a text file to paste back into a sheet.

Questions

How do I find items that are in one list but not the other?

Paste both lists and read Only in A and Only in B. Only in A holds items missing from B, and Only in B holds items missing from A.

Does the comparison care about upper and lower case?

Not by default, so Apple and apple count as the same item. Untick Ignore upper and lower case when the difference matters, such as for product codes.

How does close-spelling matching work?

Items left over after the exact comparison are scored by how many characters differ, from 0 to 100 percent. Pairs at or above your closeness setting are matched, best scores first, and each item is used once.

What happens to repeated items in a list?

Each list is reduced to its distinct items before comparing, and the summary tells you how many repeats were ignored in A and in B.

How long can the lists be?

Up to 5,000 lines per list, and any lines past that are left out and counted. Exact comparison is instant at that size. Close matching scores every leftover item in A against every leftover item in B, so when many hundreds of items differ on both sides it is skipped and the page tells you.

Are my lists uploaded anywhere?

No. The comparison runs in your browser and nothing is sent to a server.

More free tools

All free tools