Create a Free Running Log in Google Sheets – Step‑by‑Step Guide (Template Included)

Disclosure: We are reader supported, and earn affiliate commissions when you buy through us.

Want a single place where every run you log instantly shows total mileage, pace, and heart‑rate trends? This guide walks you through building a running log Google Sheets from scratch, adds formulas that do the math for you, and provides a ready‑to‑use template you can copy in seconds. Follow the steps below and start seeing your training data clear‑as‑day today.

Why Traditional Apps Fall Short

Most running apps force you to jump between screens for distance, time, and heart rate, leaving you without a holistic view of your progress. You end up with scattered data, missed patterns, and the temptation to stop tracking altogether. A running log Google Sheets solves this by keeping everything in one editable sheet that you control.

Setting Up the Sheet

1. Open a new Google Sheet and name it something like Running Log.
2. Create the following columns in row 1:

3. In column C, convert the mm:ss format to a decimal hour value so pace can be calculated. Use this formula in C2 and drag down:

=TIMEVALUE(C2)

Automatic Pace & Weekly Totals

Pace per Run

Add a Pace column (F). In F2 enter:

= C2 / (B2/60)

The result is minutes per mile. Drag the fill handle down; every new entry instantly shows its pace.

Weekly Summaries

Create a small table at the top of the sheet (rows 2‑5) to summarize the current week.

• Weekly Distance:

=SUMIF(A:A, ">=" & TODAY() - WEEKDAY(TODAY()) + 1, B:B)

• Weekly Time:

=SUMIF(A:A, ">=" & TODAY() - WEEKDAY(TODAY()) + 1, C:C)

• Weekly Pace (minutes per mile):

= (Weekly Time) / (Weekly Distance/60)

These formulas update automatically each Monday, giving you an instant check on whether you’re on track.

Visualizing Progress

1. Distance Chart – Highlight Date (A) and Distance (B), insert a Line chart, and place it below the log. The line climbs as you add runs, instantly highlighting any dip.
2. Heart‑Rate Trend – Highlight Date (A) and Heart Rate (D), insert another line chart. This lets you spot weeks where you may be over‑training.

Both charts are dynamic; they grow with each new row you add.

Download the Free Template

The full sheet, pre‑filled with the formulas and charts above, is available as a free running log spreadsheet template. Click the button below, make a copy to your Drive, and start logging immediately.

Copy the Running Log Template (link to the Google Sheet copy)

Next Steps

• Add optional columns for Shoes, Weather, or How You Felt to enrich your analysis.
• Use QUERY or FILTER functions to create custom reports (e.g., “runs over 10 mi”).
• Subscribe to the Running Log Blog newsletter for more tracking tips, or share this guide with a fellow runner.

Start logging today—watch your mileage add up, your pace improve, and your training become data‑driven, all without a pricey app.