Verify your Google Sheets export before you send

1. Export the CSV from Google Sheets

1. Open the spreadsheet in Google Sheets, on the tab that holds the email addresses.
2. Click File > Download.
3. Choose Comma Separated Values (.csv).

The CSV download holds the tab you have open, so switch to the right tab first.

Source: Google Sheets help centre.

2. Upload it to SimpleVerifier

Sign in, upload the CSV as it came out of Google Sheets and every address gets a live mailbox check with catch-all detection. The email column is found automatically.

3. Import the clean file back

You get three files: valid, risky and invalid, each with every column from the original export. Import the valid file back into Google Sheets or your sending tool, and keep risky addresses (usually catch-all domains) out of cold sends.

Common questions

How do I export my sheet from Google Sheets?

Open the spreadsheet in Google Sheets, on the tab that holds the email addresses. Click File > Download. Choose Comma Separated Values (.csv). The CSV download holds the tab you have open, so switch to the right tab first.

Do I need to change the Google Sheets CSV before uploading it?

No. The email column is found by its header or its contents, so the Google Sheets export works as it is. Every other column is kept, and the cleaned files come back with your original columns so you can import them straight back into Google Sheets.

Why verify a list that came from Google Sheets?

Subscribers who signed up years ago move jobs, abandon inboxes or typed their address wrong. Every send to a dead address in Google Sheets is a bounce on your sender reputation, and many ESPs bill by contact count, so removing dead addresses also lowers the bill.

How much does it cost?

Verification is $29.99 a month with no limit on verifications, for files up to 100,000 rows. See the pricing page for the plans.