Image for

LogRun: A Running Log in Google Sheets

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:

LogRun with Sample Data

Spreadsheet Graphs

Features

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?

  1. 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.
  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.

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!

Share!

Did you like this blog post? Why not share it with your network!

About the Author

Mike Kasberg

👋 Hi, I'm Mike! I'm a husband, I'm a father, and I'm a senior software engineer at Strava. I use Ubuntu Linux daily at work and at home. And I enjoy writing about Linux, open source, programming, 3D printing, tech, and other random topics.