Suppression list

Removes every row that also appears in a second list: customers, do-not-contact or people you already emailed.

1. Your list
CSV or Excel, up to 200,000 rows
2. Who to remove
A customer list, a do-not-contact list or people you already emailed.
Runs in your browser. The file never leaves your device.CSV or Excel, up to 200,000 rows

Next

Email me this report
A short summary of this run: the counts and settings, never your rows. Your file stays in your browser.
The counts from this runThe settings you usedNo file, no rows, no saved link
One email with the report. No sequence, no sales call.
Ken cleans every list you import, then verifies it.
Import once. Ken dedupes, formats and verifies every address, and keeps the flags with each lead.
Start free - 1,000 credits, no card

What the suppression list tool does

It removes every row from your lead list that appears in a second list: customers, open deals, people who unsubscribed, people who asked not to be contacted, or contacts already in another campaign. Match by email, by domain to exclude whole companies, or by both.

Both files are read in your browser and never uploaded.

How to read the result

The counts show how many rows matched the suppression list and how many are left. Matches are split by type, email or domain, so you can see whether you removed individuals or whole accounts. The removed rows come as a second file.

How to use it

Keep one suppression file that every list goes through before a campaign. Add unsubscribes and "do not contact" replies to it as they arrive, export your customer and open-deal domains from the CRM into it, and run every new list against it. Use domain matching for customers, so nobody at a customer company gets a cold email.

Why it matters for cold email

Emailing someone who opted out breaks the rules in most markets. CAN-SPAM requires you to honour an opt-out within 10 business days. Under GDPR Article 21, once someone objects to direct marketing you must stop using their data for it. A cold email to a current customer is not illegal, but it is embarrassing and it costs trust with an account you already have.

Questions

What is a suppression list?
A list of email addresses or domains you must not email. It usually holds unsubscribes, bounces, complaints, customers and anyone who asked not to be contacted. Every campaign list is checked against it before sending.
How do I remove one list from another in Excel?
With a COUNTIF or XLOOKUP column that marks matches, then a filter and delete. It is exact-match only, so "[email protected]" and "[email protected]" do not match. This tool normalizes both lists first and can match on domain as well as email.
Should I keep unsubscribed people's emails after they opt out?
Keep the address on a suppression list and nothing else. That is how you make sure you never email them again, and regulators such as the UK ICO accept keeping the minimum needed to honour the objection. Delete the rest of their data if you have no other reason to hold it.
Can I suppress whole companies?
Yes. Put the company domain in the suppression file and choose domain matching. Every address at that domain is removed, including subdomains such as eu.acme.com.
Is my suppression list uploaded?
No. Both files stay in your browser. Suppression lists hold sensitive data such as customer and opt-out records, which is why this runs on your device.

More in CSV tools

14 tools.