Free tool · 01 / FIND
Compare two lists.Matches and differences in seconds, no signup.
Finds what's in both lists, only in one, or duplicated, by line, email or company domain.
Runs in your browser. Nothing you type is sent to us.
2 addresses in both, 3 only in A and 0 only in B.
Only in A is list A without anything in B: the cleaned lead list.
Duplicates dropped: 1 in A, 0 in B. 1 line has no email address to match on, so it's left out.
Valley scores every lead against your ICP and throws most of them out, so you only write to the ones that fit. See how Valley does it ↗
NEXT STEP
Fed up with cleaning lists by hand.Valley finds, researches and writes to them.
Book a demo ↗$500 a month for your first seat, $200 for each seat after that.
The results
How do I compare two lists?Each result, and what it's for.
Paste one list in each box, one item per line. The tool shows what's in both lists, what's only in the first, what's only in the second, and everything without duplicates, ignoring capitals and extra spaces. To clean a lead list, match on email or company domain and keep what's only in the first.
| Result | What it contains | Use it for |
|---|---|---|
| Only in A | Everything in list A that isn't in list B | A lead list without customers, people already contacted or a do-not-contact list |
| In both | Everything in list A that's also in list B | Who's on both lists: overlap between two exports, or who you've already contacted |
| Only in B | Everything in list B that isn't in list A | What the other list has that yours doesn't |
| All, no duplicates | Every item from both lists, once | Merging two lists into one |
| Duplicates | Repeats within the same list, dropped and counted | Seeing how messy a list was |
Match on whole lines for any list, on email addresses for contact lists, or on company domains to treat everyone at one company as a match.
From RFC 5321: Simple Mail Transfer Protocol, section 2.4 ↗ (read 2 Nov 2026) · Gmail Help: Dots don't matter in Gmail addresses ↗ (read 4 Nov 2026) · Gmail Help: Send emails from a different address or alias ↗ (read 4 Nov 2026)
How it works
How this tool works.And what it can't see.
Paste a list in each box, one item per line, or whole rows from a spreadsheet. The tool compares them as you type, in your browser: nothing you paste is sent to us or stored, which matters for lists of people.
Whole lines match when they're the same apart from capitals and extra spaces. Email addresses match on the address found in each line, so a CSV row matches the bare address. Company domains match on the domain of the email or website in each line, so one row of acme.com in list B removes everyone at acme.com from list A.
Capitals are ignored by default. Domains aren't case sensitive; the part before the @ is case sensitive in principle, but relying on that is discouraged. With the Gmail option on, dots and anything after a + are ignored for gmail.com addresses, which Gmail delivers to the same inbox.
Results keep each line as you pasted it, the first time it appears. Lines with no email or domain to match on are counted and left out of the email and domain modes.
Built by Valley.
Sources
- RFC 5321: Simple Mail Transfer Protocol, section 2.4 ↗read 2 Nov 2026
- Gmail Help: Dots don't matter in Gmail addresses ↗read 4 Nov 2026
- Gmail Help: Send emails from a different address or alias ↗read 4 Nov 2026
- Microsoft Support: Use the COUNTIF function in Microsoft Excel ↗read 4 Nov 2026
- Google Docs Editors Help: COUNTIF ↗read 4 Nov 2026
Comparing lists
Clean a lead list before you send.And how to do the same in a spreadsheet.
Four things that make list comparison work for outreach.
- 01
Remove people you've already contacted
Put the new leads in list A and everyone you shouldn't write to in list B: customers, open deals, past sends and your do-not-contact list. Match on email addresses, and Only in A is the list to send to. That's how we'd do it.
- 02
Match by company, not just by person
Choose Company domains and a single line in list B, like acme.com or anyone@acme.com, removes every lead at that company from list A. It's the quickest way to keep away from your customers' colleagues.
- 03
Gmail addresses: dots and +aliases
Gmail ignores dots in the part before the @, so johnsmith@gmail.com and j.o.h.n.smith@gmail.com reach one inbox, and it delivers name+anything@gmail.com to name@gmail.com. Dots do count on work and school accounts, so the option only applies to gmail.com addresses.
From Gmail Help: Dots don't matter in Gmail addresses ↗ · Gmail Help: Send emails from a different address or alias ↗, read 4 Nov 2026
- 04
Comparing two lists in Excel or Google Sheets
With list A in column A and list B in column B, put =COUNTIF(B:B, A2)>0 next to the first item in A and fill it down: TRUE means it's in both lists. COUNTIF ignores capitals in Excel and in Google Sheets.
It doesn't pull an email out of a longer row or match by company domain; that's what this tool adds.
Or start from a list that only has the people worth writing to. See how Valley does it ↗
From Microsoft Support: Use the COUNTIF function in Microsoft Excel ↗ · Google Docs Editors Help: COUNTIF ↗, read 4 Nov 2026
Questions
Questions people ask.
- How do I compare two lists?
- Paste one list in each box above, one item per line. You'll see what's in both, what's only in each list, and everything without duplicates.
- How do I find the differences between two lists?
- Look at Only in A and Only in B: together they're everything that isn't on both lists.
- How do I find duplicates between two lists?
- In both shows every item that appears on both lists; duplicates within a single list are dropped and counted.
- How do I compare two lists in Excel?
- Put =COUNTIF(B:B, A2)>0 next to the first item of list A and fill it down. TRUE means the item is also in list B.
- How do I remove contacts I've already emailed from a lead list?
- Paste the new leads in list A and your past sends in list B, match on email addresses, and copy Only in A.
- Does capitalization matter when comparing lists?
- Not here by default: Ignore capitals is on. Untick it to treat Apple and apple as different.
- Are Gmail addresses with dots the same address?
- Yes, for gmail.com: Gmail ignores dots before the @ and delivers name+anything to name. Turn on the Gmail option to match them.
- Are my lists uploaded anywhere?
- No. The comparison runs in your browser, and nothing you paste is sent to us or stored.
- Is this compare two lists tool free?
- Yes. It's free, needs no signup and handles up to 100,000 lines a list.
Keep going
Try one of these next.
- Email extractorData and prospectingPulls every email address out of pasted text, drops duplicates and flags the risky ones.Open the tool
- Email permutatorData and prospectingLists every likely work email for a name and company, and checks the domain takes mail.Open the tool
- MX lookupEmail outreachShows a domain's MX records and who handles its email, for one domain or 500 at once.Open the tool
- LinkedIn Boolean search builderData and prospectingBuilds Boolean strings for LinkedIn, Sales Navigator and Recruiter, and fixes broken ones.Open the tool
- Buying committee mapData and prospectingMaps who's in a B2B deal for what you sell, with titles and a LinkedIn search per role.Open the tool