SimpleVerifier Team · Reviewed
How do I verify email addresses in Excel?
Excel can clean and syntax-check a list, with TRIM, LOWER, Remove Duplicates and, in Microsoft 365, REGEXTEST. It cannot confirm that a mailbox exists. Save the column as a CSV, run it through a verifier that does an SMTP mailbox check, and filter the results file on the status column.
Steps
The steps, in order.
- Put the addresses in one column and make a cleaned helper column with =LOWER(TRIM(A2)).
- Use Data > Remove Duplicates on the cleaned column.
- Optionally flag malformed rows with a pattern test (REGEXTEST in Microsoft 365).
- Save as CSV (UTF-8) and upload it to a verifier. SimpleVerifier accepts a CSV with any email header, comma or semicolon separated.
- Open the results and filter: send valid, suppress invalid, segment risky.
Related questions
- Is there an email validation function in Excel?
- No dedicated one. Microsoft 365 has REGEXTEST for pattern checks; older versions need a longer formula that lets some malformed addresses through.
Sources
Figures marked as ours come from SimpleVerifier’s own dated tests on made-up addresses, published with their data on the research page. No customer data is used, and we publish no accuracy percentage because we have no independent measurement to back one.
Do it now
Test it on a real address first
Type any address. It gets the same check the paid plans run: syntax, the domain’s mail servers and, where the provider allows it, a live mailbox check. Nothing is sent to the address.
Five checks a minute, no account needed. Nothing is sent to the address — we ask its mail server whether the mailbox exists, then disconnect.
Have a list? Sign in with Google and the first 100 addresses are checked free, with results to download. No card.
By continuing you agree to our Terms and Privacy Policy.