Email verification extension allows to verify emails right from Google Sheets™ with the same accuracy as other popular standalone solutions. Get 100 verification credits for free. No monthly payments. Balance never expires. Save up to 85%

How do I verify an email address list in Google Sheets™?
Install the Email Verification extension by clicking "Install" or "Admin install."
Open a sheet containing emails that you want to verify. Click on the Email Verification icon on the right side of your screen.
Click on "Open template" to open a new template sheet.
Paste your emails into the first column.
Click the Verify Emails button and wait


PRICING

First 100 verification - free

1 000 - verifications - $9	 
5 000 - verifications - $39 (save 15%)
10 000 - verifications - $69 (save 25%)
25 000 - verifications - $149 (save 35%)
100 000 - verifications - $399 (save 55%)
500 000 - verifications - $1,099 (save 75%)
1 000 000 - verifications - $1,599 (save 85%)

Email deliverability status details:
• safe: safe to send emails
• invalid: not deliverable email
• risky: at least one of the following is true: disposable email address, a role account (e.g. support@ or admin@), catch-all address, has full inbox.
• unknown: email provider doesn't allow verification of emails. Please contact our support

——————————

You can perform a basic check for email syntax validity for free in Google Sheets using the ISEMAIL function.

It verifies if the address follows the standard email format, which typically includes an email username, the "@" symbol, a domain name, and a top-level domain (TLD). It also checks for common syntax errors, such as missing or extra characters, invalid characters, and proper domain structure.

Here's how to use ISEMAIL function:

1. Firstly open Google Sheets and either create a new spreadsheet or open an existing one. 

2. Then select the cell where you want to use the ISEMAIL function or enter the email address data you want to validate.

3. Next in the formula bar at the top type in this formula:
=ISEMAIL(cell_reference)

Make sure to replace "cell_reference" with a reference to the cell that contains the email address you want to validate. 

For example if your email address is in cell A1 then your formula would look like this: =ISEMAIL(A1). Press Enter once you've entered your formula and let it do its work. 

The ISEMAIL function will evaluate whether the email address is valid or not and return "TRUE" if it is or "FALSE" if it isn't.

——————————


FOR DEVELOPERS

To verify email addresses in JavaScript use this function:

function isValidEmail(email) {
  // Regular expression pattern for email validation
  var emailRegex = /^[^\s@]+@[^\s@]+\.[^\s@]+$/;
  
  return emailRegex.test(email);
}