LogRun: A Running Log in Google Sheets

LogRun: A Running Log in Google Sheets

Tuesday July 31, 2018
Projects


I made a training log in Google Sheets.

Even in the age of Fitbit, GPS running watches, and Strava, a training log in a spreadsheet is a useful tool. Because it’s a spreadsheet, it can be used to analyze data in ways that websites and apps can’t. Also, it can be incredibly motivating to set a goal and record your progression over time.

Anyway, here it is: LogRun with Sample Data

Spreadsheet Graphs

Features

  • Calculates average pace based on distance and time.
  • Displays weekly mileage, average pace, and time spent running in tables and graphs.
  • Breaks down stats by type of run (easy, long, tempo, etc).
  • Mileage graphs are a great visualization tool for spotting trends and measuring progression.
  • Tracks mileage on shoes.
  • Tracks race performance and personal records.

Long ago, David Hays published a similar training log in Excel. I wanted to create something that presented the data I found to be most important in the simplest way possible, and something that worked in Google Sheets. David Hays’ training log was a big source of inspiration for me.

Create Your Own Training Log

Want to use (or modify) my training log to track your own workouts?

  1. Visit the LogRun Blank Copy.
  2. Click File, Make a copy... to save your own copy to your Google Drive. Or, Click File, Download as to download an Excel version.

I hope someone finds it useful. If you like it, let me know @mike_kasberg!


View more posts