Convert Your Web Server Log Files to Spreadsheet

Learn how to Convert Your Web Server Log Files to Spreadsheet

If your troubleshooting something you may realize the benefit of being able to  convert your web server log files to spreadsheet view. Everyone’s method of converting server logs is different – here’s mine.

First, download your web server logs, extract, and change file type to a spreadsheet.

  1. Download your GZ log file from cPanel- most cPanels have a download link under under Metrics labeled Raw Access.
  2. Extract with GZ log file – I use WinRAR
  3. Change your file extension to CSV – so your computer can associate it with your installed spreadsheet software (I use Apache OpenOffice, it’s free and good Office substitute)

Run OpenOffice Calc Text Wizard to convert your web server log files to spreadsheet view.

Open your website log CSV to begin the wizard to convert unreadable website logs into a nice spreadsheet view, allowing you to preview your data while adjusting the import settings.

Learn how to Convert Your Web Server Log Files to Spreadsheet

Your Website Logs in Spreadsheet View!

Now that you know how to convert your web server log files to spreadsheet, you can review your traffic in a familiar environment.

Learn how to Convert Your Web Server Log Files to Spreadsheet

 

Leave a Reply

Your email address will not be published. Required fields are marked *