How to Remove All Emails That Contain a Word (test, demo, noreply) From a List

To remove emails that contain a word, look for the word in the part you choose (before the @, the domain or the whole address) and drop the rows that match. The remove emails containing a word tool does this in your browser. You type the words, choose where to look and whether whole words only, and download the rows kept and the rows removed with the word that matched on each.

It is the right tool for words specific to your list, like a competitor name.

Which words are worth removing

Scrapers and exports pick up addresses that belong to no one: test@, demo@, sample@, noreply@, no-reply@ and donotreply@. Mail to a no-reply address is never read, and a test address is often a placeholder. Role mailboxes such as info@, admin@ and postmaster@ are a separate group, standardised in RFC 2142. See role-based email addresses for when to keep them.

Step 1: do it by hand

In Excel, filter the email column with Text Filters, Contains, type the word, then delete the visible rows and clear the filter. It works for one word at a time and only on the whole cell, so you cannot look just at the domain. Repeat for each word, and there is no record of what you deleted.

Step 2: use the tool

1. Upload the CSV or .xlsx, or paste the cells with a header row and an Email column.
2. Type the words to look for, one per line or separated by commas.
3. Choose where to look and whether to remove or keep.
4. Download the rows kept and the rows removed.

Each address is lower-cased and the words are looked for inside the part you choose. Looking before the @ finds demo@example.com but not someone@demo-labs.com; looking at the domain does the reverse.

Whole words or any match

With whole words only, the part is cut at every dot, dash, underscore, plus sign and digit and the pieces are compared. So info matches info@ and sales.info@ but not information@. With it off, any address containing those letters matches, and test also catches contest@. The removed file lists the word that matched on each row, so you can put a row back.

Remove a whole domain instead

To remove entire domains and their subdomains, use remove emails by domain. For the standard role mailboxes, use the role-based email filter, and for made-up addresses the fake email checker. See also clean your list before a campaign.

What this cannot do

• It matches letters, not meaning, so a word inside a real name can match unless you use whole words only.
• It cannot tell a role address from a person except by the words you give it.
• Only the first sheet of a workbook is read.
• It does not check whether a kept address exists.

Verify what is left

Upload the kept list on the verify page: the first 100 email checks are free with a Google sign-in, no card. Each address comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger or recurring lists, see bulk email verification, list cleaning and pricing.

Remove your words now

Upload the list to remove emails containing a word.