The Scenario
The localization decision has been sitting in a Notion doc for three weeks. The product manager needs one thing before moving forward: actual data on where the visitors are coming from. Not a Plausible dashboard screenshot from February — real numbers, current, in an Excel workbook where they can be sorted and compared.
You have 90 days of traffic sitting in Plausible. You need it broken down by country, with visitor counts and share of total, in a workbook the localization team can filter and annotate.
The bad version:
- Open Plausible, navigate to the Countries breakdown, find it only shows the top 10 by default, and discover that the export doesn't include the percentage share column — only raw visitor counts.
- Open the CSV in Excel, calculate the SUM of visitors manually, write a percentage formula next to each country, realize you also need bounce rate — and so you go back to Plausible, adjust the view, and export again.
- Combine two CSV files in the same workbook using VLOOKUP, notice the country names are formatted differently across the two exports (United States vs. US), and spend 30 minutes fixing mismatches.
The localization team is waiting. The product manager is sending follow-up pings.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It queries Plausible's country breakdown and writes the results directly into your worksheet — including calculated fields you ask for in the same prompt.
Open the localization workbook and run this prompt:
Pull a geographic breakdown from Plausible for the last quarter and write each country (A), unique visitors (B), and bounce rate (C) into this Excel sheet — include all countries, not just the top 10
What You Get
- Column A: country name in full (e.g., United States, Germany, Brazil)
- Column B: unique visitor count for that country over the period
- Column C: bounce rate for visitors from that country
- All countries returned by Plausible — not capped at 10 or 20
- Sorted descending by visitor count
What If the Data Is Not Quite Ready
You also need percentage of total visitors per country
Query Plausible for a country breakdown for the past 90 days — write country (A), visitors (B), bounce rate (C) — then in column D calculate each country's share of total visitors as a percentage
You want to flag priority markets above 5% traffic share
Query Plausible for all countries by visitor count for the last 90 days — write country (A), visitors (B) — calculate share of total in column C — then in column D flag any country where share exceeds 5% with the label Priority market
You need to compare this quarter's geographic split to last quarter's
Query Plausible for country visitor counts for the past 90 days — write country (A) and visitors (B) — then in column C VLOOKUP against the Q1 Geography worksheet to pull last quarter's visitor count for the same country, and in column D calculate the percentage change
Pull all countries, calculate share, flag priority markets, and write a localization recommendation in one shot
Query Plausible for a full country breakdown for the last 90 days — write country (A), visitors (B) — calculate share of total in column C — flag countries above 5% in column D as Priority — then in cell F1 write a one-line summary listing the top 3 countries by visitor share and suggesting which language to localize first
One prompt, all the data the localization team needs to stop debating and make the call.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook where you track your audience or localization planning — then ask it to pull your Plausible country breakdown for the last quarter. For related reads, see the hub overview or the spoke on cross-site traffic overview.