RadarPricesOrder

No code › Clean e-mail lists

Excel · Google Sheets · file upload

Clean e-mail lists in Excel and Google Sheets

Find typos, dead domains and throw-away addresses before you send a newsletter. Put the list in a spreadsheet, Radar fills in the answers. 500 checks a month free.

What you get for each e-mail address

statusreasonsuggestiondisposablerolemx

Example: info@github.com

Check a whole list now: upload Excel or CSV

You get your own file back with Radar's answers in new columns. 1 answered row = 1 call, rows without an answer are free, the same value again within 24 h is free. Files are deleted after 72 hours. No key? Get one free.

Google Sheets

Once: Extensions → Apps Script → paste this script, put your key in line 9, Save. Then:

=RADAR("email-validator", A2) =RADAR("email-validator", A2, "reason") =RADAR_ROW("email-validator", A2) (all columns; =RADAR_HEADERS("email-validator") for the titles)

No script at all: =IMPORTDATA("https://radarbg.com/v1/cell/email-validator?format=csv&key=YOUR_KEY&value="&ENCODEURL(A2)) gives the whole answer row.

Excel (Windows) and LibreOffice

=WEBSERVICE("https://radarbg.com/v1/cell/email-validator?field=status&key=YOUR_KEY&value="&ENCODEURL(A2))

Change field= to any column above. The key is visible inside the formula: use a separate free key for files you share.

Automatic: n8n, Make, Zapier

Download the n8n workflow (n8n → Import from file → paste your key). Make: HTTP → Make a request; Zapier: Webhooks → POST:

POST https://radarbg.com/v1/email-validator X-API-Key: YOUR_KEY {"emails": ["info@github.com", "test@gmial.com"]}

Developers: full API page · docs. Rather not do it yourself? We do the list for you.

Get your free key

500 checks a month free, no card. The key arrives on the next screen. More: €9 a month for 5,000, €29 for 25,000 (all plans).

Questions

How do I clean e-mail lists in Google Sheets?

Paste our script once (Extensions → Apps Script), put your free key in it, then type =RADAR("email-validator", A2) next to your list and drag it down.

How do I clean e-mail lists in Excel?

In Excel for Windows use =WEBSERVICE("https://radarbg.com/v1/cell/email-validator?field=status&key=YOUR_KEY&value="&ENCODEURL(A2)). On a Mac, upload the file on this page instead.

Do I need to know programming?

No. Upload a file, or paste one formula in Excel or Google Sheets. The key is just a password-like code that counts your checks.

How much does it cost?

500 checks a month are free with no card. Then €9 a month for 5,000, €29 for 25,000 or €79 for 100,000. One key works for every check and for our API.

What counts as a check?

One value that got an answer, for example one IBAN. Values without an answer are free, and the same value again within 24 hours is free, so a sheet that recalculates does not use up your checks.

Is my data safe?

Only the value in the cell is sent, nothing else from your sheet. Uploaded files are deleted after 72 hours and never shared. We never ask for passwords.

Where do the answers come from?

From official and public sources: EU VIES for VAT, the Deutsche Bundesbank file for German banks, EU and UK customs tariffs, OFAC/EU/UK/UN sanctions lists, official address registers and the domains' own records.

Other checks

Check IBAN numbersCheck EU VAT numbersCheck business partners by VAT numberFind HS / customs codes for productsScreen names against sanctions listsTurn addresses into map coordinatesCheck domain owners and expiry datesSee what technology websites useCheck SPF, DKIM and DMARC of domainsCheck SSL certificates and security headersCheck where links redirectGet page titles and descriptions from linksDecode VINs and check recallsFlight distance between airportsGet short Wikipedia summaries