Guide

How to clean an email list (step by step)

A clean list means fewer bounces, fewer spam complaints, and numbers you can trust. This checklist works in any spreadsheet, with Google Sheets examples.

Updated November 17, 2026.

The short answer

To clean an email list, put every address in one sheet, trim spaces and lowercase them, remove duplicates, and fix obvious typos. Then verify each mailbox, remove the addresses that are not deliverable, and set aside contacts who have unsubscribed or haven't engaged in a long time.

Work on a copy of your list. Several steps delete rows, and you'll want the original if something goes wrong.

Step 1: collect everything into one sheet

Lists drift apart: a newsletter export, a CRM export, a form response sheet, a spreadsheet from an event. Bring them into one place first, or you'll clean the same problems several times.

  • Put the email address in column A, starting in row 2, with a header like "Email" in row 1.
  • Keep useful columns next to it: name, where the contact came from, the date they signed up, and their last open or click if you have it.
  • Pull your unsubscribe and complaint list too. You'll need it in step 9.

Step 2: trim spaces and lowercase

Stray spaces and mixed capitals make the same address look like two different ones. In an empty column, enter:

=LOWER(TRIM(A2))

Drag it down. Then copy the new column and paste it back over column A with Edit › Paste special › Values only, and delete the helper column.

Mail providers treat Jane@Company.com and jane@company.com as the same inbox in practice, so lowercasing is safe for sending and makes the next step work properly.

Step 3: remove duplicates

Sending the same email twice to one person annoys them and invites a spam report. In Google Sheets:

  1. Select your data, including the header row.
  2. Choose Data › Data cleanup › Remove duplicates.
  3. Tick Data has header row, and select only the email column to compare.

Want to see the duplicates before deleting them? Add a helper column with:

=COUNTIF(A:A, A2) > 1

TRUE marks an address that appears more than once. If you'd rather not touch the original, =UNIQUE(A2:A) on a new tab gives you a de-duplicated copy. More options are in how to remove duplicate emails in Google Sheets.

Step 4: fix obvious typo domains

Typos usually come from people typing their own address into a form. A few are easy to spot and safe to fix:

  • gmial.com, gamil.com and gmail.con are meant to be gmail.com.
  • hotmial.com is meant to be hotmail.com.
  • yaho.com is meant to be yahoo.com.

To find them, pull the domain into its own column and sort by it. Misspellings sit right next to the real domain:

=REGEXEXTRACT(A2, "@(.+)$")

To flag anything that isn't even shaped like an email, use =ISEMAIL(A2) and look at the FALSE rows. Only fix a typo when the intended address is obvious. If you're guessing, leave it for the verification step to judge.

Step 5: verify every mailbox

Steps 1 to 4 fix formatting. They can't tell you whether jane@company.com still exists. For that you need a mailbox check, which asks the recipient's mail server whether it would accept mail for the address. Nothing is sent to the person. How to check if an email address is valid explains how this works.

If your list is in Google Sheets, the Email Verification add-on does this in place. Choose Extensions › Email Verification › Open and click Verification. Up to 100 addresses fill in row by row. Larger lists, up to 250,000, run in the background and are imported from Bulk Results. See how to verify emails in Google Sheets for the full walkthrough.

Step 6: decide on catch-all and shared inboxes

Two kinds of results need a judgment call rather than automatic deletion.

Catch-all addresses

Some domains accept mail for any address, so the specific mailbox can't be confirmed. In the add-on these show as deliverable? (catch-all, not confirmed). If the contact is valuable, such as a known customer, keep it. If the list came from an unknown source, consider sending to these in a small separate batch first. More in what is a catch-all email.

Shared inboxes

Addresses like info@, sales@ or support@ show as deliverable (shared inbox). They work, but several people may read them, and nobody in particular signed up. Keep them for business announcements to a company. For personal newsletters, consider removing them.

Step 7: remove the addresses that are not deliverable

Turn on a filter with Data › Create a filter. On the Status column, show only not deliverable, select those rows, and delete them. These are invalid, disabled, throwaway or spam-trap addresses. Sending to them causes hard bounces and hurts your sender reputation.

Don't delete inbox full (try again later) or unknown (mail server did not answer) rows yet. Filter them into their own tab and check them again in a few days.

Step 8: segment or remove long-unengaged contacts

A mailbox can exist and still belong to someone who never opens your email. Mail providers notice when a sender keeps mailing people who ignore it.

  • Use your email tool's open and click data to find contacts who haven't engaged in a long time. What counts as "long" depends on how often you send.
  • Move them to a separate segment rather than mailing them with everyone else.
  • Send that segment one short re-engagement email asking if they still want to hear from you. Remove the ones who don't respond.

Step 9: respect unsubscribes and complaints

Cleaning must never bring back someone who opted out. Before you import the cleaned list anywhere, remove every address on your unsubscribe and spam-complaint list. A quick check in Sheets, with the opt-out list on a tab called Unsubscribed:

=COUNTIF(Unsubscribed!A:A, A2) > 0

TRUE means remove the row. Keep that opt-out list permanently, separate from your main list, so a future import can't undo it.

How often to clean your list

There's no single schedule that fits every sender. Clean when the risk is highest:

  • Before a big send, especially a campaign that matters. See verifying emails before a mail merge.
  • Before using an older list you haven't mailed in a while. People change jobs and abandon inboxes.
  • After importing new contacts from a form, an event, or a purchased or inherited list.
  • When your bounce rate rises noticeably compared with your usual sends.

FAQ

How often should I clean my email list?

Clean it before any big send, before reusing a list you haven't mailed in a while, and after importing new contacts. If your bounces start rising, clean it sooner.

Should I delete catch-all email addresses?

Not automatically. A catch-all domain accepts every address, so the mailbox can't be confirmed either way. Keep catch-all contacts you know are real, and send to unknown ones in a small batch first.

Can I clean an email list in Google Sheets for free?

Partly. Trimming, lowercasing, removing duplicates and flagging badly formatted addresses are all free with built-in tools. Checking whether each mailbox exists needs a verification service. The Email Verification add-on includes 50 free verifications for new accounts.

Does cleaning an email list remove unsubscribed contacts?

Only if you do it yourself. Verification tells you whether a mailbox exists, not whether the person opted out. Always remove addresses on your unsubscribe and complaint list before sending.

Ready to verify your cleaned list? Install Email Verification free and check your first 50 addresses. After that, credits are prepaid and never expire. See pricing.