A formula can confirm an address looks valid, but ceo@kodak.com passes every formula and still bounces. Here is how to actually verify an Excel list.
Clean my Excel list, free Bulk verifier 100 free credits, no card. Pay only for Passed & Failed. Credits never expire.Excel formulas and even VBA regex macros only check format. A perfectly formatted address on a dead domain passes every check and still bounces, because Excel performs no MX or DNS lookup, no SMTP check, and cannot detect disposable, catch-all, role or spam-trap addresses. Real verification needs a live conversation with the mail server, which Excel simply cannot make.
The specific ways an unverified Excel list costs you money and deliverability.
Functions like ISNUMBER and SEARCH confirm an @ and a dot. They say nothing about whether the mailbox exists.
A long AND formula or a VBA macro is brittle, intimidating, and still blind to deliverability, catch-all and disposable domains.
Excel cannot look up mail servers or ask whether an inbox is real, which is exactly what verification requires.
The accurate, current steps, from export to a clean, safe-to-send list.
In Excel you can flag obviously malformed entries with a formula like =AND(ISNUMBER(FIND("@",A2)),ISNUMBER(FIND(".",A2,FIND("@",A2)))), or block them at input with Data Validation. Treat this as a first pass only.
Keep a clean Email column with a clear header, then File, Save As, CSV (or upload the XLSX directly if the verifier accepts it).
Upload the file to the Email Verifier API bulk verifier. Each row is checked for syntax, domain, MX, live SMTP, catch-all, disposable, spam-trap and role status.
Download the results, filter to the Passed addresses, and paste them back into your working sheet or sending tool.
What the native option does, and where real verification fills the gap.
| Capability | Excel (native) | Email Verifier API |
|---|---|---|
| Checks if mailbox exists | No (format only) | Yes, live SMTP check |
| MX / DNS lookup | No | Yes |
| Catch-all / disposable / role | No | Yes, flagged clearly |
| Handles large lists | Manual | Yes, bulk upload |
| Credits expire | n/a | Never |
Cleaning your Excel list, answered.
Excel can check the format with a formula or VBA, but it cannot confirm the mailbox exists. A correctly formatted address like ceo@kodak.com passes every Excel check and can still bounce. Real verification needs a live SMTP check Excel cannot perform.
Optionally flag malformed entries with a formula or Data Validation, then save the list as CSV, upload it to the Email Verifier API bulk verifier, and keep only the addresses marked deliverable.
Formulas only check syntax. They perform no MX or DNS lookup and no SMTP check, and they cannot detect disposable, catch-all, role or spam-trap addresses, all of which require contacting the mail server.
Saving as CSV is the most reliable way to upload, though many verifiers accept XLSX directly. Either way, keep a clearly labelled Email column.
Pay-as-you-go, one credit per address, billed only for Passed and Failed results, credits never expire, and 100 free credits to start.
Start with 100 free credits, no credit card. See exactly how many of your Excel contacts are about to bounce.
Verify my list free