The Scenario
It's the second week of the quarter and the finance team needs the EU VAT rate table updated before the quarterly tax report goes to the accountant. You've got a workbook with 18 country codes in column A. The standard, reduced, and super-reduced rates for each country live in Abstract's VAT API. They need to be in columns B, C, and D by end of day.
Last quarter, someone looked them up manually from the EU tax authority website and pasted them in. Three of the rates were wrong. The accountant caught it during review, which added two days to the close.
The bad version:
- You visit the EU VAT rates page, find Ireland, type 23 into column B, scroll back up, find the reduced rate, type 13.5, move to the next country
- You get through seven countries before realizing the website shows rates as of last year and you're not sure if any have changed
- You finish the table, send it to the accountant, and get a reply the next morning flagging Portugal's super-reduced rate as outdated
The accountant's job is to file the report. Your job is not to be a VAT rate lookup service.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the country codes, calls Abstract's VAT rate API for each one, and writes the rates back into the workbook — pulling live data, not rates you looked up six months ago.
Here's the prompt:
For each country code in column A, fetch the standard and reduced VAT rates from Abstract API and fill columns B and C
What You Get
- Column B: the standard VAT rate for each country code in column A
- Column C: the reduced VAT rate where one applies
- Any country codes Abstract doesn't recognize are flagged in column D with a note so you can investigate rather than silently getting a blank cell
What If the Data Is Not Quite Ready
You need super-reduced rates too, not just standard and reduced
For each country code in column A, fetch standard_rate, reduced_rate, and super_reduced_rate from Abstract's VAT API and fill columns B, C, and D
Some rows have full country names instead of ISO codes
Convert the country names in column A to ISO 3166-1 alpha-2 codes, then fetch standard and reduced VAT rates for each from Abstract API and fill columns B and C
The country list is spread across two worksheets — EU countries in one, non-EU in another
Fetch standard and reduced VAT rates from Abstract API for every country code in column A of the EU Countries worksheet and column A of the Non-EU worksheet, and write the results to columns B and C of each worksheet
The full quarterly prep in one instruction
For each country code in column A of my Tax Rates worksheet, fetch standard_rate, reduced_rate, and super_reduced_rate from Abstract API, fill columns B through D, flag any country where the standard rate changed since last quarter based on column E's prior values, and add a note in column F explaining the change
The flag-on-change logic and the API fetch happen together — you get a workbook that's current and auditable in a single pass.
Try It
Open your quarterly tax rate workbook and Get the 7-day free trial of SheetXAI — ask it to fill the VAT rate columns from Abstract API before the report goes out. Also useful: how to validate IBANs before a payment run and the Abstract API hub overview.