How to Verify Emails in a CSV or Excel File
To verify emails in a CSV or Excel file, save the sheet as a CSV with the addresses in one column, upload it on the verify page, and download the results: your original columns plus status, reason and send_advice. Excel formulas can only check an address's shape; whether the mailbox exists needs a check against the mail server. The first 100 checks are free with a Google sign-in, no card, so try your file now.
Prepare the file
- One header row. Put column names in row 1 and the data under it. No merged cells, no blank rows at the top.
- Emails in one column. If a cell holds several addresses separated by commas, split them first with the free split multiple emails in a cell tool.
- Save as CSV. In Excel: File, Save As, CSV. If your file has accented names, choose the UTF-8 CSV option so they survive.
- Check the free basics. The Excel email verifier and CSV email verifier take a file or a paste, find the email column, and flag bad syntax, duplicates, typo domains, domains with no mail server and disposable addresses in your browser.
Upload and read the results
Upload the CSV on the verify page. When the list finishes, the download is your file with three added columns:
| Column | What it holds |
|---|---|
status |
valid, risky or invalid |
reason |
The specific cause, in words |
send_advice |
safe, care, retry or do_not_send |
Sort or filter on status in Excel to split the sheet, then follow how to verify an email list: send valid, test risky in a small batch, suppress invalid. The meaning of every reason is in how to read a verification report.
Common problems
- Numbers or IDs changed. Excel can strip leading zeros and turn long numbers into scientific notation. Format those columns as Text before saving.
- File too big for Excel. See verifying a list too big for Excel.
- Results gone. Result files are deleted 7 days after a list is submitted; download them and keep each address's status and check date.
Cost
After 100 free checks: packs start at $15 for 10,000 checks and never expire, Starter is $9 a month for 2,500 emails, and Pro is $39 a month with the first 100,000 checks a month at full speed, then slower, never cut off. See pricing. Large files: what 50k to 100k emails cost and how long they take.
Verify your file
Upload the CSV on the verify page: 100 free checks, Google sign-in, no card.
Common questions
How do I verify emails in an Excel file?
Save the sheet as a CSV, upload it on the verify page, and download the results: your original columns plus status, reason and send advice.
Can Excel verify emails on its own?
Only the format. Excel formulas can test for an @ and a dot, but not whether the mailbox exists.
Will my other columns be kept?
Yes. The results file keeps your original columns and adds status, reason and send advice.
What about a file with 100,000 rows?
Big files work but take longer on shared capacity; the list card shows an estimated finish. See the guide to verifying 50k to 100k emails.
Check your list before you send
Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.