SmartQueryTools

Validate Email Addresses in YAML Files Online

Validate email addresses in YAML 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 YAML files

  1. Drop your file onto the upload area. It is loaded into the in-browser engine and the first 200 rows are shown.
  2. Choose the email column. The tool preselects the first column whose name contains "email" or "mail", otherwise the first column.
  3. 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.
  4. Click Validate Emails. The counts of valid and invalid addresses and the percentage invalid appear next to the result.
  5. 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 (YAML)

- attendee: Priya Nair
  email: priya.nair@uni.edu
  ticket: student
- attendee: Jonas Weber
  email: jonas.weber@firma
  ticket: standard
- attendee: Sam O'Neill
  email: sam.o'neill@mail.ie
  ticket: standard
- attendee: Lucía Gómez
  email: lucia.gomez@correo.es
  ticket: speaker
- attendee: Wei Chen
  email: null
  ticket: student
- attendee: Tom Hart
  email: TOM.HART@Example.CO.UK
  ticket: standard

Settings

  • Email column: email
  • Action: Flag all rows

Result

attendeeemailticketemail_valid
Priya Nairpriya.nair@uni.edustudenttrue
Jonas Weberjonas.weber@firmastandardfalse
Sam O'Neillsam.o'neill@mail.iestandardfalse
Lucía Gómezlucia.gomez@correo.esspeakertrue
Wei ChenNULLstudentNULL
Tom HartTOM.HART@Example.CO.UKstandardtrue

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.

YAML Viewer Online

View and inspect YAML files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.