How to use the List Comparator
Compare two lists of emails, user IDs, SKUs, order numbers, or any strings to find the overlap, the unique values on each side, and the duplicates inside each list. The List Comparator is built for QA testers, analysts, marketers, and engineers who need to diff two lists fast — paste, compare, and copy or export the result without uploading anything to a server.
What it does
- Finds common items in both lists (set intersection).
- Finds only in List 1 and only in List 2 values (set difference).
- Reports duplicates within each list with counts.
- Supports newline, comma, tab, semicolon, pipe, or custom delimiters — handles pastes from Excel, CSV, JSON arrays, and SQL output.
- Normalizes whitespace, casing, and empty lines; optional case-insensitive matching for emails and IDs.
- Sorts results lexically or numerically and lets you copy any panel or export the full comparison.
When to use it
- QA: compare expected vs actual response IDs and find missing records.
- Data cleanup: dedupe an email list before import or campaign send.
- Migration validation: confirm a source export and target table match.
- Customer segments: find overlap between two cohort exports.
- Access reviews: diff a user-access export against the approved list.
- SQL prep: clean a list before passing it into the SQL IN Clause Builder.
How to use it
- Paste your first list into List 1 and the second into List 2. Each value can be on its own line, or separated by comma, tab, semicolon, or pipe.
- Pick the right delimiter per list if it is not newline (or set a custom one).
- Toggle Case-insensitive if you are comparing emails, usernames, or codes where casing should not matter.
- Click Normalize to trim whitespace and drop empty lines, and Remove Duplicates if you want to dedupe before comparing.
- Compare runs automatically — review the Common, Only in List 1, Only in List 2, and Duplicates panels.
- Copy any panel, copy only the unique items, or export the full report for tickets, audits, and pull requests.
Tips & pitfalls
- Hidden whitespace and zero-width characters are the most common reason two lists look identical but report as different — always Normalize first.
- Email comparisons should usually be case-insensitive; UUIDs and tokens usually should not.
- Numeric IDs sorted lexically put
10 before 2 — switch to numeric sort for ordering.
- If you pasted from Excel and see one giant single line, change the delimiter to tab or comma.
- Duplicates inside a single list are reported separately — they do not pollute the common/unique sets.
FAQ
- How do I compare two lists of emails for duplicates? Paste each list into List 1 and List 2, enable Case-insensitive, and the Duplicates panel shows repeats in each list while Common shows emails present in both.
- Can I compare two CSV columns? Yes — paste each column on its own side. The tool handles comma, tab, and custom delimiters so you can paste a single CSV column directly.
- Is my data sent to a server? No. Comparison runs entirely in your browser — your lists never leave your machine.
- What is the difference between Common and Only in List? Common is the set intersection (items in both lists). Only in List 1 / List 2 are set differences — items present in one list but missing from the other.
- Does it handle very large lists? Yes — comparison is in-memory and scales well; tens of thousands of rows compare in under a second on modern browsers.
- Can I send the result to SQL? Yes — use the handoff to send unique values straight into the SQL IN Clause Builder for query construction.
Runs locally in your browser. No uploads. No analytics on pasted lists.
