Email and Cyber Security · #26

Online DMARC Aggregate Report Viewer

Turns the DMARC XML reports sent by receivers into a readable table by source IP.

  • Data is processed in your browser and not sent to a server
  • Export: CSV

Tool

Uncompressed .xml, up to 20 MB. The file does not leave your browser.

Ignored if a file is selected.

What does this tool do?

Reports arriving at your DMARC rua address are compressed XML files showing which IPs send mail as your domain and whether they align with SPF and DKIM. Before moving from p=none to quarantine/reject you need to see in these reports that all legitimate senders are aligned.

How to use it

  1. Unpack the .gz or .zip attachment on your computer and select the .xml file, or paste the XML text.
  2. Press Calculate. The table merges rows with the same source IP and results.

Fields

XML file
Uncompressed .xml, up to 20 MB. The file does not leave your browser.
or XML text
Ignored if a file is selected.

Worked example

InputValue
or XML text
<?xml version="1.0" encoding="UTF-8"?>
<feedback>
 <report_metadata><org_name>google.com</org_name><report_id>1234567890</report_id><date_range><begin>1763251200</begin><end>1763337599</end></date_range></report_metadata>
 <policy_published><domain>contoso.com</domain><adkim>r</adkim><aspf>r</aspf><p>none</p><pct>100</pct></policy_published>
 <record><row><source_ip>203.0.113.25</source_ip><count>3</count><policy_evaluated><disposition>none</disposition><dkim>pass</dkim><spf>pass</spf></policy_evaluated></row><identifiers><header_from>contoso.com</header_from></identifiers><auth_results><dkim><domain>contoso.com</domain><result>pass</result></dkim><spf><domain>contoso.com</domain><result>pass</result></spf></auth_results></record>
 <record><row><source_ip>203.0.113.25</source_ip><count>7</count><policy_evaluated><disposition>none</disposition><dkim>pass</dkim><spf>pass</spf></policy_evaluated></row><identifiers><header_from>contoso.com</header_from></identifiers><auth_results><dkim><domain>contoso.com</domain><result>pass</result></dkim><spf><domain>contoso.com</domain><result>pass</result></spf></auth_results></record>
 <record><row><source_ip>198.51.100.77</source_ip><count>2</count><policy_evaluated><disposition>none</disposition><dkim>fail</dkim><spf>fail</spf></policy_evaluated></row><identifiers><header_from>contoso.com</header_from></identifiers><auth_results><spf><domain>bulten.example</domain><result>pass</result></spf></auth_results></record>
</feedback>

Expected result: 12 messages, 2 rows: 3 + 7 = 10 messages from 203.0.113.25 aligned for DKIM and SPF; 2 messages from 198.51.100.77 not aligned (raw SPF pass for bulten.example).

198.51.100.77 passes SPF for its own domain (bulten.example) but is not aligned with the From domain contoso.com. This is typically a newsletter service: enable DKIM signing for contoso.com or a custom Return-Path domain there.

Method and assumptions

The XML is read with a safe parser: DOCTYPE and ENTITY declarations are rejected and nothing external is loaded. For each record the source IP, count, policy_evaluated (disposition, aligned dkim and spf) and auth_results (raw DKIM/SPF results and domains) are read.

Rows with the same IP, header_from and results are merged. Alignment rate = messages with DKIM or SPF aligned / total messages.

Policy evaluation and raw authentication results are separate columns: a raw SPF pass is not DMARC-aligned if its domain does not match From.

Using the result and troubleshooting

Identify who owns the IPs in unaligned rows: for your own services add them to SPF or enable DKIM; unknown sources are spoofing, which the DMARC policy targets.

Download as CSV to compare several days.

Limits and common mistakes

  • .gz and .zip archives are not unpacked; unpack them first.
  • Forensic (ruf) reports are not supported.
  • IP owners (reverse DNS, ASN) are not looked up.

Frequently asked questions

Why 'disposition none' but DKIM fail?

With p=none no action is taken on failing mail. Once you raise the policy these rows become quarantine or reject.

Related tools and service

  • DMARC Record CheckerReads the _dmarc record and interprets its policy, reporting and alignment settings.

Related service: Email Security and Phishing Protection

Cybersecurity online tools · See all online tools