How to Access Microsoft 365 Threat Explorer Data and Export Fields
Question details
Users need a way to programmatically access or fully export complete email investigation data from Microsoft 365 Threat Explorer.

- 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.
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.
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.
Navigate to the Microsoft 365 Defender portal and log in with your administrative credentials.
Go to the 'Email & collaboration' section on the left-hand navigation pane and select 'Explorer' (or 'Real-time detections').
Apply the desired filters (such as date range, malware, phishing, or specific recipients) to narrow down the email investigation data you wish to retrieve.
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.

Submit a Specialized API Access Request
Request custom programmatic access or feature enhancements directly from the Microsoft security and compliance team for specialized API requirements.
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. Download WPS Office: Visit the official WPS Office website to download the free suite.
- 2. Install the application: Run the installer and follow the on-screen instructions to complete the setup.
- 3. Open your security report: Launch WPS Spreadsheet and open the CSV file exported from Microsoft 365 Threat Explorer for deep data analysis.

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.




