The Scenario
Someone forwarded you a Mixpanel export at the start of the week: 600 IP addresses from your pricing page, 30 days of traffic. The attached note: "Which of these are companies we should be calling?" You work in RevOps. The AEs are asking if the list is ready.
You know IPinfo can turn an IP into a company name and domain. You do not know how to script it across 600 rows, and even if you did, writing the script isn't what this afternoon was supposed to be for.
The bad version:
- Open the export in Excel, find column A has 600 raw IPs.
- Search for IPinfo's company lookup API docs, realize it requires the paid plan, confirm you have access, get the token.
- Write a VBA macro or Python script, call the endpoint for each IP, parse company name, domain, and type from JSON.
- Filter to type "business," deduplicate by domain, copy the clean list to a new worksheet for the AEs.
Three hours later you have a list the AE team could have used three hours ago.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls the IPinfo company endpoint for each IP in your list, writes the results to columns, and applies the business-type filter inline.
Open the SheetXAI sidebar with the pricing-page IP workbook open and paste:
For each IP in column A, use IPinfo to retrieve company name, domain, and type and write them to columns B, C, and D — then filter to show only rows where type is "business."
What You Get
- Column B: company name (e.g., "Salesforce, Inc." or "Comcast Business")
- Column C: company domain (e.g., "salesforce.com")
- Column D: organization type — "business", "isp", "hosting", or "education"
- Non-business rows hidden or removed depending on your prompt phrasing
- Rows with no company data return blank cells in B-D, not errors
What If the Data Is Not Quite Ready
Multiple pricing-page visits from the same company inflate the list
Look up company name, domain, and type for all IPs in column A using IPinfo. Write to columns B, C, D. Deduplicate by company domain, filter to type "business," and write the unique enterprise visitor list to a new worksheet called "Account Targets," sorted alphabetically by company name.
I need to check the list against existing CRM accounts before passing to AEs
Look up company name and domain for all IPs in column A using IPinfo, write to columns B and C. Use VLOOKUP to check each domain against the CRM accounts list in Sheet2 column A (domain) and column B (account status), and write the account status to column D. Mark rows where no match is found as "New Prospect."
I want ISP vs. business vs. hosting separated for the RevOps report
For each IP in column A, fetch company name, domain, and type from IPinfo. Write to columns B, C, D. In column E, write "Target" if type is "business" or "education," "ISP" if "isp," and "Hosting" if "hosting." Write a summary count of each category below the data.
Full RevOps pipeline from raw IPs to prioritized outreach list
Column A has 600 pricing-page visitor IPs. Look up company name, domain, and type via IPinfo. Write to columns B, C, D. Filter to type "business," deduplicate by domain, check each domain against the CRM in Sheet2, mark new vs. existing, and write the new-prospect list to a worksheet called "Outreach Queue" sorted by company name.
Raw IP list to AE-ready outreach queue in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of visitor or prospect IPs, then ask it to identify the companies behind them with IPinfo and filter to your target account types. See also privacy screening for sign-up lists or batch geolocation enrichment. Hub: IPinfo + Excel.