# Compare two lists

> Finds what's in both lists, only in one, or duplicated, by line, email or company domain. Free, no signup. Runs in your browser. Nothing you type is sent to us.

**Compare two lists. Matches and differences in seconds, no signup.** Use it at https://tools.joinvalley.co/compare-two-lists

## 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.

Sources: [RFC 5321: Simple Mail Transfer Protocol, section 2.4](https://www.rfc-editor.org/rfc/rfc5321#section-2.4) (read 2026-11-02), [Gmail Help: Dots don't matter in Gmail addresses](https://support.google.com/mail/answer/7436150?hl=en) (read 2026-11-04), [Gmail Help: Send emails from a different address or alias](https://support.google.com/mail/answer/12096?hl=en) (read 2026-11-04)

## How it works

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.

## 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.

### 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.

### 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.

### 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.

Sources: [Gmail Help: Dots don't matter in Gmail addresses](https://support.google.com/mail/answer/7436150?hl=en) (read 2026-11-04), [Gmail Help: Send emails from a different address or alias](https://support.google.com/mail/answer/12096?hl=en) (read 2026-11-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. [Valley](https://www.joinvalley.co/?utm_source=tools_suite)

Sources: [Microsoft Support: Use the COUNTIF function in Microsoft Excel](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34) (read 2026-11-04), [Google Docs Editors Help: COUNTIF](https://support.google.com/docs/answer/3093480?hl=en) (read 2026-11-04)

## Sources

- [RFC 5321: Simple Mail Transfer Protocol, section 2.4](https://www.rfc-editor.org/rfc/rfc5321#section-2.4) (read 2026-11-02)
- [Gmail Help: Dots don't matter in Gmail addresses](https://support.google.com/mail/answer/7436150?hl=en) (read 2026-11-04)
- [Gmail Help: Send emails from a different address or alias](https://support.google.com/mail/answer/12096?hl=en) (read 2026-11-04)
- [Microsoft Support: Use the COUNTIF function in Microsoft Excel](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34) (read 2026-11-04)
- [Google Docs Editors Help: COUNTIF](https://support.google.com/docs/answer/3093480?hl=en) (read 2026-11-04)

## 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.

## Related tools

- [Email extractor](https://tools.joinvalley.co/email-extractor): Pulls every email address out of pasted text, drops duplicates and flags the risky ones.
- [Email permutator](https://tools.joinvalley.co/email-permutator): Lists every likely work email for a name and company, and checks the domain takes mail.
- [MX lookup](https://tools.joinvalley.co/mx-lookup): Shows a domain's MX records and who handles its email, for one domain or 500 at once.
- [LinkedIn Boolean search builder](https://tools.joinvalley.co/linkedin-boolean-search): Builds Boolean strings for LinkedIn, Sales Navigator and Recruiter, and fixes broken ones.
- [Buying committee map](https://tools.joinvalley.co/buying-committee-map): Maps who's in a B2B deal for what you sell, with titles and a LinkedIn search per role.

## Next step

Want replies, not just clean copy? Valley finds buyers showing real buying signals and messages them across email and LinkedIn. [Valley](https://www.joinvalley.co/?utm_source=tools_suite)

Shelf: [01 Data and prospecting](https://tools.joinvalley.co/data-and-prospecting)

---

Tools by Valley, made by [Valley](https://www.joinvalley.co/?utm_source=tools_suite). HTML version: https://tools.joinvalley.co/compare-two-lists
