Is there a way to export the contents of access.log to excel spreadsheet so as to manipulate the data from there?
Squid access.log export to excel
exportlog-filesloggingsquid
Related Topic
- Ubuntu – /var/log/squid/access.log is empty when I use proxy from remote computers
- Mysql – Export massive MySQL database, from a shared level hosting account
- Nginx access.log only kept for a day
- How to export a detailed list of Active Directory users’ “Member of” tab
- Lag in squid TCP_TUNNEL/200 access.log
- Amazon AWS – Export EBS Snapshot to External Storage
Best Answer
The squid native log format is :
time elapsed remotehost code/status bytes method URL rfc931 peerstatus/peerhost type
In the fact, you can develop a simple parser using awk or maybe with perl or python, ... and delimit the data with a delimiter of your choice to get a CSV file. Somethink like this:
awk '{ print $1","$2","$3","$4","$5","$6","$7","$8","$9","10 }' /var/log/squid/access.logFor more information, please find here a small squid log viewer using python. http://github.com/mezgani/sqview