Magic Tools
Back

Compare Two Lists — List Comparison Tool

Paste two lists and instantly find common items, items only in A, and items only in B. Free online list comparator with dedupe and case-insensitive mode.

Left unique
0
Right unique
0
Common items
0
Different items
0

Lists

One item per line.

Only in A

Only in B

In both lists

How to use / Why use this tool / FAQ

How to use

Paste one list into each box, one item per line — emails, SKUs, keywords, IDs, or any text. The comparison runs instantly as you type: you get three result panels showing items only in list A, items only in list B, and items present in both. Toggle 'Ignore case' when the two lists use different capitalization, and 'Trim whitespace' to neutralize stray spaces from spreadsheet exports. Copy any result panel with one click.

Why use this tool

Comparing two lists in Excel means wrestling with VLOOKUP or COUNTIF formulas; doing it by eye is error-prone past a dozen lines. This list comparator surfaces overlaps and differences in one paste — ideal for reconciling customer exports, diffing keyword sets between campaigns, checking inventory or order lists, verifying migration completeness, and audit work. Everything runs locally in your browser, so nothing is uploaded.

FAQ

How do I compare two lists to find differences?
Paste one list on each side, one item per line. The tool immediately lists items missing from the other side (A-only and B-only) plus the common items — no formulas or sorting needed.
Does it remove duplicates?
Yes. The compare result is based on unique values so repeated lines do not inflate the output. The counters show unique item counts for each side.
Can it ignore case?
Yes. Use case-insensitive mode when your two lists are not normalized — 'Apple' and 'apple' will then count as the same item.
Can I compare lists copied from Excel or Google Sheets?
Yes. Copy a column and paste it directly — each cell becomes one line. Keep 'Trim whitespace' on to ignore invisible spaces that spreadsheets often add.
Is my data uploaded anywhere?
No. The comparison runs entirely in your browser with no server round-trip, so it is safe for customer lists and other sensitive data.
What is a list comparator?
A list comparator (or list comparison tool) takes two lists and computes their set difference and intersection: what is unique to each list and what they share. This one works on any line-separated text.