How to Keep Only the Emails at Your Target Company Domains

To keep only the emails at your target companies, paste the company domains you want, load your list, and keep rows whose address is on one of those domains. The email list domain allowlist filter does this in your browser, keeps all other columns, shows which target domains matched nothing, and gives you the kept and removed rows as two files.

It filters on the text of the address. It does not check that the mailboxes work.

Why filter a list down to target domains

Account-based lists are often built from a larger export that also holds people at other companies, free providers and partners. Keeping only the accounts you chose avoids sending to the wrong people, and it cuts the number of rows you pay to verify.

The by-hand way

1. Add a column holding the text after the @ in each address, lower-cased.
2. Put your target domains on a second sheet.
3. Use COUNTIF or a lookup to mark rows whose domain is on the target sheet.
4. Filter on the mark and copy the kept rows out.

Subdomains and www prefixes are where it goes wrong: mail.acme.example will not match acme.example unless you handle it yourself.

Step 1: load the list

Upload the list as a CSV or .xlsx, or paste the cells with the header row first. It needs an Email column.

Step 2: paste the target domains

Paste your target domains, one per line. A website address or an @domain is read as the bare domain.

Step 3: run the filter

Choose whether subdomains count, then press Keep the target domains. Read the kept rows and the domains that matched nothing, then download the kept and removed files.

To remove a few domains instead of keeping a few, use remove emails by domain.

What this check cannot do

• It matches the domain text only. A person who has left the company still matches.
• One company can use several domains. Add every one you want.
• It does not look up whether a domain exists or takes mail.
• The result depends on a column called Email, so check your header row.

To see how many addresses each domain holds first, see counting emails by domain.

One more pass before sending

Filtering gives you the right accounts. The addresses at those accounts can still be closed or guessed. You can upload the file to the verify page and get the first 100 checks free after a Google sign-in, no card needed. Each address is marked valid, risky or invalid with a reason, and the check sends nothing to the people on it. List cleaning and bulk email verification cover regular or large jobs.

Try it now

Paste your domains and list into the email list domain allowlist filter.