The Scenario
You're running CS ops for a SaaS company. Six months ago someone set up automated check-in emails — Monday, 9 AM local time for each client. The sending system needs an IANA timezone per client record to route the send time correctly.
The records were migrated from the old CRM without timezone fields. You have 1,500 client IP addresses in an Excel workbook. The weekly send batch runs Sunday night. It's Thursday and the CS lead just noticed a dozen clients in Asia have been getting the email at 9 AM Eastern — which is 10 PM for them.
The bad version:
- Export the 1,500 IPs to a CSV.
- Call the IPinfo single-IP endpoint in a Python script, extract the timezone field, write to a second CSV.
- Import back into Excel, join on IP address, fill the timezone column.
- Handle the null cases — three clients have IPs that returned no timezone — decide on a fallback.
The ops task is straightforward. The tooling chain around it is what turns a 15-minute job into a Thursday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your client IP column and calls IPinfo to fetch the IANA timezone for every row in one pass.
Paste this into the SheetXAI sidebar:
For each IP in column A, use IPinfo to look up the IANA timezone and write it to column B.
What You Get
- Column B: IANA timezone string for each client IP (e.g., "America/New_York", "Europe/Berlin", "Asia/Singapore")
- Rows where IPinfo returns no timezone get an empty cell — not an error — so you can identify which clients need a manual fallback
- All 1,500 rows completed in one operation, no re-import step
What If the Data Is Not Quite Ready
I need a count of clients per timezone region for the CS ops report
Fetch the IANA timezone for every IP in column A using IPinfo and write to column B. Write a summary table below the data counting clients per timezone, sorted by count descending.
Some clients have no IP on record and need a fallback timezone
Look up IANA timezones for all IPs in column A using IPinfo and write to column B. For any row where column A is blank or IPinfo returns no data, write the default timezone "America/New_York" to column B instead.
The sending system needs UTC offset, not IANA name
Look up IANA timezones for all IPs in column A via IPinfo and write to column B. Then convert each IANA timezone to a UTC offset (e.g., "America/New_York" to "UTC-5" in winter or "UTC-4" in summer based on current date) and write the UTC offset to column C.
Full ops pipeline: enrich, apply fallback, validate, and flag unresolved rows
Column A has 1,500 client IPs. Some cells are blank. Fetch the IANA timezone for each non-blank IP using IPinfo and write to column B. For blank IPs, write "America/New_York" as the fallback. Flag any row where IPinfo returned no data despite a valid IP in column C as "Manual Review." Write a summary count of timezones by region (Americas, Europe, Asia-Pacific, Other) below the data.
Sunday batch runs clean.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with client or user IP addresses, then ask it to pull IANA timezone data from IPinfo and prepare the column for your sending system. See also carrier identification for mobile targeting or postal code lookup for regional analysis. Hub: IPinfo + Excel.