Validate Email Addresses in TSV Files Online
Validate email addresses in TSV files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
How to validate Email Addresses in TSV files
- Drop your file onto the upload area. It is loaded into the in-browser engine and the first 200 rows are shown.
- Choose the email column. The tool preselects the first column whose name contains "email" or "mail", otherwise the first column.
- Pick an action: Flag all rows adds an email_valid column (true or false), Keep invalid only returns the rows that fail, and Keep valid only returns the rows that pass.
- Click Validate Emails. The counts of valid and invalid addresses and the percentage invalid appear next to the result.
- Download the result in the same format you uploaded.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A conference exports its registration sheet before sending joining instructions. Some addresses were typed by hand at the desk, and one attendee left the field empty.
Input (TSV)
attendee email ticket
Priya Nair priya.nair@uni.edu student
Jonas Weber jonas.weber@firma standard
Sam O'Neill sam.o'neill@mail.ie standard
Lucía Gómez lucia.gomez@correo.es speaker
Wei Chen student
Tom Hart TOM.HART@Example.CO.UK standardSettings
- Email column: email
- Action: Flag all rows
Result
| attendee | ticket | email_valid | |
|---|---|---|---|
| Priya Nair | priya.nair@uni.edu | student | true |
| Jonas Weber | jonas.weber@firma | standard | false |
| Sam O'Neill | sam.o'neill@mail.ie | standard | false |
| Lucía Gómez | lucia.gomez@correo.es | speaker | true |
| Wei Chen | NULL | student | NULL |
| Tom Hart | TOM.HART@Example.CO.UK | standard | true |
Jonas's address has no dot and suffix after the domain, so it fails. Sam's address is legal under the email standard, but the apostrophe is outside the allowed character set, so it is flagged false. Upper case is fine. The empty cell gets no verdict. The summary reads 3 valid, 2 invalid (40.0% invalid), and Wei Chen is counted in neither.
Frequently Asked Questions
What rule does the validator apply?
The whole value must be a local part of letters, digits and . _ % + -, then one @, then a domain of letters, digits, dots and hyphens ending in a dot and at least two letters. It is a practical format check, not a full RFC 5322 parser.
Can valid addresses be rejected, or bad ones accepted?
Yes, at the edges. Legal but unusual addresses fail, such as ones with an apostrophe, accented letters, quoted local parts or punycode endings like .xn--p1ai. A few malformed ones pass, such as those with two dots in a row. Review the invalid list before deleting anything.
Does it check that the mailbox exists?
No. Nothing is sent and no domain lookups are made. The check runs in your browser against the text only. Use a verification service if you need deliverability checks.
Related Tools
Filter CSV Files Online
Filter rows in CSV files by column value, directly in your browser. Your data stays on your device.
Deduplicate CSV Files Online
Remove duplicate rows from CSV files instantly in your browser. No upload, no server — 100% private.
Find & Replace in CSV Files Online
Find and replace text values in CSV files directly in your browser. Supports plain text and regex patterns across any column — no upload required.
Validate Email Addresses in CSV Files Online
Validate email addresses in CSV files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Validate Email Addresses in Excel Files Online
Validate email addresses in Excel files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Validate Email Addresses in Parquet Files Online
Validate email addresses in Parquet files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Validate Email Addresses in JSON Files Online
Validate email addresses in JSON files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
TSV Viewer Online
View and inspect TSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.