RadarPricesOrder
No code needed

Check whole lists in Excel and Google Sheets

IBANs, VAT numbers, e-mails, HS codes, addresses, domains: put your list in a spreadsheet and Radar fills in the answers. Same key as our API, 500 checks a month free.

Upload a fileExcel or CSV in, the same file with answer columns out. Up to 5,000 rows, no install. Google Sheets formula=RADAR("iban-validator", A2) in any cell. Copy one script once, 2 minutes. Excel formula=WEBSERVICE(...) in Excel for Windows and LibreOffice. Nothing to install. n8n, Make, ZapierRun checks by themselves: new row, new customer, every morning.

What can I check?

Check IBAN numbersIs the IBAN valid, which bank and BIC is it? Before you pay suppliers or set up SEPA debits.Check EU VAT numbersOfficial EU VIES answer with company name and address, for invoices without VAT (reverse charge).Check business partners by VAT numberCompany name, address and a simple risk level for a new customer or supplier.Clean e-mail listsFind typos, dead domains and throw-away addresses before you send a newsletter.Find HS / customs codes for productsThe customs tariff code for each product in your list (EU or UK tariff), for invoices and shipping.Screen names against sanctions listsOFAC, EU, UK and UN lists in one check. 'clear' or 'match' for every customer.Turn addresses into map coordinatesOfficial address registers: clean address, postcode and latitude / longitude.Check domain owners and expiry datesRegistrar, age and expiry date of every domain, so none of yours runs out.See what technology websites useShop system, CMS, e-mail provider and tools of every website in a lead list.Check SPF, DKIM and DMARC of domainsWill e-mails from this domain land in spam? Grade A-F with the missing records.Check SSL certificates and security headersSecurity grade and certificate end date for every site you look after.Check where links redirectFinal address and status of every old link, for website moves and SEO.Get page titles and descriptions from linksTitle, description and preview image of every link in a list.Decode VINs and check recallsMake, model, year and open US recalls for every vehicle in a fleet list.Flight distance between airportsKilometres, miles and flight time for travel expense or CO2 sheets.Get short Wikipedia summariesOne-line description and summary for every name in a list.

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 in 2 minutes

1Get a keyFree, below. 500 checks a month.
2Paste the scriptExtensions → Apps Script → paste this script → put your key in line 9 → Save.
3Use the formulaType it in a cell next to your list and drag it down.
=RADAR("iban-validator", A2) =RADAR("iban-validator", A2, "bankName") =RADAR_ROW("eu-vat-number-validation", A2) =RADAR("hs-code-tariff-lookup", A2:A40)

The first time, Google asks you to allow the script to “connect to an external service”: that is the call to radarbg.com. Only your key and the cell value are sent.

Excel (Windows) and LibreOffice

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

Anyone who gets the file can see the key inside the formula. Use it in your own files, or make a second free key for shared files. Excel for Mac has no WEBSERVICE: upload the file above instead.

n8n, Make and Zapier

Every check is one web request: POST https://radarbg.com/v1/<api> with the header X-API-Key. Ready n8n workflow for each check on its page (Import from file). In Make use the HTTP → Make a request module, in Zapier Webhooks by Zapier → POST, with the same URL, header and JSON body. Want it set up for you? We build it from €39.

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

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.