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.
Download your GZ log file from cPanel- most cPanels have a download link under under Metrics labeled Raw Access.
Extract with GZ log file – I use WinRAR
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.
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.
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.
How to Exclude IP Address From Google Analytics
Remove, exclude, block, and hide yourself, internal traffic, and IP addresses from Google Analytics
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.