'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Understanding eDiscovery Standard Export Warnings and Errors CSV
Question details
Users need to understand the meaning of columns in the Warnings and Errors CSV generated by an eDiscovery Standard export, including how ExportItemID functions and how to compare similar emails.
- Product
- Microsoft 365 eDiscovery
- Device & OS
- not provided
- Scenario
- Reviewing an eDiscovery Standard export report to troubleshoot warnings, missing items, or file size differences.
- Observed behavior
- The export generates a CSV detailing issues, but users lack clarity on error codes, the permanence of ExportItemID, and the criteria for comparing potentially duplicate messages.
Ensure you have downloaded the complete export package from your eDiscovery search and have a spreadsheet application installed to open and analyze the CSV report files.
Analyze the Warnings and Errors CSV Columns
Use this method to interpret the data provided in the export summary report to identify why certain files failed or triggered warnings.
The Warnings and Errors CSV is designed to report export issues accurately. It provides essential metadata for troubleshooting compliance exports.
Navigate to your downloaded eDiscovery export folder and open the Warnings and Errors CSV file using a spreadsheet application.
Locate the columns for the affected file name, error details, error code, and error type to understand exactly why an item was flagged during the export.
Use the ExportItemID column to identify an item within this specific export. Note that this ID is unique only to the current export and should not be used as a permanent reference across multiple separate exports.
Compare Similar Email Messages
Follow these guidelines to determine if multiple email messages in your export are identical duplicates.
Utilize eDiscovery Premium for Advanced Review
If you frequently need to deduplicate and review large sets of data, upgrading to eDiscovery Premium offers better built-in tools.
Easily Analyze eDiscovery CSV Reports with WPS Office
While Microsoft Purview handles your compliance searches, analyzing the exported CSV reports is much faster with a lightweight spreadsheet tool. WPS Office is a highly compatible, free alternative to Microsoft Office that easily handles large data files.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website.
- 2. Open Your Export CSV: Launch WPS Spreadsheet, go to Menu > Open, and select your eDiscovery Warnings and Errors CSV.
- 3. Filter the Errors: Select the header row, click the Data tab, and choose Filter to easily sort through error codes and ExportItemIDs.
Frequently Asked Questions
What is the ExportItemID in an eDiscovery standard export?
The ExportItemID is a unique identifier assigned to an item within a single export batch. It helps you locate a specific file in the current export but should not be treated as a permanent reference ID across different exports.
Why do file sizes differ in my eDiscovery export results?
File sizes can vary due to differences in how the system handles metadata, unindexed items, formatting, or attachments during the export packaging process.
How can I be absolutely sure two emails in my export are the same?
To confirm two emails are identical, you must compare multiple data points: the Subject, Sender, Recipients, Body, Message-ID, Date, Headers, and precise timestamps.
Does eDiscovery Premium handle errors differently?
Yes, eDiscovery Premium offers advanced review sets that allow you to analyze, deduplicate, and review items directly within the platform, reducing the need to manually parse CSV error reports.
