Data Protection Issues

How to Access Microsoft 365 Threat Explorer Data and Export Fields

Bushra ParveenBushra Parveen Nov 2, 2026 868 views

Question details

Users need a way to programmatically access or fully export complete email investigation data from Microsoft 365 Threat Explorer.

How to Access Microsoft 365 Threat Explorer Data and Export Fields
Product
Microsoft 365 Threat Explorer
Device & OS
not provided
Scenario
Attempting to retrieve comprehensive threat-related fields and email lists using automated APIs for security monitoring and compliance.
Observed behavior
Standard Microsoft Management Activity API schemas, such as Audit and DLP schemas, do not expose the complete email investigation data found in Threat Explorer.
Before you start

Ensure you have the necessary administrative privileges, such as the Security Administrator or Global Administrator role, in the Microsoft 365 Defender portal before attempting to retrieve or export threat data.

Solution 1Recommended

Use the Built-in Threat Explorer Export Function

Manually export the data directly from the Threat Explorer interface to obtain the complete email list and all necessary threat-related fields.

Since the standard Microsoft APIs do not surface all email investigation metrics, the most reliable method to retrieve complete data is through the native export capabilities within the Microsoft 365 Defender portal.

1
Log into Microsoft 365 Defender

Navigate to the Microsoft 365 Defender portal and log in with your administrative credentials.

2
Navigate to Threat Explorer

Go to the 'Email & collaboration' section on the left-hand navigation pane and select 'Explorer' (or 'Real-time detections').

3
Filter your investigation data

Apply the desired filters (such as date range, malware, phishing, or specific recipients) to narrow down the email investigation data you wish to retrieve.

4
Export the report

Click the 'Export' button at the top of the data list. This will generate and download a CSV file containing the complete email list and all threat-related fields.

Use the Built-in Threat Explorer Export Function
Export Complete: The downloaded CSV file will contain the granular email investigation data that is currently missing from the standard Management Activity API schemas.
Free Microsoft Office alternative

Easily Analyze Your Exported Security Reports with WPS Office

While Microsoft 365 manages your threat intelligence, you can seamlessly analyze and share your exported CSV security reports using WPS Office. It provides a lightweight, free, and highly compatible alternative to Microsoft Office for all your data evaluation needs.

  1. 1. Download WPS Office: Visit the official WPS Office website to download the free suite.
  2. 2. Install the application: Run the installer and follow the on-screen instructions to complete the setup.
  3. 3. Open your security report: Launch WPS Spreadsheet and open the CSV file exported from Microsoft 365 Threat Explorer for deep data analysis.
100% compatible with Microsoft Excel CSV and XLSX formatsEasily filter and analyze complex Threat Explorer export dataFree and lightweight suite for fast, responsive data managementFamiliar user interface with zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the Management Activity API include Threat Explorer data?

Threat Explorer utilizes specialized backend datasets for deep email investigations. These granular metrics are not completely mapped or exposed through the standard Audit and DLP schemas of the Microsoft Management Activity API.

What format does Microsoft 365 Threat Explorer export data in?

When using the built-in export function in the Microsoft 365 Defender portal, the complete email list and associated threat-related fields are downloaded as a standard CSV (Comma Separated Values) file.

How can I automate the export of Microsoft 365 email investigation data?

Because full automation via standard APIs is currently limited, organizations typically rely on manual CSV exports. For automated or programmatic access, you must consult the Microsoft security team via their official GitHub forums to explore custom scripts or beta API endpoints.