Example: taking unsubscribes off a new batch of leads
A consultant has a fresh list of addresses in List A and her do-not-contact list in List B, which includes two people who asked not to be emailed again. One of them is written in capitals in the suppression list and the other has a trailing space in the new batch.
With Only in A selected and case sensitivity off, both are matched and removed. The repeated sales address and the blank line also disappear, leaving two addresses that are safe to consider for outreach.
List A: info@harbourcafe.example hello@brightsmile.example sales@kestrel.example sales@kestrel.example office@tidewell.example List B: HELLO@brightsmile.example office@tidewell.example
2 items info@harbourcafe.example sales@kestrel.example
Comparing two lists
Fill both boxes
One item per line in List A and List B. Leading and trailing spaces are ignored and empty lines are skipped.
Pick the result
Choose one of the five operations described in the table below. The heading above the result shows how many items it holds.
Decide on capitals
Leave Case sensitive off for email addresses and domains, where capitals do not matter. Turn it on for codes where they do.
Copy or download
Copy the result or download it as merged.txt.
The five operations
| Option | Returns | Typical use |
|---|---|---|
| Combine (A + B) | Every item from both, each once | Joining two exports into one master list |
| In both | Items found in A and in B | Which leads already exist in your CRM |
| Only in A | A with anything in B taken out | Removing unsubscribes or existing customers |
| Only in B | B with anything in A taken out | What a colleague added that you did not have |
| In one, not both | Items in exactly one list | Spotting differences between two versions |
Questions people ask
How do I remove one list from another?
Put the list you want to keep in List A and the items to remove in List B, then choose Only in A. With Case sensitive off, matching ignores capitals and extra spaces, which is what you want for email addresses. The result keeps List A's order and spelling.
Does the merged list keep my original order?
Yes. Items appear in the order they are first met, List A first and then anything new from List B. When the same item appears in different spellings, such as Hello@ and hello@, the first one seen is the one kept.
Can I compare spreadsheet columns this way?
Yes, copy each column into its own box. This compares whole lines, so it works for a single column such as emails or domains. For matching rows on one column while keeping the others, use the CSV deduplicator or a spreadsheet lookup instead.
Where your data goes
Both lists are compared inside your browser tab. Contact lists and suppression lists are never uploaded to Map Extract or anyone else.
Checked against the tool on