Use Excel 2007 to Read and Parse SharePoint 2007 Logs

Ever get tired of trying to read and make sense of the MOSS 2007 Logs?  Or any text-based logs for that matter?  Use Excel 2007 to open and import the logs.  You can then filter and browse the logs in a searchable Excel format.  In fact You can refresh the Logs by hitting the refresh button on the Data Toolbar.  See Below!  I am filtering on the w3wp.exe process.  You can even filter it down so that you only see Exceptions by specifying a search filter criteria on the Message Column.

Comments