TWO LISTS. A CLEAR ANSWER.
Compare Two Lists
Find what's missing, what's shared, and what's repeated.
One column of text, or a UTF-8 .txt file. Up to 50,000 lines / 5 MiB per list. CSV and Excel files are not supported.
Trim outer whitespace: On · Case-sensitive: On · Blank lines ignored
Loading comparison engine…
THE COMPARISON
Your results
Outputs contain the first original value in each group, in original order. In both uses List A values. Set spreadsheet columns to Text before pasting identifiers.
SMALL EXAMPLE, CLEAR RULES
Keep the values.
See the difference.
Paste names, product codes, or a column from a spreadsheet. This list compare tool checks whether each distinct value belongs to A, B, or both.
Understand the matching rules →00123
123
SKU-A
SKU-A
123
SKU-B
Default rules → Only in A: 00123, SKU-A · Only in B: SKU-B · In both: 123
SKU-A is one distinct group with two source lines. This compares membership, not quantities.
A FEW USEFUL DETAILS
Before you compare
Will you upload or save my lists?
Comparison and TXT reading happen in your browser. Your lists are not sent to us or saved by this tool. Refreshing or closing the tab may clear them. Site hosting logs and optional usage analytics are separate; see Privacy.
Can I compare two Excel columns?
Yes. Copy one column at a time, with one item per line. There is no XLSX, CSV, or TSV file parser. Cells containing line breaks are not supported by this workflow. See the Excel guide.
Are 00123 and 123 the same?
No. Values remain strings. Leading zeros, long identifiers, punctuation and Unicode differences are preserved. Ignore case only applies JavaScript lowercase conversion.
Does a missing value tell me why it disappeared?
No. List difference only describes the inputs you provide. It cannot confirm identity, history, quantities, or the reason a value is missing.