The Scenario
Your mobile growth team is planning the next carrier-specific ad push and the media buyer needs carrier breakdown data for 5,000 app user IPs before the Thursday targeting call. The IPs are in an Excel workbook. The ask came in Tuesday afternoon.
You've been handed this kind of task before. Last time it went to an engineer who built a one-off script. That engineer is now on a different project and the script isn't documented anywhere you can find.
The bad version:
- Reconstruct the script from memory: Python, requests library, IPinfo carrier endpoint, loop 5,000 rows, extract carrier name, MCC, MNC from the JSON.
- Run it, realize the output flattens all nulls to empty strings, which is fine until you try to filter for mobile-only rows.
- Import the CSV back into Excel, build the count-per-carrier summary with a pivot table, format it for the media buyer.
The targeting call is Thursday. This is the kind of rebuilding exercise that shouldn't consume your Tuesday evening.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. Through its IPinfo integration, it resolves carrier data for your full IP list and builds the summary table in one pass.
Paste this into the SheetXAI sidebar:
Look up carrier info for all IPs in column A using IPinfo and write carrier name, MCC, and MNC to columns B, C, and D, then add a count-per-carrier summary table below the data.
What You Get
- Column B: carrier name (T-Mobile, Verizon, AT&T, Vodafone, etc.) or blank for non-mobile IPs
- Column C: MCC — blank for non-mobile
- Column D: MNC — blank for non-mobile
- A summary table below the data: carrier name and IP count, sorted high to low
- Non-mobile IPs (WiFi, desktop) written with empty carrier fields, not errors
What If the Data Is Not Quite Ready
I need to separate mobile from non-mobile before summarizing
Look up carrier info for all IPs in column A using IPinfo. Write carrier name, MCC, and MNC to columns B, C, and D. Add column E with "Mobile" if MCC is present and "Non-Mobile" if not. Write two summary tables below the data: one with mobile IP count per carrier, one with the total non-mobile count.
WiFi and corporate IPs should be excluded from the carrier targeting analysis
Enrich all IPs in column A with IPinfo carrier data. Write carrier name to column B and MCC to column C. Filter out any row where MCC is blank and write only mobile rows to a new worksheet called "Mobile Carriers," then add a carrier count summary at the bottom.
The media brief needs carrier-to-ad-network mapping
Look up carrier info for all IPs in column A with IPinfo, write carrier name to column B, then use VLOOKUP to match carrier name against the mapping table in Sheet2 column A (carrier name) and column B (ad network group) and write the ad network group to column C.
Full targeting brief pipeline
Column A has 5,000 app user IPs. Look up carrier name, MCC, and MNC with IPinfo and write to columns B, C, D. Flag column E as "Mobile" or "Non-Mobile." Write a count-per-carrier summary for mobile IPs to a new worksheet called "Carrier Targeting Brief," sorted by count descending, with percentage of total mobile IPs per carrier.
Targeting brief ready before Thursday's call.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of mobile app user IPs, then ask it to pull carrier data from IPinfo and build the summary your media buyer needs. See also geographic traffic distribution or VPN and proxy screening. Hub: IPinfo + Excel.