The Scenario
A web analyst has been handed a task right before the Q2 planning session: take the server log export — 1,000 visitor IP addresses in an Excel workbook — and add city and country columns so the product team can see where users are coming from. The geographic breakdown is an input to a localization budget discussion happening later this week.
The bad version:
- Find an IP geocoding website that accepts batch input. Paste the first 100 IPs, download the result, align columns with the original workbook, paste into a new sheet. Repeat nine more times.
- The batch tool uses different column names each time. Spend 20 minutes standardizing the output before each paste.
- Three batches in, the website starts returning 429 rate-limit errors. Wait five minutes, try again. The enrichment takes most of the day.
The planning session is in two days. The visualization hasn't been started.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the IP column, calls Radar's IP geocoding API for each row, and writes city, region, and country code back into the workbook — no batch limits to work around, no column renaming.
Geocode all 1,000 IP addresses in column A using Radar and write city, state/region, and country code to columns B, C, and D of this Excel workbook
What You Get
- Column B: city for each IP address
- Column C: state or region
- Column D: ISO country code (e.g., "US", "DE", "BR")
- Rows where Radar returned no geographic data get "Unknown" in column B — flagging private or unrecognized IP ranges without breaking the workbook layout
What If the Data Is Not Quite Ready
Some IPs have port numbers appended or extra whitespace
For each IP in column A: strip any port number and trim whitespace, then call Radar's IP geocode API and write city, state, and country code to columns B, C, and D — mark rows with empty or invalid IPs as Invalid in column B
You need full country names rather than codes for the presentation
For each IP in column A, call Radar's IP geocode API and write city to column B, region to column C, and full country name to column D
Many IPs appear multiple times — geocode each unique IP only once
Identify all unique IP addresses in column A, geocode each via Radar, then write city, region, and country code back to every row sharing that IP — mark unresolved IPs as Unknown in column B
Validate IPs, geocode, and build a country frequency summary for the planning session in one pass
For all 1,000 rows in column A: strip formatting issues, call Radar's IP geocode API, write city and country code to columns B and C — then add a frequency table starting at row 1005 listing each country code, how many IPs came from it, and the percentage of total
The frequency table is the planning-session input the team actually needs — no pivot required.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of visitor IP addresses — ask it to geocode each via Radar and write city, region, and country into the workbook. For geocoding street addresses instead, see bulk forward geocoding, or return to the Radar integration overview.