# Running, cycling and swimming log Excel (free) + online

> Free Excel log for running, cycling and swimming: pace per km, speed, time per 100 m, the last 10 weeks, weekly goal and a warning when the load jumps over 10%.

Source: https://softwiro.com/blog/running-cycling-swimming-log-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Running, cycling and swimming log in Excel (free): pace, weekly distance and a load-jump warning

Log each session, see pace, speed or time per 100 m, and know when a week jumps too far above the last four.

13 November 2026 6 min read

## In short

- One row per session: date, sport, distance, minutes and optional heart rate.
- Pace per km for running and walking, speed for cycling and rowing, time per 100 m for swimming.
- The last 10 weeks by sport with a weekly goal percentage and the 4-week averages.
- A warning when a week is more than 10% above the average of the four weeks before it.

Whoever runs, rides and swims in the same week usually keeps the numbers in three different apps, and none of them says whether this week was too much. The free [running, cycling and swimming log](https://softwiro.com/templates/running-cycling-swimming-log) keeps every session in one file: it works out your pace, speed and time per 100 m, adds up each week, and warns you when the load jumps.

## The problem it solves

Most injuries from a sudden jump in training do not announce themselves in advance. If you only look at one session you do not see that this week was almost double the weeks before it. Here every session goes into one list, and a weekly page compares each week with the average of the four weeks before it.

## Steps

1. Settings: your name, today's date (or =TODAY() so it updates by itself), the increase that triggers the warning (10% to start) and a weekly goal in km for each sport.
2. Sessions: one row per session: date, sport from the list, distance in km, duration in minutes, and average heart rate if your watch records it.
3. Leave the grey columns alone: pace in minutes per km for running and walking, speed for cycling and rowing, and time per 100 m for swimming.
4. Open Weekly to see the last 10 weeks (Saturday to Friday) and watch the "load warning" column.

## Worked example (sample data, 13 November 2026)

The figures are sample data for a made-up athlete, not real training. The sheet holds 37 sessions over 10 weeks:

- A run: 7 km in 42 minutes gives a pace of 6.00 min/km (10.0 km/h).
- A ride: 34 km in 105 minutes gives 19.4 km/h.
- A swim: 2 km in 54 minutes gives 2.70 minutes per 100 m.
- A walk: 4 km in 48 minutes gives 12.00 min/km (5.0 km/h).
- The current week (from Saturday 7 November): 4 sessions, 47 km and 249 minutes. Against a weekly goal of 108 km (the sum of the goals of the five sports) that is 43.5%.
- The week of 24 October: 5 sessions, 96 km and 427 minutes, with a 45 km ride as the longest. The average of the four weeks before it is 50.4 km, so this week is 91% above it and is flagged "sharp increase", at 89% of the goal.
- Over the last 10 weeks: 523.5 km in 37 sessions, and 5 weeks were flagged.

## How the numbers are worked out

- Pace = minutes ÷ kilometres. Speed = kilometres ÷ hours. Time per 100 m = minutes ÷ (kilometres × 10).
- Goal percentage = the week's kilometres across all sports ÷ the sum of your weekly goals.
- Warning: the week's kilometres compared with the average of the four weeks before it. If it is more than the average × (1 + the percentage in Settings), "sharp increase" appears. With no earlier weeks recorded, no warning appears.

## Limits and tips

- The sheet is for personal tracking. It is not a training programme and not medical advice; a gradual increase does not replace asking a doctor or a coach if you feel pain.
- The warning compares kilometres only. It does not know the intensity of a session, your sleep or your recovery, and distances in different sports are added together as kilometres, which is a rough measure.
- A week starts on Saturday, and heart rate is optional: leave it empty if your watch does not measure it.
- Do not delete a row from the middle of the list. It holds 1500 sessions and five sports.

## Try it

[Open the sheet and try it online, or download it for Excel](https://softwiro.com/templates/running-cycling-swimming-log). If you want an app that connects to your watch and warns you on your phone, [ask for it here](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: running, cycling and swimming (1/3)](https://softwiro.com/uploads/cheatsheets/running-cycling-swimming-log/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/running-cycling-swimming-log/en-1.jpg)[![Cheat sheet: running, cycling and swimming (2/3)](https://softwiro.com/uploads/cheatsheets/running-cycling-swimming-log/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/running-cycling-swimming-log/en-2.jpg)[![Cheat sheet: running, cycling and swimming (3/3)](https://softwiro.com/uploads/cheatsheets/running-cycling-swimming-log/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/running-cycling-swimming-log/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I work out running pace per kilometre in Excel?

Enter the distance in km and the duration in minutes in Sessions, and the pace appears: minutes ÷ kilometres. For example 7 km in 42 minutes is 6.00 minutes per km. For cycling you get speed = kilometres ÷ hours, and for swimming the time per 100 m.

### What does "sharp increase" mean on the Weekly page?

The sheet compares each week's distance with the average of the four weeks before it. If it is above that average by more than the percentage in Settings (10% to start), the warning appears. It is a cue to ease the next week or spread the distance, not a diagnosis of an injury.

### Does the sheet replace a coach, a doctor or a dietitian?

No. It is for personal tracking only, not a training programme and not medical or nutrition advice. If you feel pain, dizziness or unusual symptoms ask a doctor, and ask a coach or dietitian about your plan.

### Does it connect to my watch or import sessions from Garmin and Strava?

No. You type each session or copy it from your watch app, and average heart rate is an optional cell. Automatic import from watches needs a purpose-built app.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
