Map Extract
Free tool

Merge suppression lists into one master file

Add the opt-out, bounce and do-not-contact files you have collected from different tools, or paste a list, and get one clean master file. Every email, domain and phone number is normalised so the same entry written two ways is kept once, and you can see which file each came from.

Runs in your browser. Nothing you enter is uploaded.

Building a master suppression file

  1. Add the files

    Press Choose suppression files (CSV or text) and select one or several. Add more later the same way; Clear files starts again.

  2. Paste extra entries

    Use the paste box for anything not in a file, such as a list of domains a client asked you to avoid.

  3. Read the totals

    The summary shows unique entries and how many are emails, domains and phone numbers.

  4. Check each source

    A table lists every file with its entries, how many appear only there, how many also appear in another file, and cells skipped because they were not an email, domain or phone. With two to six files, an overlap grid shows how many entries each pair shares.

  5. Download

    Download master suppression file gives a CSV with value, type, number of sources and the file names. Copy values copies just the entries.

Three files from three tools

An unsubscribe export, a bounce list and a do-not-call sheet. The same person appears in the first two with different capitals; one file has a mailto: prefix; the bounce list holds a website URL; the call sheet has one number in two formats and a notes column.

Four unique entries remain. Sue's address is lower-cased and listed once with both files as sources. The URL becomes the domain copperleaf.example, so the whole business is suppressed. The two phone formats collapse to +441632960102. Header cells and the note text are counted as skipped, which is why unsubscribes.csv shows 1 and do-not-call.csv shows 3.

Input
unsubscribes.csv:  email / [email protected] / mailto:[email protected]
bounces.txt:       [email protected] / https://www.copperleaf.example/contact
do-not-call.csv:   phone,note / 01632 960102,asked not to be called / +441632960102,
Result
Unique entries: 4   Emails: 2   Domains: 1   Phones: 1

copperleaf.example           domain  1  bounces.txt
[email protected]  email   1  unsubscribes.csv
[email protected]     email   2  unsubscribes.csv; bounces.txt
+441632960102                phone   1  do-not-call.csv

How entries are normalised

Written asStored asType
[email protected][email protected]email
mailto:[email protected][email protected]email
@competitor.examplecompetitor.exampledomain
https://www.shop.example/pageshop.exampledomain
0161 496 0000 or +44 161 496 0000+441614960000phone
Anything elseSkipped and countednone

One list, applied everywhere

Opt-outs tend to scatter. An unsubscribe lands in one sending tool, a bounce in another, a phone request in a notes field, a complaint in someone's inbox. If each channel only checks its own list, a person who asked one tool to stop can still be contacted from another. A single master file, checked before every campaign and every call list, closes that gap.

Suppressing a domain covers every address at that business, which is the right response when a company asks not to be contacted at all. For one person who unsubscribed, suppress the address, not the domain, so colleagues who did not object are not removed by accident. Keep the file: it is your record that you honoured requests.

Questions people ask

What is a suppression list in email marketing?

A suppression list is a list of addresses, domains or numbers you must not contact, built from unsubscribes, hard bounces, complaints and direct requests. Before each campaign you remove anyone on it from the send list. Keeping suppressed entries, rather than deleting them, is what stops them being re-added from a new data source.

Can I mix emails, domains and phone numbers in one file?

Yes. Every cell in every file is checked and typed as an email, a domain or a phone number, and each type is normalised in its own way. The master file has a type column, so your sending tool or dialler can filter for the entries it needs.

Why were some cells skipped?

A cell is skipped if it is not an email, a domain or a phone number, such as a header like email or phone, a date, or a note such as asked not to be called. The count per file shows how many were skipped, so a large number is a hint that a column of real entries was not recognised.

How should I use the master file?

Import it as the suppression or do-not-contact list in each tool you send or call from, and check new lead lists against it before they go anywhere. Re-run the merge whenever any source list changes. The sources column helps you answer when and where an opt-out was recorded.

Where your data goes

All files are read and merged in your browser. The addresses and numbers in them are not uploaded, and the master file is written locally.

Checked against the tool on

Top