What a Suppression List Is and Why You Keep It Forever

A suppression list is the list of people you must never email again. It sounds like a minor admin detail, but it's the thing that keeps an unsubscribe from turning into a complaint, and a complaint from turning into your emails landing in spam for everyone.

This guide explains what belongs on a suppression list, why you keep it permanently, how to strip those people out of any list before you send, and how to bring it with you when you change email tools. That last moment is when most suppression lists get lost.

What a suppression list is

Think of it as a "do not send" list that sits next to all your other lists. Before any email goes out, every address on the suppression list is removed from the send. People usually end up on it for one of four reasons:

Some businesses also add addresses they've chosen never to email, such as competitors or their own staff. That's optional; the four above are the ones that matter.

A soft bounce, like a full mailbox, is different. It's a temporary problem, so most email tools retry and only suppress the address if it keeps failing.

Why not just delete them?

Because deleted people come back. You delete Priya from your list after she unsubscribes. Six months later you import a spreadsheet from a trade show where she also signed in, or a colleague shares an old export, and Priya is back on your list with no trace that she ever opted out. She gets your newsletter again and, this time, she reports it as spam.

A suppression list remembers. It's checked against every new import and every send, so an opt-out stays an opt-out no matter where the address turns up next. That's why it's a separate list, and why you never delete from it.

Why you keep it forever

There are three good reasons not to clear it out, ever.

• The law. In the U.S., the FTC's CAN-SPAM compliance guide says you must honor an opt-out within 10 business days, and once someone opts out you can't sell or transfer their address, even as part of a mailing list. It also says you stay responsible even if another company sends your email for you. Other countries have their own rules. This is not legal advice, just the plain basics: once someone opts out, they stay out unless they sign up again themselves.
• Your sender reputation. Google's email sender guidelines ask senders to keep the spam rate reported in Postmaster Tools below 0.1% and never let it reach 0.3% or higher. Emailing people who already told you to stop is one of the fastest ways to collect spam reports.
• Bounces don't fix themselves. An address that hard-bounced is almost always gone for good. Sending to it again tells mailbox providers you don't look after your list.

A suppression list is just text, so even a list of thousands of addresses takes up almost no space. There's no cost to keeping it.

Build your own master suppression list

Your email tool keeps its own suppression list, but you should also keep a master copy you control. A simple spreadsheet is enough:

• Email, stored in lowercase with no spaces (use =LOWER(TRIM(A2)) on anything you paste in)
• Reason: Unsubscribe, Hard bounce, Complaint or Do not contact
• Date it was added
• Source, such as "Newsletter tool export" or "Phone call, front desk"

Add to it whenever a request comes in from outside your email tool, like a reply, a phone call or a note from a colleague. Those are the opt-outs most likely to be forgotten, because no tool recorded them automatically.

Remove suppressed people from a list with COUNTIF or MATCH

Say you have a new list to send to on a tab called Send, with emails in column A. Put both tabs in the same workbook. Then:

1. In B1 of the Send tab type Suppressed?
2. In B2 enter:
   =COUNTIF(Suppression!$A:$A, LOWER(TRIM(A2)))>0
3. Fill it down. TRUE means the address is on your suppression list. FALSE means it's fine to keep.
4. Turn on a filter (Excel: Data > Filter; Google Sheets: Data > Create a filter), show only TRUE, and delete those rows. Then clear the filter.

If you prefer MATCH, this does the same check and works the same way in Excel and Sheets:

=ISNUMBER(MATCH(LOWER(TRIM(A2)), Suppression!$A:$A, 0))

Both are case-insensitive, so capital letters won't let anyone slip through, but extra spaces will. That's why the formulas trim the address being checked and why the suppression list should be stored clean.

Build a clean send list in one formula

If you have Excel for Microsoft 365 or Excel 2021 or later, you can create the filtered list on a new tab instead of deleting rows:

=FILTER(Send!A2:A1000, (COUNTIF(Suppression!A:A, Send!A2:A1000)=0)*(Send!A2:A1000<>""))

In Google Sheets, FILTER takes the conditions as separate arguments:

=FILTER(Send!A2:A, COUNTIF(Suppression!A:A, Send!A2:A)=0, Send!A2:A<>"")

Both return only the addresses that are not suppressed, skipping empty rows. Trim the Send column first (Sheets: Data > Data cleanup > Trim whitespace), since these versions compare the addresses as they are.

The quick way: remove one list from another

No formulas needed: open our free Compare Lists tool, paste the list you want to send to on one side and your suppression list on the other, and choose to remove one list from another. You get back only the addresses that are safe to email, ready to copy or download. It runs in your browser, so neither list is uploaded anywhere, which is exactly what you want for a list of people who asked to be left alone.

Keep it when you switch email tools

Changing from one email platform to another is when suppression lists most often vanish. You export your active subscribers, import them into the new tool, cancel the old account, and the unsubscribes, bounces and complaints stay behind in the old system. The first send from the new tool goes to all of them.

Before you cancel anything:

1. Export every suppressed group from the old tool. Platforms label them differently: unsubscribed, bounced, cleaned, complained, blocked or suppressed. Look for all of them, not just "unsubscribed".
2. Add them to your master suppression list with the reason and the date of export.
3. Import them into the new tool as unsubscribed or suppressed, not as regular contacts. Most platforms have a specific option for this; check the new tool's help pages.
4. Remove them from your active import too, using the formulas or the compare tool above, so you aren't relying on the new tool to catch them.
5. Don't close the old account too early. The FTC guide says your opt-out method must keep working for at least 30 days after you send a message, so make sure unsubscribe links in your last emails from the old tool still work, or that requests reach you some other way.

Before you send: catch the next round of bounces

Your suppression list covers addresses that have already bounced. It can't warn you about the ones that will bounce next time, like a contact who left their job last month. To find those before they hurt your sending, check your list with Veml, which asks each mail server whether the mailbox exists without sending an email. Anything marked Invalid can go straight onto your suppression list with the reason "Failed verification", so you never pay to check it again.

Habits that keep it working

• Run every new import against the suppression list before it goes into your email tool, not after.
• Add opt-outs the same day you receive them, wherever they came from.
• Never re-add someone from the suppression list unless they sign up again themselves, through your own form.
• Keep one master copy, not a different version on every laptop.

If you're combining lists from different places, our guide to merging contact lists shows how to carry unsubscribe status through the merge.