# Swimming times personal bests Excel (free) + online

> Free Excel swim log: record times and get pace per 100 m, half splits, personal best per stroke and distance, season best, improvement and a new-PB alert.

Source: https://softwiro.com/blog/swimming-times-personal-bests-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Swimming times and personal bests in Excel (free): pace per 100 m, splits and a new-PB alert

Log each swim once and see your personal best for every stroke and distance, with the improvement and a new-PB alert.

13 November 2026 6 min read

## In short

- Log each swim once: date, stroke, distance, pool and time.
- Total time, pace per 100 m and the half split are worked out for every swim.
- Per stroke and distance: personal best, its date, season best and improvement.
- A new personal best is flagged. A personal log, not training or medical advice.

Anyone who trains in the pool knows times are not something to keep in memory: is 1:05.10 better than last month's? Is this really your personal best, or did you break it two weeks ago? The free [swimming times and personal bests sheet](https://softwiro.com/templates/swimming-times-personal-bests) records every race or training test and works out the time, pace per 100 m and half splits, and shows your personal best for each stroke and distance on one page.

## The problem it solves

When you jot times in a notes app or on a results sheet, you know today's time but not your best in that stroke and distance, when it was, or how much you improved on the one before. Times from 25 m and 50 m pools also get mixed up, so you compare things that cannot be compared. Here you enter each swim once and the sheet does the rest, summarised per stroke and distance.

## Steps from opening the file to your personal best

1. Settings: the swimmer's name, the pool length shown (25 or 50 m) and the season start date, then review the list of strokes and distances.
2. Races: log each swim in a row: the date, the meet or training session, the stroke, the distance and the pool length from the lists.
3. Write the time in three cells: minutes, then seconds, then hundredths. A time of 1:05.40 is entered as 1, 5 and 40. The first-half split in seconds is optional.
4. The grey columns work out the total time, its written form, the time per 100 m, the second-half time and the type of split.
5. Open Personal bests to see for each stroke and distance: the personal best, its date, season best, number of swims and improvement, with the board at the bottom.
6. Change the pool length in Settings to switch the personal bests between the 25 m and 50 m pools, and check the "alert" column in Races for any incomplete row.

## Worked example (sample data)

The name and figures are sample data for an example swimmer, and the season starts on 1 September 2026. 32 swims were logged: 29 in the 25 m pool, which is the pool shown, and 3 in the 50 m pool, which do not count in these figures:

- 100 m freestyle: 4 swims, personal best 1:04.85 on 10 October, previous best 1:05.40, so an improvement of 0.55 seconds. The last swim, on 7 November, was 1:05.10, so no new personal best shows. In the 10 October swim the first half was 31.0 seconds and the second 33.85, so the split is "positive".
- 50 m freestyle: 3 swims, personal best 29.60 on 26 September, previous best 29.95 (improvement 0.35). On 31 October you repeated the same time, so the date stays 26 September and "new personal best" shows because the last swim equals the personal best.
- 400 m freestyle: 2 swims, from 5:02.30 on 17 October to 4:59.80 on 7 November, an improvement of 2.50 seconds and 1:14.95 per 100 m, and "new personal best" shows.
- 200 m freestyle: 3 swims, personal best 2:21.95 on 24 October, 2.15 seconds better than the previous best of 2:24.10, and the last swim (7 November) was 2:22.30 so no alert shows.
- 100 m backstroke: 2 swims, personal best 1:11.95 on 31 October, 0.45 seconds better than 1:12.40, and a new personal best.
- 100 m breaststroke: 3 swims, personal best 1:25.90 on 13 June, before the season started, so the season best is 1:26.40. There is no previous best, so the improvement is blank.
- New personal bests: 6 of the figures shown: 50 free, 50 back, 50 fly, 50 breast, 100 back and 400 free.
- 50 m pool: change the length in Settings to 50 and your three swims there show on their own (for example 29.80 in the 50 m freestyle).

## How the numbers are worked out

- Total time (s) = minutes × 60 + seconds + hundredths ÷ 100. For example 1, 5 and 40 = 65.40.
- Time per 100 m = total time ÷ distance × 100. For example 29.60 ÷ 50 × 100 = 59.20.
- Personal best = the lowest time for the same stroke, distance and pool length. If the time is repeated, the date is the first time.
- Improvement = previous personal best − current one in seconds, and it shows blank if it is your only best.
- Second half = total time − first-half time. "Negative" means your second half is faster than the first, and none appears in this sheet's examples.

## Limits of the sheet and tips

- The sheet is for personal tracking. It is not a training programme or medical advice. Follow your coach's guidance and see a doctor if you feel pain.
- The sheet does not compare the two pool lengths; personal bests are worked out for each length separately.
- Pick the stroke and distance from the list and check the "alert" column, which tells you about an incomplete or wrong row.
- If two swims share the same day, stroke and distance, the higher row counts as the more recent.
- It holds 800 swims, five strokes and four distances for one swimmer, and you should not delete a row from the middle of the list. Do not delete the hidden columns in Races and Personal bests; they are for the calculations.
- The sheet does not import times from meets, draw progress charts or alert your coach, and it is for one swimmer.

## Try it now

[Open the sheet and try it online, or download it as Excel](https://softwiro.com/templates/swimming-times-personal-bests). If you want an app for a swimming club or team with each swimmer's times and reports for the coach and parents, [request 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: swimming times (1/3)](https://softwiro.com/uploads/cheatsheets/swimming-times-personal-bests/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/swimming-times-personal-bests/en-1.jpg)[![Cheat sheet: swimming times (2/3)](https://softwiro.com/uploads/cheatsheets/swimming-times-personal-bests/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/swimming-times-personal-bests/en-2.jpg)[![Cheat sheet: swimming times (3/3)](https://softwiro.com/uploads/cheatsheets/swimming-times-personal-bests/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/swimming-times-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 work out the time per 100 m in swimming?

Log the time and distance on the Races sheet and the sheet works it out: time per 100 m = total time ÷ distance × 100. For example a 50 m freestyle in 29.60 seconds gives 59.20 seconds per 100 m, or 0:59.20.

### How do I enter a time like 1:05.40 in the sheet?

In three cells: 1 in "minutes", 5 in "seconds" and 40 in "hundredths". Do not enter more than 59 seconds. The sheet shows the total time in seconds with its written form beside it.

### Can I compare 25 m and 50 m pool times?

No. The sheet works out personal bests for each pool length separately, so you pick the length shown in Settings and switch between the pools. A blank pool cell in a race row takes the length written in Settings.

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

No. It is only a log of your times, not a training programme or medical advice. Follow your coach's guidance and consult a doctor if you feel pain or have an injury.

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