Google Sheets

How to import one or more log archives into Google Sheets for additional analysis and charting.

Import

Download a log archive, which is in tab-separated value (TSV) format (more).

In Google Sheets, choose Start a new spreadsheet > Blank. Upload the archive file and let Sheets auto-detect settings:

spreadsheet-1.jpg

Column names

After importing data, rename column headers to more useful names (from Permanent log archives).

google-spreadsheets-columns.jpg

Functionality

Filter

To analyze a subset of logs, use Data > Filter. See filtering.

Pivot tables

For additional analysis, use functions or Data > Pivot table report. Read Google’s introduction and documentation.

Charts

See charts.

Size note

As of this writing, Google Sheets are restricted to 2 million cells (more).