The Scenario
Your company is migrating to tax-inclusive pricing across all markets. Before you can update the pricing model, you need to know the correct VAT or sales tax rate for every customer. Your billing manager has 300 customer rows in an Excel workbook — column A is ISO country code, column B is postal code or region — and the new prices have to be set before the quarter rolls over.
The bad version:
- Open Quaderno's tax calculator, enter the first country code and region, note the rate percentage and the tax name, switch back to the workbook, paste both values into columns C and D
- Realize Quaderno's UI shows the rate as a decimal but your formula expects a percentage, so you have to convert each one as you go
- Hit row 60 and discover that three rows have country codes that don't match any Quaderno jurisdiction, which you only catch because the result field stays blank
You're supposed to be driving the pricing migration, not manually routing tax lookups through a compliance tool. The deadline for the new prices is not flexible.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the data and talks to Quaderno's tax calculation endpoint for you.
Calculate Quaderno tax rates for all 300 address rows — column A is ISO country code, column B is postal code — put the applicable tax rate and jurisdiction into columns C and D of this sheet
What You Get
- Quaderno's tax rate for each country/region combination resolves and lands in columns C and D
- The rate is written as a percentage so your existing formulas work without conversion
- Rows where the jurisdiction combination returns no result get flagged in column E so you can follow up
- The entire 300-row column resolves in one operation without any UI interaction on your part
What If the Data Is Not Quite Ready
Some rows have only a country code — no region or postal code
For rows in the Tax Rates worksheet where column B is blank, look up the standard Quaderno tax rate for the country in column A only and write the rate to column C, note No Region in column D
The country codes are spelled out as full country names, not ISO codes
In the Tax Rates worksheet, the values in column A are full country names. Convert each to an ISO country code, then look up the Quaderno tax rate for that country and region in column B, write the ISO code to column A, rate to column C, tax name to column D
I need the breakdown by tax type — VAT versus sales tax — not just the rate
For each row in the Tax Rates worksheet, look up the applicable Quaderno tax rate for country in A and region in B, write the rate to column C, the tax type (VAT, GST, Sales Tax, etc.) to column D, and the jurisdiction name to column E
Resolve all rates, flag any anomalies, and add a pricing column in one shot
For each row in Tax Rates: look up the Quaderno tax rate for country in A and region in B, write the rate to C and tax name to D; if the rate is above 25%, write High Rate to column E; then calculate the tax-inclusive price by multiplying column F (base price) by (1 + C/100) and write the result to column G
Combining the lookup, the flag, and the derived calculation in one prompt means you get a ready-to-use pricing column without an intermediate cleanup step.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your customer addresses or market data live, then ask it to resolve the tax rates for all rows using Quaderno. Also see: bulk-validating customer tax IDs from an Excel workbook, and the hub overview of all Quaderno connection methods.