Compare Two Lists
Find the difference between two lists without spreadsheet formulas.
Compared as text, never as numbers — 00123 and 123 are different items.
Only in A missing
0Only in B new
0In both common
0Duplicates items that appear more than once within one list
How to Use
Copy a column from Excel or Google Sheets into A and B. Each line is one item. Results appear as you paste.
Leading/trailing spaces are ignored by default. Turn on Ignore case to treat "Kim" and "kim" alike, or split on commas & tabs for comma-separated lists.
Copy only-in-A (missing), only-in-B (new) or in-both (common) — each pastes straight into one spreadsheet column. Save everything as CSV.
FAQ
Are 00123 and 123 treated as the same?
No. Items are compared as text, never converted to numbers, so leading zeros survive. The CSV export also writes them so Excel keeps the zeros.
What if an item repeats within one list?
It appears once in the comparison, and the Duplicates box shows which list it repeats in and how many times — handy for catching double entries.
How long can the lists be?
Tens of thousands of lines compare instantly. The screen shows up to 2,000 per result; copy and CSV include everything.
Can I compare several columns at once?
Each whole line is one item. Copy two columns together and they become one tab-joined line, so the combination is compared. Keep "split on commas & tabs" off in that case.
