USEFUL DETAILS
See what's missing.
Only in A shows values missing from B; Only in B shows additions. Repeated values appear once in each result. Matching can ignore case and surrounding spaces; line order doesn't affect a match.
The toolkitLists & tables
Compare two lists.
Paste two lists to see what matches, what is missing, and the combined set of unique values.
Only in A
0 itemsIn both lists
0 itemsOnly in B
0 itemsAll unique values
0 itemsQuick start
- Paste one item per line into List A and List B.
- Choose whether to trim surrounding whitespace and ignore letter case.
- Copy the values only in A, in both lists, only in B, or all unique values.
Spot missing product codes
Paste the codes from each column into its own list. Only in A shows what's missing from B.
Input
List A
SKU-001
SKU-002
SKU-003
List B
SKU-002
SKU-003
SKU-004Result
Only in A: SKU-001
In both: SKU-002, SKU-003
Only in B: SKU-004Common questions
How can I find items missing from a second list?
Paste the original list into A and the second list into B. Only in A contains items that the second list is missing. Only in B shows additions. For spreadsheet data, copy a single column into each box.
Does this compare duplicate counts or line order?
No. Results are sets of unique values, so an item repeated several times appears once. Line order is not used to decide whether items match. Use Text cleanup to remove duplicates from one list; this tool compares membership across two lists.