
LogRun: A Running Log in Google Sheets
31 Jul 2018I 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.
Update & Disclaimer: I joined the software engineering team at Strava in April, 2019! So although I didn’t work for Strava when I wrote this blog post, I do now! We’re building amazing things for athletes, and I’d encourage you to check out Strava and consider subscribing for our best features. It’s amazing how much motivation can come from being part of a community.
The best way to understand how this works and what it can do is to see an example:
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 similar that presented the types of data I find most important in the simplest way possible. And I wanted something that worked in Google Sheets instead of Excel. 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?
- Choose one of the versions below:
- LogRun – Standard version. 356 rows, fits up to a year of daily data. Use this version if you’re not sure which to pick.
- LogRun Metric – Uses kilometers instead of miles.
- LogRun 1000 – Fits 1000 rows of data. Because of this, it might also be slower. Use it if 365 rows isn’t enough for you.
- Click
File
,Make a copy...
to save your own copy to your Google Drive. Or, ClickFile
,Download as
to download an Excel version.
NOTE: Do not request access to edit the blank copy. You must make your own copy first so that the blank copy remains available for everyone.
This spreadsheet has been a fun and useful tool for me, and I hope you enjoy it too! Please share it with your friends, and if you like it, let me know @mike_kasberg!