Validate EU VAT numbers directly inside Google Sheets™—effortlessly.

Connect your sheet to the EU VIES service and return a live TRUE/FALSE result on request.

Smart pre-cleaning: strips stray characters, flags bad formats.

🚀 How to Get Started

1. Install the add-on → open it from Extensions › VAT Checker.
2. Select the cells containing VAT numbers → click Select → Validate.
3. The add-on returns TRUE/FALSE in real time via the EU VIES database to the cells next to your VAT numbers.

✨ Why you’ll love it
1. Easy EU VAT number validation - select, validate, done.
2. Use in any existing sheets - e.g. monthly EC Sales List checks before finalising filings or for quick ad-hoc validations of customer data.
3. Built by finance pros - prompts to clean unsupported characters and flags bad formats before executing the VIES validation.

💸 Pricing
✅ Free Trial – 14 days, up to 2 500 validations (no credit card).
✅ Free Plan – 50 validations per month—perfect for occasional use.
🔓 Upgrade anytime in the sidebar—unlock the Full plan with up to 2 500 validations per month.

See the latest pricing at brokenref.com/#add-ons, or simply open the upgrade dialog in the add-on sidebar.

⭐ Found VAT Checker useful? Please take a moment to rate it on the Google Workspace Marketplace - it really helps us.

💬 Questions or suggestions? Let us know at brokenref.com/contact/form  -we read every message!

Google Sheets™ is a trademark of Google LLC. This add-on is not affiliated with the European Commission or the VIES service; it simply passes your validation requests to their API and returns result to your sheet.