Compare Two Lists

Paste two lists and see what each one is missing and what they share.

Runs in your browser. Nothing you enter is uploaded.

Show
Items in list A that are missing from list B.

How to use Compare Two Lists

  1. Paste one list into List A and the other into List B, one item per line. Columns copied from Excel or Google Sheets work.
  2. Pick what to show: only in A, only in B, in both, or both lists merged. Each button shows how many items it has.
  3. Turn on Ignore case if "Apple" and "apple" should match. Extra spaces are ignored unless you turn that off.
  4. For a list on one line, like "apples, bananas", turn on Split at commas and tabs.
  5. Copy the result, or download it as a .txt file. Nothing you paste leaves your device.

How it works

Every item in list A is checked against every item in list B. The result updates as you paste or type, and nothing is uploaded: it all runs in your browser, so lists of email addresses or customer names stay private.

Show What you get Use it for
Only in A Items in list A that list B doesn’t have Who was invited but didn’t reply, which products are missing from a price list
Only in B Items in list B that list A doesn’t have New subscribers since last month, extra rows in an export
In both Items the two lists share Customers who are also subscribers, matching order numbers
Merged Every item from both lists, once Joining two lists without repeats

Each button shows how many items it has, so you see the whole comparison at a glance before you pick one.

When two items count as the same

  • Exact match by default: “Apple” and “apple” are different items. Turn on Ignore case to treat them as the same.
  • Spaces: with Ignore extra spaces on, spaces at the start and end don’t count, and two spaces in a row count as one. “anna@example.com “ with a trailing space matches “anna@example.com”. Zero-width characters, which you can’t see but often come along when you copy from websites and chat apps, are ignored too.
  • Accents: “é” typed as one character and “é” built from “e” plus an accent mark count as the same.
  • Empty lines are skipped.

When the two lists spell a shared item differently, In both shows it as list A spells it.

Repeated items

An item that appears twice in the same list is compared once and listed once. The count beside each list says how many items it has and how many of them are repeats, like “8 items, 2 repeated”. To clean the repeats out of one list, use Remove Duplicate Lines.

Lists on one line

Each new line starts a new item. If you paste a list like “apples, bananas, cherries”, the tool offers to split it: Split at commas and tabs also splits at semicolons. Leave it off for items that contain commas, like “Smith, John”.

Order

Results keep the order of the list they come from. Merged puts list A’s items first, then the items only list B has. A to Z and Z to A sort numbers the way people expect: “item 2” comes before “item 10”.

Questions

How do I compare two lists to find the differences?

Paste one list into List A and the other into List B. Only in A shows what list B is missing, and Only in B shows what list A is missing. Items match only when they are written the same way, so turn on Ignore case if the capitals differ.

How do I find the items that are in both lists?

Choose In both. It lists each item that is in both lists once, spelled and ordered as in list A. Set Sort to A to Z to put it in alphabetical order.

How do I compare two lists in Excel?

To flag items in column A that are missing from column B, type =COUNTIF(B:B, A2)=0 in C2 and fill it down: TRUE means missing. To highlight items in both columns, select both and choose Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values. Values repeated within one column are highlighted too.

How do I compare two lists in Google Sheets?

To list the items in column A that are missing from column B, use =FILTER(A2:A, A2:A<>"", COUNTIF(B2:B, A2:A)=0). Change =0 to >0 to list the items that are in both columns.

How do I merge two lists and remove duplicates?

Choose Merged. You get every item from both lists once: list A’s items first, then the items only list B has. To remove duplicates from a single list, use Remove Duplicate Lines.

Why don’t two items that look the same match?

They differ in a way you can’t see: capitals, spaces or invisible characters. Turn on Ignore case and keep Ignore extra spaces on, which also ignores zero-width characters. Letters that only look alike, like a Latin and a Cyrillic "a", still count as different.

Updated October 20, 2026 · Works in current Chrome, Edge, Firefox and Safari · Runs entirely in your browser