Aside from the great reporting options available directly within the Office 365 portal, there is also an Excel add-in that allows administrators to download information directly in to Excel for data manipulation.  Obviously once the data is in Excel, then all of the various options with Office also exist, such as exporting to Word, PowerPoint, etc. and choosing which charts are appropriate for different organizations.


The Mail Protection Report is a separate MSI file, so it needs to be installed separately from Excel. Download it here


After downloading the file, a Setup wizard will be started (with Excel 2013 and .NET Framework 4.5 as pre-requisites):



Whether using Exchange Online or simply using Exchange Online Protection for your on-premises e-mail solution, the reports work the same:






Once finished, you can now open Mail Protection Reports from your Desktop (don’t try to find it simply by opening Excel 2013 – it’s not there).


Install the customization, after which Excel 2013 will open.  From here, select Query to get the admin authentication prompt and then choose your time interval:

MPR-11 MPR-12

You can see that the spreadsheet is blank until authentication is provided.  After entering the username and password, you will see the reports downloading:

MPR-13 MPR-14 MPR-15

Once all the information is imported, you can now navigate between the available tabs within Excel to view available data.  Different traffic types can be selected individually or collectively, and the data available based upon the time interval you selected have the same options (dragging the mouse even works for selecting multiple dates).


All of the standard Excel capabilities are available, as well, so edit and manipulate the data as needed, and then export to the proper reports or save as spreadsheet.


Category: How to do; Servers
Published: 12/4/2013 20:45