Back to MX Toolbox in Excel
SheetXAI logo
MX Toolbox logo
MX Toolbox · Excel Guide

Run a Bulk Email Deliverability Audit From a Excel

2026-05-14
5 min read

The Scenario

You manage deliverability for 150 client domains across an email marketing agency. A major campaign is scheduled to go out in three days. Your account manager pinged you this morning asking which domains are safe to send from — and you haven't run a fresh audit since last quarter.

The bad version:

  • Open MX Toolbox in a browser tab, paste the first domain from your workbook, wait for the SPF and DKIM results, read through the output, switch tabs, type the values into column B and C, move to the next domain.
  • Repeat 149 more times, losing your place twice when a result comes back ambiguous and you have to re-read it.
  • Finish three hours later having entered data for 150 domains — data you'll need to re-enter again next quarter because the whole thing is manual.

Three hours of data entry is not three hours of deliverability work. The campaign launch doesn't move, and you've spent your prep time on copy-paste instead of fixing the domains that actually need attention.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads your domain list, understands what you're looking at, and through its built-in MX Toolbox integration runs SPF, DKIM, and DMARC lookups across every domain and writes the results back — all from one prompt.

For every domain in column A, look up its SPF record and DKIM record via MXToolbox, then write the SPF value, DKIM selector status, and any errors into columns B, C, and D

What You Get

  • Column B: the raw SPF record string for each domain, or a note that no SPF record was found
  • Column C: DKIM selector status — pass, fail, or missing — with selector name where applicable
  • Column D: any diagnostic errors surfaced by MX Toolbox for that domain
  • One row per domain, aligned to column A — no extra formatting required

What If the Data Is Not Quite Ready

Domains mixed with subdomains and bare IPs

For every entry in column A, check if it is a valid domain before running MXToolbox — skip anything that looks like a bare IP address or a subdomain without a root, and write SKIPPED in column B for those rows, then run SPF and DKIM checks for the rest

DMARC policy missing from the original brief

In addition to SPF and DKIM, also check the DMARC record for each domain in column A using MXToolbox, and add a column E with the DMARC policy value — none, quarantine, reject, or MISSING if no record exists

Workbook has duplicates and blanks

Before running MXToolbox checks, deduplicate column A and skip any blank rows, then write SPF, DKIM, and any errors into columns B, C, D for the unique non-blank domains only

Full pre-campaign readiness sweep in one shot

For each domain in column A, clean duplicates and blanks first, then use MXToolbox to check SPF, DKIM, and DMARC, write the results into columns B through D, and add a column E with a SEND-SAFE or REVIEW label based on whether all three checks passed

The pattern: cleanup and diagnostic in a single prompt means you get a usable report instead of a workbook that needs another pass before it's actionable.

Try It

Get the 7-day free trial of SheetXAI and open your client domain list in Excel, then ask it to run SPF and DKIM checks across column A. Related: Bulk Blacklist Check for Sending Domains or the MX Toolbox overview for Excel.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more