Map Extract
Free tool

Merge and compare two lists

Paste one list in each box and choose what you want back: everything combined, only the shared lines, only what is in one list, or what is in either but not both. Duplicates, blank lines and stray spaces are dealt with along the way.

Runs in your browser. Nothing you enter is uploaded.

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.

Comparing two lists

  1. Fill both boxes

    One item per line in List A and List B. Leading and trailing spaces are ignored and empty lines are skipped.

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

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

  4. Copy or download

    Copy the result or download it as merged.txt.

The five operations

OptionReturnsTypical use
Combine (A + B)Every item from both, each onceJoining two exports into one master list
In bothItems found in A and in BWhich leads already exist in your CRM
Only in AA with anything in B taken outRemoving unsubscribes or existing customers
Only in BB with anything in A taken outWhat a colleague added that you did not have
In one, not bothItems in exactly one listSpotting 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

Top