How to Compare Two Lists
To compare two lists, paste one into each side of a list comparison tool and choose what you want to see: entries in both, entries only in the first, only in the second, or the merged list. Decide first whether case and surrounding whitespace should matter, because those two settings determine what counts as a match at all.
List Comparison
Find what two lists share and what only one of them has.
There are two different questions people mean by "compare these lists", and they need different tools. One is "what do these two sets have in common?" — order is irrelevant, and an entry appearing twice in one list changes nothing. The other is "what edits turn this document into that one?" — order matters, and a moved line is a change.
This guide covers the first. If you are comparing two versions of a document rather than two sets of entries, the text difference checker is the tool you want.
Step by step
-
Put one list in each box
One entry per line. Blank lines are ignored, so a trailing newline or a gap between blocks does not become an entry.
-
Decide whether case matters
Leave case matching off for email addresses, domains and URLs, where case carries no meaning in practice. Turn it on for identifiers, tokens and API keys, where Admin and admin are genuinely different values.
-
Decide whether spacing matters
Leave whitespace trimming on unless the spacing is meaningful. Lists pasted from spreadsheets and email clients routinely carry trailing spaces, and without trimming those entries silently fail to match.
-
Choose what to show
In both lists answers "which of these overlap?". Only in the first answers "what did I lose?". Only in the second answers "what is new?". Combined gives you a merged list with duplicates removed.
-
Check the summary line
It reports how many unique entries each list held and how many were shared. If the shared count is zero when you expected overlap, the matching settings are almost always the reason.
Example
Case matching off, so CAROL and carol are the same person.
Two lists
First Second
ada@ex.com bob@ex.com
bob@ex.com CAROL@ex.com
carol@ex.com erin@ex.com
dave@ex.com
Results
In both: bob@ex.com, carol@ex.com
Only in the first: ada@ex.com, dave@ex.com
Only in the second: erin@ex.com
Frequently asked questions
Should I use this or the text difference checker?
Why do two entries that look identical not match?
What happens to duplicates within one list?
Can I compare more than two lists?
Tools used in this guide
All tools →- List Comparison Find what two lists share and what only one of them has. In your browser
- Text Difference Checker Compare two versions of a text and see what changed. In your browser
- Remove Duplicate Lines Strip repeated lines from a list and keep the order. In your browser
- Sort Lines Sort a list alphabetically, numerically, by length or at random. In your browser
- Email Extractor Pull every email address out of a block of text. In your browser
Related guides
All guides →Last reviewed .