The Scenario
The product team shipped a new onboarding flow six weeks ago. Now the VP of Product wants to know where the new users are actually coming from — not by country dropdown selection, but by actual IP geolocation — because the dropdown data is full of blanks and "US" selections from users in 40 different countries. You have 3,000 raw session IPs exported from the analytics platform sitting in an Excel workbook.
The ask landed in your inbox this morning with "need it for Friday's QBR" in the subject line. It's Wednesday.
The bad version:
- Import the CSV export into Excel, which takes four dialog boxes and a delimiter argument.
- Write a Python script to call the IPinfo batch endpoint in chunks of 1,000, parse country and city from the responses.
- Export enriched data to CSV, import back into Excel, reconcile the column ordering.
- Build a country pivot table by hand, realize the pivot needs city filtering for the top 5 countries, build that separately.
This is three hours of wrangling before you get to the 20 minutes of actual analysis the VP cares about.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your IP column, geocodes the list through IPinfo, and builds the summary table inline — no intermediate export, no script.
Open the SheetXAI sidebar and paste:
Geocode all 3,000 IPs in column A with IPinfo, group by country, and write the top 20 countries sorted by IP count descending to a new worksheet called "Traffic Summary."
What You Get
- Country code written to column B for every IP row as a side effect of the batch call
- A new "Traffic Summary" worksheet with country code and session count, sorted high to low
- Top 20 rows trimmed and ready to paste into a slide
- Unresolved IPs bucketed as "Unknown" in the summary
What If the Data Is Not Quite Ready
Sessions include duplicates because the export counted all events, not unique visitors
Column A has 3,000 IPs with many repeats. Deduplicate, geocode unique IPs with IPinfo, then weight the country summary by original row count so session volume (not unique IP count) drives the ranking. Write to a new worksheet called "Session Geography."
I also want a city breakdown for the top 5 countries
Geocode all IPs in column A with IPinfo, write country to column B and city to column C. On a new worksheet called "Breakdown," write a country count table sorted descending, then a city count table filtered to the top 5 countries only, also sorted descending.
QA and internal IPs should be excluded from the analysis
Column A has 3,000 session IPs. The "Exclusions" worksheet column C lists internal office and VPN ranges. Geocode all IPs in column A, skip any that appear in Exclusions column C, write country to column B, and build a top-20 country summary on a new worksheet called "Traffic Summary."
Full QBR pipeline: clean, geocode, and summarize in one pass
Column A has 3,000 raw session IPs, some duplicated, some from internal ranges listed in Exclusions worksheet column C. Deduplicate, remove internal IPs, geocode remaining with IPinfo, write country and city to columns B and C, produce a top-20 country count table and a top-10 city table for the top 5 countries — all on a new worksheet called "Feature Launch Summary."
One prompt from raw export to QBR-ready table.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a raw analytics IP export, then ask it to geocode and summarize the geographic distribution with IPinfo. See also full geolocation enrichment with city and ASN or generating a shareable map link. Hub: IPinfo + Excel.