Values appear only in one list because of casing
Strict list comparison treats SKU-1, sku-1, and SKU-1 with a trailing space as different values.
Normalize casing and trim whitespace in the source lists before comparing business identifiers.
Use this tool
Prepare the input and run the tool
Paste one list in each box. Result: Copy the only-in-A, only-in-B, and shared results.
Ready.
Comparison report appears here.
Data handling: Files and pasted data are processed in this browser session.
Tool guide
How to use List Compare
Use this when two exports should match but you need the differences. It works well for IDs, SKUs, emails, handles, and order numbers.
What this tool does
Paste two lists and see what is only in A, only in B, or shared by both.
- Input
- Paste one list in each box
- Output
- Copy the only-in-A, only-in-B, and shared results
Tool advantages
- Runs in this page; the file or pasted data is not sent to a new app.
- Keeps the preview, report, and download in the same screen.
- Gives you a report you can use as a cleanup list.
Step-by-step usage guide
- 1Paste both lists.
- 2Run the comparison.
- 3Copy the section you need.
Common errors and fixes
Duplicate values make counts confusing
Repeated lines can make a list look larger without changing the set of unique values.
Run the duplicate finder first when you need to audit repeated values separately.
Copied table columns are mixed together
Pasting multiple spreadsheet columns can combine names, emails, or IDs in one comparison.
Copy only the identifier column you need to compare, then rerun the list check.
When to use List Compare
- You are checking files before an upload, import, share, or delivery.
- You want to confirm the result before sending it to another system.
- You need a copied result, downloaded file, or report that can be reviewed outside the page.
FAQ
What can I compare?
IDs, emails, SKUs, order numbers, or any line-based list.
Are duplicates kept?
The comparison treats each list as a set so the report focuses on membership differences.