TWO LISTS. EVERY DIFFERENCE.
COMPARE TWO LISTS
Find common items and missing values instantly. Paste a column from Excel, a list of IDs, or any text list.
Empty items are ignored. Duplicates count once. Results preserve the first spelling; shared items use List A. Comma mode splits on every comma, including commas inside quotes. Up to 1,000,000 characters per list.
Paste a list to begin.
CSV exports include a category column. Values that could be spreadsheet formulas are prefixed with an apostrophe. Copy and TXT preserve original text.
FIND WHAT CHANGED
How do I compare two Excel columns?
Copy one column into List A and the other into List B. Keep “New line” selected. Shared items appear in Both Lists; missing values appear in Only in A or Only in B. Download results or copy them back into your sheet.
Does order or capitalization matter?
Order does not affect matching. Case is ignored unless you enable Case sensitive. Trim outer spaces removes whitespace at each end, but spaces inside an item still matter. Unicode text is supported; accented letters remain distinct from unaccented letters.
How is this different from a text diff?
This tool compares sets of whole items, not individual characters or line positions. Repeated items collapse to one result. All Unique combines both lists; Shared contains their intersection.
Are my lists saved or uploaded?
The comparison runs entirely in your browser. This tool does not upload or save your list contents. Reloading the page clears the inputs. No account or paid API is needed.
MORE TEXT TOOLS: REMOVE DUPLICATES · SORT A LIST