FREE email validator for Google Sheets | Google script to validate emails

A FREE ’email validator’ Google Sheets template

Check for valid email address syntax using our simple and free to use Google Sheets template.

PLEASE NOTE – this is an email validator, as in ‘we check to see if the email syntax is valid‘. We do not check to see if the email is a real live email address, to do this, use a tool like Emailable.

1.

First up, paste in your email in the sign up form

2.

Now create a copy of the Google Sheet

Free email validator for google sheets | google email validation script
Free email validator for google sheets | google email validation script

3.

Now run the Google Apps Script

Pop out to full screen, so you get an uncluttered view of your email.

4.

Click on Triggers in the left side menu

Know exactly how wide and long your email is on desktop and mobile screens.

Free email validator for google sheets | google email validation script
Free email validator for google sheets | google email validation script

5.
Create a new Trigger, using the default settings

6.

Refresh the sheet, the paste in your emails

Free email validator for google sheets | google email validation script
Free email validator for google sheets | google email validation script

7.

Click on Validation, and then Check Validation

8.
Hey presto, you’ve successfully validated some emails!

Free email validator for google sheets | google email validation script

What we check for…

A valid email address has 3 parts: A local part, an @ symbol, and a domain name.

The local-part or username may be up to 64 characters long and contain:

  • Uppercase and lowercase Latin letters (A-Z, a-z)

  • Numeric values (from 0 to 9)

  • Special characters, such as # ! % $ ‘ & + * – / = ? ^ _`. { | } ~

  • A special character cannot appear as the first or last character in an email address or appear consecutively two or more times. The most commonly used special characters are the period (.), underscore(_), hyphen (-) and plus sign (+)

  • Alternative special characters such as  ” ( ) , : ; < > @ [ \ ] 

Domain names may be a maximum of 253 characters and consist of:

  • Uppercase and lowercase letters in English (A-Z, a-z)
  • Numeric values (from 0 to 9), on condition that domains can’t be all numeric
  • A period (.)  (used to identify a sub-domain; for example,  email.domainsample)
  • A hyphen (-), on condition that it is not placed at the beginning or end of the domain

Domain extensions available:

https://tld-list.com/tlds-from-a-z