# Athletics results Excel (free) + online

> Free Excel athletics log: record races, jumps and throws and get each event's personal best, season best, improvement, last-3 average and km/h speed.

Source: https://softwiro.com/blog/athletics-track-field-personal-bests-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Athletics results and personal bests in Excel (free): season best, improvement and speed in km/h

Log each result once and see every event's personal best, season best, improvement and running speed.

13 November 2026 6 min read

## In short

- Log each result once: date, event and result in seconds or metres.
- Per event: personal best, its date, season best and attempts.
- Improvement on the previous best, the last-3 average and a new-best flag.
- Speed in km/h for running events. A log, not coaching or medical advice.

An athlete measures progress in numbers: did I run the 100 m faster this month than last month? What is my best time of the season, and when did I set my personal best? The free [athletics results and personal bests sheet](https://softwiro.com/templates/athletics-track-field-personal-bests) records every result in races, jumps and throws and shows each event's personal best, its date and the season best, so you see your progress on one page.

## The problem it solves

When your results are scattered across the coach's paper, WhatsApp messages and meet schedules, you know what you did in the last meet but not your personal best in each event or its date, or whether you improved this season or slipped. Here you enter each result once in a row and the sheet gathers them per event.

## Steps from opening the file to your personal bests

1. Settings: write the athlete's name and the season start date, and review the list of events (up to 12): the type of each event, "time" or "distance", and the race distance in metres for running events.
2. Results: log each result in a row in date order, oldest to newest: the date, the meet or training, and the event from the list.
3. Enter the result in seconds for races (such as 11.85) and in metres for jumps and throws (such as 6.12), then the wind speed and place if you have them.
4. Leave the grey columns alone: they show the result written out (such as 2:10.5) and work out whether it is valid and whether it breaks your best.
5. Open Personal bests to see, for each event, the personal best, its date, the season best, the improvement and the average of the last 3 results.
6. Watch the "new personal best" column and the speed table in km/h for running events.

## Worked example (sample data)

The name and figures are sample data for an example athlete, and the season starts on 1 September 2026. 48 results were logged, 15 of them in the current season, and the athlete stood on the podium (first to third place) 10 times:

- 100 m: 9 attempts, and the personal best is 11.72 s on 17 October 2026 after 6 improvements; the improvement on the previous best (11.78) is 0.06 s. The season best is the same 11.72 from 4 attempts. The last result is 11.76 on 10 November, so no new-best flag shows. The average of the last 3 is 11.76. The personal best's speed is 30.72 km/h.
- 200 m: personal best 23.88 s on 17 October, 0.07 s better than the previous best (23.95), and it is the last result, so "new personal best" shows. Speed 30.15 km/h.
- 400 m: personal best 54.3 s on 3 October, 0.3 s better than 54.6, and "new personal best" shows. Speed 26.52 km/h.
- 800 m: personal best 2:05.9 (125.9 s) on 12 November after 4 improvements, 0.4 s better than 126.3, with an average of the last 3 of 126.57. Speed 22.88 km/h.
- 1500 m: personal best 4:26.8 (266.8 s) on 8 August 2026, which is before the season start, so the season best is 4:28 (268.0 s), different from the personal best. The last result is 268.0, so no new-best flag shows.
- Long jump: 6 attempts, personal best 6.12 m on 18 April 2026, season best 6.08 m, last result 6.01 m.
- High jump: personal best 1.85 m on 11 July 2026, season best 1.82 m.
- Shot put: personal best 12.3 m on 10 October, 0.25 m better than 12.05, and "new personal best" shows.
- Javelin: one result of 32.4 m, which is the personal best; there is no result in the current season, and no improvement shows because there is no earlier best. "New personal best" shows.
- Events showing "new personal best": 5 events (200 m, 400 m, 800 m, shot put and javelin).
- Wind: the 100 m result on 19 September (11.80 s) was run with +2.4 m/s wind, so the sheet shows "wind above +2 m/s: not counted as an official mark".

## How the numbers are worked out

- Personal best: the lowest time in races, and the greatest distance or height in jumps and throws.
- Season best: the best result from the season start date onward.
- Improvement on the previous best: the difference between the current personal best and the personal best before it.
- Speed (km/h) = distance in metres ÷ time in seconds × 3.6. For example 100 ÷ 11.72 × 3.6 = 30.72.
- New personal best: shows when the last result of an event is the same as its personal best.

## Limits and tips

- The sheet is for personal tracking. It is not a training programme or medical advice and does not replace a coach or a doctor; consult them on your training plan and on any injury or pain.
- Log results in date order, oldest to newest: the sheet treats the upper row as older and compares each result with those above it. Do not delete a row from the middle of the list.
- Enter times in seconds: an 800 m in 2:10.5 is written 130.5, and a 1500 m in 4:35.4 is written 275.4.
- A result with wind above +2 m/s is not accepted as an official mark in competitions, but it still counts in the sheet. Official ratification of marks rests with the sport's federation.
- The sheet holds 800 results and 12 events for one athlete. It does not draw a chart of progress, alert you about qualifying standards or pull times from a timing watch.

## Try it

[Open the sheet and try it online, or download it for Excel](https://softwiro.com/templates/athletics-track-field-personal-bests). If you want an app for an athletics club where the coach follows his athletes' results and charts their progress, [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: track and field (1/3)](https://softwiro.com/uploads/cheatsheets/athletics-track-field-personal-bests/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/athletics-track-field-personal-bests/en-1.jpg)[![Cheat sheet: track and field (2/3)](https://softwiro.com/uploads/cheatsheets/athletics-track-field-personal-bests/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/athletics-track-field-personal-bests/en-2.jpg)[![Cheat sheet: track and field (3/3)](https://softwiro.com/uploads/cheatsheets/athletics-track-field-personal-bests/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/athletics-track-field-personal-bests/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 enter an 800 m time in the sheet?

Write the whole time in seconds: 2:10.5 is written 130.5 (2 × 60 + 10.5). The sheet then shows it in the "result written out" column as minutes and seconds. For jumps and throws, enter the result in metres, such as 6.12.

### How does the sheet decide the personal best?

In timed events the personal best is the lowest time, and in jumps and throws the greatest distance or height. If two results are equal, the date of the first one is kept. The season best counts results from the season start date onward.

### Is a mark set with a strong wind an official mark?

No. A result with wind above +2 m/s gets a note in the sheet and is not accepted as an official mark in competitions, but it still counts in the sheet's calculations. Check with your federation or the meet organiser on ratifying marks.

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

No. It only tracks your results for personal use and is not a training programme or medical advice. Ask your coach about your training plan, and consult a doctor if you have an injury or pain when running, jumping or throwing.

## 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)
