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

• Anonymous
  March 09, 2007
  PingBack from http://www.decatec.it/blogs/2007/03/10/Sharepoint+2007+Log+Parsing+With+Excel.aspx