Type =VAT(A2) and get the VIES verdict, the registered company name and address — for a whole column of customers or suppliers at once. Official European Commission data.
100 free checks. No credit card required.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | VAT number | Valid | Name | Address | Checked |
| 2 | BE0403170701 | =VAT(A2;"valid;name;address;checked") | |||
| 3 | BE0403170701 | Valid | SA ELECTRABEL | Boulevard Simon Bolivar 36, 1000 Bruxelles | 2026-10-21 |
| 4 | FR00000000000 | Invalid | 2026-10-21 |
The official VIES answer, the one tax authorities expect you to check before zero-rating an intra-EU invoice.
Where the member state publishes them — handy to spot a number that belongs to someone else.
=VAT(A2:A500) checks 500 numbers with one formula. Results are cached for 6 hours.
=VAT(A2;"valid") for a single yes/no column, or any mix of valid, name, address, country, number, checked.
When VIES France is saturated (it happens daily), French numbers are verified against the INSEE register instead.
=TVA(A2) works the same, with French field names (valide, nom, adresse…).
Check every new B2B customer before issuing a reverse-charge invoice.
Audit supplier master data in bulk: hundreds of numbers, one afternoon, one formula.
Verify VAT IDs collected at checkout before you refund the VAT.
Included when you install
From VIES, the European Commission's VAT Information Exchange System, queried live. For French numbers, the INSEE Sirene register is used as a fallback when VIES France is unavailable.
No. The add-on reads only the VAT number in the cell you pass to the formula, sends it to VIES, and writes the answer back. Nothing else is read or stored. See the privacy policy.
All 27 EU member states plus Northern Ireland (XI). UK numbers (GB) are not supported yet.
Some member states (Germany, Spain for individuals…) do not publish the registered name through VIES. The validity check still works.
The result shows the date of the check. For a VIES consultation number, use the official VIES website; this add-on is a bulk-checking convenience, not a legal archive.
From the link in your subscription e-mail, in one click. No commitment.