No code › Check EU VAT numbers
Check EU VAT numbers in Excel and Google Sheets
Official EU VIES answer with company name and address, for invoices without VAT (reverse charge). Put the list in a spreadsheet, Radar fills in the answers. 500 checks a month free.
What you get for each VAT number
validstatusnameaddresscountryerrorExample: IE6388047V
Check a whole list now: upload Excel or CSV
Google Sheets
Once: Extensions → Apps Script → paste this script, put your key in line 9, Save. Then:
No script at all: =IMPORTDATA("https://radarbg.com/v1/cell/eu-vat-number-validation?format=csv&key=YOUR_KEY&value="&ENCODEURL(A2)) gives the whole answer row.
Excel (Windows) and LibreOffice
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:
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 check EU VAT numbers in Google Sheets?
Paste our script once (Extensions → Apps Script), put your free key in it, then type =RADAR("eu-vat-number-validation", A2) next to your list and drag it down.
How do I check EU VAT numbers in Excel?
In Excel for Windows use =WEBSERVICE("https://radarbg.com/v1/cell/eu-vat-number-validation?field=valid&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.