Google Sheets

Clean it in the sheet.

Open the sidebar. It finds emails, phones, IPs, domains, names, dates, country codes, and user agents. One click writes the answers beside your data.

Contacts

Emailparse_deliverableparse_disposablePhoneparse_carrier
tom.f@gmail.comtruefalse(310) 285-8000AT&T
bobby.tables@xkcd.comfalsefalse(212) 736-5000Sinch Voice
press@10minutemail.comfalsetrue867-5309

{ parseAPI }

Found 2 columns to clean.

Blanks and junk are skipped.

Email

3 unique

Carrier

2 unique

Clean 5 values

Your plan. No extra fee.

HOW TO SET IT UP

1

Install

Install parseAPI from the Google Workspace Marketplace. Open any spreadsheet, then Extensions, parseAPI, Open. Google will ask to touch this sheet only, not every file you own.

Extensions
parseAPIOpen
Add-onsGet add-ons

2

Paste your key

Paste a secret key from parseapi.com. It stays in your Google account, never in a cell. Sharing the sheet does not share the key. The free plan works.

{ parseAPI }

Clean data where it lives.

Paste your API key. It stays in your Google settings, never in the sheet.

parse_...
Save key

3

Clean

It lists what it found. One button runs it. parse_ columns land to the right of the source. Those cells are values, so the sheet can recalculate without calling us again.

Emailparse_deliverableparse_disposablePhoneparse_carrier
tom.f@gmail.comtruefalse(310) 285-8000AT&T
bobby.tables@xkcd.comfalsefalse(212) 736-5000Sinch Voice
press@10minutemail.comfalsetrue867-5309

What it cleans

Email
deliverable, disposable, role, catchall, valid, domain, didyoumean
Phone
valid, type, state, country, national, international
CarrierOn by default on a phone column
carrier, type, burner, city
IP
country, state, city, network, datacenter, vpn
User agent
browser, os, device, bot
Domain
available, mailhost, registrar
CountryNeeds a Country header
name, continent, currency, calling_code
NameNeeds a Name header
first, last, gender, salutation
DateFree, local, month-first
ISO date, named for the source column

One column per kind. Every date column. Blanks and junk are skipped.

Your plan.

Email verify and carrier use the monthly units you already have. Phone, IP, domain, name, country, and user agent draw pooled requests. Dates are free.

QUESTIONS

Does it re-run when the sheet recalculates?
No. Results are written as values, not formulas. Recalculating never calls us and never bills again.
Can I paste a public key?
No. Use a secret key from the dashboard. Public keys need a browser Origin header, which Sheets does not send. The key lives in your Google account, never in a cell, so sharing the sheet does not leak it.
Does Google give it every spreadsheet I own?
No. The add-on only asks to touch the sheet you have open.
What does a run cost?
Your plan. Email verify and carrier use the monthly units you already have. Phone, IP, domain, name, and country draw pooled requests. Dates are free. Blanks, junk, and duplicates are skipped.
I have a huge file. Stay in Sheets?
A million rows belongs on /bulk. The add-on is for the sheet you are already in.

A million rows?

Drop the file on parseapi.com/bulk. Same engine, priced per column, emailed when it finishes.