Mike Kasberg

Husband. Father. Software engineer. Ubuntu Linux user.

Image for LogRun: A Running Log in Google Sheets

LogRun: A Running Log in Google Sheets

31 Jul 2018

I made a training log for runners 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. It’s easy to share with a coach. And some people might find extra motivation from setting a goal and recording their progression over time in a spreadsheet.

Update: 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. And whether you join Strava or not, I hope this running log spreadsheet is useful for you!

My running log spreadsheet does a lot of automatic calculations and graphs after you input your daily running time and mileage. The best way to see what it can do is with an example. (Be sure to check out the tabs at the bottom of the spreadsheet to see the graphs!)

Example Spreadsheet: LogRun with Sample Data

Spreadsheet Graphs


  • 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 his version of a training log in Excel. I was inspired by that, and 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. The spreadsheet I’ve created here is what I came up with.

Create Your Own Training Log

This training log spreadsheet is free for you to use and modify to track your own workouts and share with your training partners, coaches, and friends.

Do not "Request Access" to edit the blank copy or the example. You must make your own copy first (with the instructions below) so the blank copy remains available for everyone.

  1. Choose one of the blank 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.

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! You can even buy me a coffee if you want to, as a way to say thanks.

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.


Sharing my blog posts is a great way to support me and help my blog grow!

I run this blog in my spare time, without any ads. There's no need to pay to access any of the content on this site, but if you find my content useful and would like to show your support, this is a small gesture to let me know what you like and encourage me to write more great content!