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.

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

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

1. Choose one of the blank versions below:
   • LogRun – Standard version. 365 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.