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

 

Exclude IP Address From Google Analytics

As a web developer, I’ve always wondered how to remove myself from Google Analytics stats, so the time I work and click on a client’s website doesn’t get mixed into the public traffic.

If and when it matters, there is a way to exclude IP addresses from Google Analytics reports.

Google Analytics gives you the ability to remove IP addresses from appearing in the reports so you can remove yourself by way of filtering your IP address. This can be useful when, for example, you want to hide internal traffic from your employees on the company’s public website.

Exclude IP Address From Google Analytics
Exclude IP Address From Google Analytics

How to Exclude IP Address From Google Analytics

Remove, exclude, block, and hide yourself, internal traffic, and IP addresses from Google Analytics

  1. Determine what traffic you want to exclude and hide. A website development company may want to remove their team’s traffic while a company may want to exclude their internal traffic.
  2. Identify the IP address(es) of the traffic you want to block. A quick Google search for “what’s my IP” will show you your current IP addresses.
  3. In Google Analytics, under Account Filters, add a filter (screenshot above) to hide all traffic from the IP address(es) you noted. There are more options for excluding traffic.