---
title: Create a Free Running Log in Google Sheets – Step‑by‑Step Guide (Template Included)
siteUrl: https://logzly.com/runloginsights
author: runloginsights (RunLog Insights)
date: 2026-07-26T22:20:10.056706
tags: [runninglog, googlesheets, fitnesstracking]
url: https://logzly.com/runloginsights/create-a-free-running-log-in-google-sheets-stepbystep-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](https://www.amazon.com/s?k=Google+Sheets&tag=organizationtip101-20)** 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](https://www.amazon.com/s?k=training+data&tag=organizationtip101-20) 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](https://www.amazon.com/s?k=Google+Sheet&tag=organizationtip101-20) and name it something like **Running Log**.  
2. Create the following columns in row 1:  

| A | B | C | D | E |
|---|---|---|---|---|
| Date | Distance (mi) | Time (mm:ss) | Heart Rate (avg bpm) | Notes |

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:

```gs
=TIMEVALUE(C2)
```

## Automatic Pace & Weekly Totals

### Pace per Run  
Add a **Pace** column (F). In **F2** enter:

```gs
= 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](https://www.amazon.com/s?k=small+table&tag=organizationtip101-20) at the top of the sheet (rows 2‑5) to summarize the current week.

- **Weekly Distance**:  

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

- **Weekly Time**:  

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

- **Weekly Pace** (minutes per mile):  

```gs
= (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](https://www.amazon.com/s?k=Line+Chart&tag=organizationtip101-20)**, 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.