The Scenario
You manage growth analytics. The board meeting is Monday at 9 AM. The CFO sent a message Friday afternoon: "Slide 12 needs a map of where our trial signups are coming from. Something visual." You have 10,000 trial user IPs in an Excel workbook.
IPinfo has a map tool that takes a list of IPs and returns a URL for an interactive geographic visualization. The URL is shareable — you can paste it directly into the board deck or embed it as a link.
Getting from your Excel column to that URL is the gap.
The bad version:
- Export column A to a plain text file, one IP per line.
- Upload the file to IPinfo's map interface.
- Wait for the map to generate, copy the link.
- Paste it back into the workbook and also into the slide.
That's not terrible, but the export-upload-copy-paste chain for 10,000 rows involves more steps than it should, and doing it right before a board meeting is the wrong time to discover the upload interface expects a different line ending format than your export produced.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the IP column, sends the list to IPinfo's map tool, and writes the generated URL back to a cell — no export, no format conversion.
Open the SheetXAI sidebar and paste:
Take all IP addresses in column A and send them to IPinfo's map tool, then write the generated map URL to cell C1 so I can share it.
What You Get
- Cell C1: the shareable IPinfo map URL — a live interactive map with all 10,000 trial IPs plotted
- Ready to paste into a slide, share in a chat, or drop into a doc
- No intermediate file, no upload dialog, no format negotiation
What If the Data Is Not Quite Ready
The list has duplicates and I want unique IPs on the map
Deduplicate column A, then send the unique IP addresses to IPinfo's map tool and write the generated map URL to cell C1.
I have IPs across two worksheets and want one map covering both
Collect all IP addresses from column A on Sheet1 and column A on Sheet2, combine into a single deduplicated list, send to IPinfo's map tool, and write the resulting map URL to cell A1 on a new worksheet called "Map Links."
I need separate maps for trial vs. paid users
Column B contains the user segment label for each IP in column A (values: "Trial," "Paid," "Churned"). Create a separate IPinfo map for each segment using only the IPs where column B matches. Write the three map URLs to a new worksheet called "Segment Maps" with segment name in column A and URL in column B.
Full board-deck prep: clean, map, and pull the supporting numbers
Column A has 10,000 trial sign-up IPs. Deduplicate, remove any IPs from internal ranges listed in the "Exclusions" worksheet column A, send the cleaned list to IPinfo's map tool, write the map URL to cell B1, the total unique IP count to cell B2, and the country count to cell B3.
Map URL, unique count, and country count in one prompt — everything slide 12 needs.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with trial or user IP addresses, then ask it to generate a shareable IPinfo map link for your next presentation. See also geographic traffic distribution with pivot tables or batch geolocation enrichment. Hub: IPinfo + Excel.