The Scenario
Procurement sent you 120 vendor domain names in an Excel workbook and asked you to run a basic security check before the onboarding meeting Thursday. The specific ask: flag any domain registered less than a year ago, any using privacy-shielded registrant details, and any with a registrar you don't recognize. The data needs to be in the workbook, not in a browser history of WHOIS lookups you've been clicking through since Tuesday morning.
The bad version:
- Open a WHOIS lookup site, paste each domain one at a time, copy the registrant name, registrar, registration date, and expiry date into the workbook manually.
- Realize around domain thirty that the date format is inconsistent — some sites return "2023-04-15", others return "15 April 2023" — and you need to normalize all of them to compare registration ages.
- Get to domain sixty, hit a WHOIS lookup that's rate-limited, wait, continue, and realize the workbook now has a gap at row 61 because you lost track while waiting.
120 domains at manual WHOIS pace is a half-day of mechanical clicking. That's not what procurement hired you to do before Thursday's meeting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your domain list and through its built-in IP2Location integration calls the WHOIS lookup endpoint for every domain in sequence, writes the structured results back into the workbook, and flags the newly registered ones — no rate-limit babysitting required.
For each domain in column A, fetch the WHOIS data from IP2Location and write registrant name, registrar, registration date, and expiry date to columns B, C, D, and E. Then flag any domain whose registration date in column D is less than 12 months ago by writing FLAG in column F and highlighting the row yellow.
What You Get
- Column B: registrant name or "privacy protected" if shielded
- Column C: registrar name
- Column D: registration date in a consistent format
- Column E: expiry date
- Column F: FLAG written for any domain registered within the last 12 months
- Rows highlighted yellow for newly registered domains so the pattern jumps out in the grid
What If the Data Is Not Quite Ready
Some rows have full URLs instead of bare domain names
Before running WHOIS lookups, strip any URL prefixes (https://, http://, www.) from column A so each cell contains only the bare domain, then run IP2Location WHOIS for each and write registrant name, registrar, registration date, and expiry date to columns B through E.
I want to flag privacy-shielded registrants separately from new registrations
Run IP2Location WHOIS for each domain in column A, write registrant name, registrar, registration date, and expiry to columns B through E. Write PRIVACY-SHIELD in column F if registrant name contains "privacy" or "redacted", NEW-REG if the registration date is less than 12 months ago, and BOTH if both conditions are true.
I need to cross-reference against a list of known-good registrars
After fetching WHOIS data for all domains in column A and writing registrar names to column C, compare each registrar against the approved registrar list in the "Approved Registrars" worksheet column A — write APPROVED or UNKNOWN in column G.
Full kill chain — clean, enrich, flag, cross-reference, and summarize
Strip URL prefixes from column A, run IP2Location WHOIS for each domain, write registrant name, registrar, registration date, and expiry to columns B through E. Flag PRIVACY-SHIELD, NEW-REG, or BOTH in column F. Check each registrar against "Approved Registrars" and write APPROVED or UNKNOWN in column G. Add a summary below the data showing counts of each flag type.
One instruction handles the normalization, the WHOIS enrichment, all three flag types, the registrar cross-reference, and the summary table.
Try It
Get the 7-day free trial of SheetXAI and open any vendor or competitor domain list in an Excel workbook, then ask it to bulk-run IP2Location WHOIS lookups and flag the newly registered or privacy-shielded entries before your next review. You can also explore reverse IP hosted-domain lookup or return to the IP2Location overview for the full integration guide.