Bulk VAT & Tax ID Validation for Google Sheets
Clean messy tax numbers, verify national checksum algorithms offline, and retrieve authoritative European Commission VIES registration records directly into your spreadsheet.
Test Any VAT or Tax ID Instantly
Experience the offline mathematical checksum engine right now in your browser. Powered by official Modulo 97, Modulo 11, Modulo 89, and Luhn algorithms across 30 jurisdictions with 0 latency.
Seamlessly Native Inside Google Sheets
No external portals, no CSV file uploads, and no server configuration. Clean adjacent columns are written row-by-row with official VIES proof.
| # | A: Raw Input VAT | B: BulkVAT Status | C: Registered Entity Name | D: VIES Consultation ID | E: Checked At |
|---|---|---|---|---|---|
| 1 | DE 811 122 432 |
VALID (VIES) | SIEMENS AKTIENGESELLSCHAFT | WAP183749281 |
2026-10-06 07:12:04 |
| 2 | fr 40300076965 |
VALID (VIES) | AIR LIQUIDE SA | WAP992817462 |
2026-10-06 07:12:05 |
| 3 | NL 800000000B01 |
INVALID (VIES) | — | WAP448192019 |
2026-10-06 07:12:06 |
| 4 | GB 999 9999 73 |
VALID (GB FORMAT ONLY) | [UK Format Verified] | — (Post-Brexit Non-VIES) | 2026-10-06 07:12:07 |
| 5 | ESB-12345678 |
INVALID CHECKSUM | — | — | 2026-10-06 07:12:07 |
| 6 | BE 0123.456.789 |
VALID (VIES) | SOLVAY SA | WAP771928341 |
2026-10-06 07:12:08 |
| 7 | 51 824 753 556 |
VALID (AU ABN FORMAT) | [ATO Mod 89 Verified] | — (ATO Non-VIES) | 2026-10-06 07:12:09 |
Built for Finance, Operations & Tax Teams
Designed to solve messy ERP exports, vendor onboarding spreadsheets, and cross-border invoicing compliance without tedious manual lookups.
Direct VIES Integration
Queries the official European Commission VIES REST API directly from your Google Apps Script environment. Retrieves registered company names, addresses, and official consultation identifiers.
Offline Checksum Engine
Filters syntax errors instantly using verified mathematical rules: Modulo 97 (UK/NL), Modulo 89 (LU/AU ABN), Modulo 11 (DE/FR/IT/ES/PL), and Luhn algorithms. Prevents unnecessary API calls.
Resumable Batching
Handles large spreadsheets of 5,000+ rows smoothly. Built-in 4.5-minute execution guards checkpoint progress and schedule automatic continuation triggers so you never hit Google timeout limits.
Zero External Servers
Your vendor lists and customer data never touch our servers because we operate none. All data stays inside your Google Sheet, communicating securely with official tax authority gateways.
Auditable Evidence Export
Generates clean adjacent columns and exports RFC 4180 CSV audit trails with timestamps, raw responses, and European consultation IDs to defend cross-border zero-rated VAT treatments.
Simple One-Time License
No recurring subscriptions or seat fees. A single $39 USD lifetime license unlocks unlimited rows forever. Free tier includes 50 rows per day with zero credit card required.
Engineered for Your Exact Workflow
Whether reconciling quarterly sales, onboarding global suppliers, or preparing statutory VAT returns.
Shopify, Stripe & Marketplace Sellers
Chartered Accountants & Bookkeepers
NetSuite, SAP & Business Central Migrations
How BulkVAT Works in 3 Steps
Operates entirely within your Google Sheets sidebar with clear, non-destructive column writing.
1. Select Your Column
Highlight the column containing raw VAT or tax ID numbers. BulkVAT automatically strips spaces, hyphens, and dots, standardizing lowercase letters and prefixes (e.g. EL/GR).
2. Run Verification
Click Start Batch Run. BulkVAT pre-validates syntax locally and queries live European Commission VIES servers, dynamically handling rate limits and national registry maintenance windows.
3. Export Audit Trail
Results are written into adjacent columns: Status, Legal Name, Address, Consultation Number, and Checked Timestamp. Download the full RFC 4180 CSV evidence log with one click.
Ready to Clean & Validate Your Tax Data?
Install the BulkVAT Google Sheets add-on today. Free 50 rows per day included automatically, or unlock lifetime unlimited processing for $39 USD.
Get BulkVAT for Google Sheets