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 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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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. If you want an app for an athletics club where the coach follows his athletes' results and charts their progress, ask for it here.





