The Scenario
Your company just closed an acquisition. IT handed you a workbook of 60 domains from the acquired entity — some active, some parked, nobody entirely sure which is which. The mail migration kickoff is Thursday and the infrastructure lead asked you to document the MX records and mail server priorities for every domain before the meeting.
It's Tuesday afternoon.
The bad version:
- Open MX Toolbox, type the first domain into MX Lookup, read the results — three mail server hostnames at different priorities, each with a different IP — then switch back to Excel and enter those values row by row.
- Work through the list domain by domain, stopping occasionally because a parked domain returns nothing and you're not sure whether to leave the row blank or flag it.
- Finish with a table that's inconsistently formatted because some domains had one MX record and others had five, and you ran out of columns.
The migration meeting is Thursday morning. If the documentation isn't ready by Wednesday afternoon, the infrastructure team is going into that call without a full picture of what they're inheriting.
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 MX Toolbox integration looks up MX records for every domain in one pass, writing the mail server hostnames and priorities directly into adjacent columns.
For every domain in column A of my Excel workbook, use MXToolbox to look up MX records and write the highest-priority mail server hostname and its IP address into columns B and C
What You Get
- Column B: the hostname of the highest-priority MX record for each domain
- Column C: the IP address resolved for that mail server
- Parked or misconfigured domains surface a NO-MX-RECORD note so they stand out immediately
- One row per domain, no reformatting needed
What If the Data Is Not Quite Ready
Need all MX records, not just the top one
Look up MX records for all domains in column A using MXToolbox, then fill in the mail server hostnames ranked by priority in columns B, C, and D, and the TTL values in column E — if a domain has fewer than three MX records, leave the extra columns blank
Some domains in the list are subdomains
Before running MXToolbox MX lookups, check each entry in column A — if it looks like a subdomain, resolve it to its root domain first, then run the MX lookup and write the results into columns B and C
Domains worksheet plus a separate Parked worksheet
Run MXToolbox MX lookups for all domains in column A of the Domains worksheet, write results into columns B and C, then do the same for the Parked worksheet and flag any parked domains that unexpectedly have active MX records with an ACTIVE-MX note in column D
Full pre-migration documentation in one shot
For every domain in column A, run MXToolbox MX lookup, write the top-priority mail server and IP into columns B and C, the TTL in column D, and a DOCUMENTED or NO-MX-FOUND status in column E — then sort the results so all NO-MX-FOUND rows appear at the top
The migration team sees exactly what they're walking into before Thursday's meeting.
Try It
Get the 7-day free trial of SheetXAI and open your acquired domain workbook, then ask it to run MX record lookups across column A. Related: Full Email Authentication Audit or the MX Toolbox overview for Excel.