LogRun: A Running Log in Google Sheets31 Jul 2018
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.
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:
- 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:
Make a copy...to save your own copy to your Google Drive. Or, Click
Download asto 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!