How to verify emails in Excel step by step

To verify emails in Excel, clean the address column, remove blanks and duplicates, then save the sheet as a CSV file. Upload that CSV to an email verification tool, run the check, and export the results. Filter for Deliverable rows and paste them back into your Excel workbook.

Can you verify emails inside Excel itself?

Not reliably. Excel can flag broken syntax with a formula, but it cannot check whether a mailbox actually exists. Real verification needs an MX-record lookup and an SMTP-level check against the mail server. For that, export your column to CSV and run it through a dedicated verifier.

A formula gets you partway. Something like =ISNUMBER(MATCH("*@*.?*",A2,0)) gives a rough pattern check, and it is worth running to catch obvious typos: a missing @, a trailing comma, a domain with no dot. But a pattern test cannot see a mailbox that was deleted last month, a domain with no mail server, or a known spam trap. Syntax is a spelling test. Verification is a phone call to the mail server. You want both, but only the second one protects your sender reputation and keeps hard bounces off your record.

Step 1: prep your email column in Excel

Good verification starts with a clean column. Put one email address per row in a single column with a clear header such as Email. Mixed formatting, merged cells, and stray notes in the same column cause parsing errors when you export, so spend two minutes tidying before you save anything. A clean input is the difference between a smooth run and a file the verifier chokes on.

1. Select your email column and run Data, then Remove Duplicates. Duplicates waste quota and skew your counts.
2. Wrap addresses in =TRIM(A2) to strip leading and trailing spaces, then paste the values back as plain text.
3. Delete fully blank rows so the CSV does not carry empty cells.
4. Lowercase everything with =LOWER(A2) to keep the list consistent.
5. Scan visually for obvious breakage: two @ signs, spaces inside an address, or a missing domain.

You do not need to hunt for disposable or role addresses (info@, sales@) by hand. A good verifier flags those automatically. Your job in Excel is simply to hand over a clean, deduplicated list.

Step 2: export the sheet to CSV

With the column ready, save a copy as CSV. In Excel, choose File, then Save As, and pick CSV UTF-8 (Comma delimited) from the format menu. UTF-8 matters if any names or domains use accented characters. Keep the original .xlsx too, so you always have your working copy.

CSV is the format every verifier accepts, and it keeps things simple: just rows and columns, no formulas, no cell colors, no hidden sheets. If your tool parses the file in the browser instead of uploading it, your list never leaves your machine, which is the safest option for a spreadsheet full of customer or prospect addresses. Check for that browser-side parsing if privacy matters to you.

Step 3: run the CSV through verification

Open your verification tool and drop the CSV in. A local safety scan runs first, catching bad syntax, duplicates, and disposable domains instantly without touching your daily quota. The remaining addresses get an MX-record lookup to confirm the domain accepts mail, then an SMTP-level check to confirm the individual mailbox exists. Typo suggestions appear where an address looks close to a real one, so you can fix a fat-fingered gmial.com in seconds.

Watch your daily quota as you go. The local safety scan does not spend it, so duplicates and disposable domains get filtered for free. Only the addresses that reach the MX and SMTP stage count against your limit. If you have a large sheet, verify in batches across a few days, or clear obvious junk in Excel first so every check you spend lands on a real candidate.

Our Free Email Verifier runs this step in the browser. Drop the CSV and get 10 checks a day with no signup, or 100 a day after you enter just an email (no password, no card). If you would rather hand off list building and outreach altogether, Synthisia runs done-for-you pipeline on the same verification discipline.

What do the verification results mean?

Most tools return four verdicts. Deliverable means the mailbox exists and accepts mail. Risky covers catch-all, role, and disposable addresses that may or may not bounce. Invalid means the mailbox or domain does not exist. Unknown means the server gave no clear answer. Keep Deliverable, review Risky, and drop Invalid.

Do not treat Risky as a synonym for bad. A role address like support@ is legitimate, it just belongs to a team, not a person. A catch-all domain accepts mail at any address, so the server says yes without proving the mailbox exists. Sort Risky rows by type and decide per campaign rather than deleting them all.

Step 4: filter deliverable rows back in Excel

Export the results as CSV or JSON and open the CSV back in Excel. The verifier adds a status column next to each address. Turn on AutoFilter (Data, then Filter), click the dropdown on the status column, and select only Deliverable. Copy those rows into a clean sheet and you have your send-ready list.

Handle Risky rows on purpose, not by accident. Role addresses can be fine for support outreach but weak for cold email. Catch-all domains accept everything, so a Deliverable-looking result there is less certain. When bounce rate matters, keep Risky out of your first send and test them in a small, separate batch.

How often should you re-verify your Excel list?

Re-verify any list older than 90 days, and always verify right before a send. Email addresses decay by roughly 2 to 3 percent a month as people change jobs and close accounts. A list that was clean in January will carry dead addresses by April. Fresh verification keeps your bounce rate under 2 percent.

That is the whole workflow: prep the column, export to CSV, verify, then filter Deliverable rows back into your workbook. Do it before every campaign and your Excel list stays an asset instead of a liability.