Softwiro
Free Excel template

Swimming times and personal bests

A free Excel swim log for times and personal bests. Log each race or training test in one row (date, stroke, distance and pool length) and enter the time in minutes, seconds and hundredths. The sheet works out the total time, the pace per 100 m and the half splits. For each stroke and distance you then see your personal best and its date, your season best, the number of swims and your improvement over the previous best, and the sheet alerts you when you set a new personal best.

Excel file (.xlsx) · 295 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “الأرقام الشخصية” tab (Arabic), with the numbers and formulas that are in the file.
الأسلوبالمسافة (م)عدد المراتالرقم الشخصيتاريخهالتحسن (ث)أفضل زمن في الموسمتنبيه
حرة5030:29.60462910.350:29.60رقم شخصي جديد
حرة10041:04.85463050.551:04.85
حرة20032:21.95463192.152:21.95
حرة40024:59.80463332.504:59.80رقم شخصي جديد
ظهر5030:32.60463330.300:32.60رقم شخصي جديد
ظهر10021:11.95463260.451:11.95رقم شخصي جديد
ظهر2000
ظهر4000

Example from the “الأرقام الشخصية” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • «الإعدادات» (Settings): The swimmer's name, the pool length shown (25 or 50 m) and the season start date, plus the list of strokes (up to 5) and distances (up to 4).
  • «السباقات» (Races): One row per swim: date, meet or training session, stroke, distance and pool length from the lists, the time in three cells (minutes, seconds and hundredths) and, optionally, the first-half split. It calculates the total time, the 100 m pace, the second-half time and the split type. It holds 800 swims.
  • «الأرقام الشخصية» (Personal bests): For each stroke and distance in the pool length shown: number of swims, personal best, its date and its 100 m pace, the previous best and the improvement, the season best and the latest race, with a "new personal best" alert and a stroke-by-distance grid at the bottom.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

Enter each swim once and get the time, the 100 m pace, your personal best and your improvement over the previous best, so you can see whether you are really getting faster instead of comparing times from memory or from loose papers.

How to use it

  1. In the «الإعدادات» (Settings) sheet, enter the swimmer's name, the pool length (25 or 50 m) and the season start date, and review the lists of strokes and distances.
  2. In the «السباقات» (Races) sheet, log each swim in one row: the date, the meet or training name, and the stroke, distance and pool length from the lists.
  3. Enter the time in three cells: minutes, then seconds, then hundredths, so 1:05.40 is entered as 1, 5 and 40. The first-half split in seconds is optional.
  4. The grey columns calculate the total time and its written form, the pace per 100 m, the second-half time and the split type.
  5. Open the «الأرقام الشخصية» (Personal bests) sheet to see, for each stroke and distance, the personal best and its date, the season best, the number of swims and the improvement, plus the grid at the bottom.
  6. Change the pool length in «الإعدادات» to switch the personal bests between a 25 m and a 50 m pool, and check the "تنبيه" (Alert) column in «السباقات» for any incomplete row.

Before you start:

  • Personal bests are calculated separately for each pool length, so a 25 m time is not compared with a 50 m time. An empty pool cell takes the length set in «الإعدادات» (Settings).
  • If the same fastest time is swum twice, the personal best keeps the date of the first time, and the "new personal best" alert appears if the latest race equals the personal best.
  • Improvement = previous personal best - current personal best, in seconds. It is blank if the first race is your only time.
  • Pace per 100 m = total time / distance x 100, and the half split needs the first-half time. "Negative" means your second half was faster.
  • If two races fall on the same day with the same stroke and distance, the higher row is treated as the more recent.
  • The sheet holds 800 swims, five strokes and four distances for one swimmer; do not delete a row from the middle of the list. The sheet is for personal tracking, not training or medical advice.

Excel file (.xlsx) · 295 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

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)Cheat sheet: swimming times (2/3)Cheat sheet: swimming times (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

How do I calculate the time per 100 m in swimming?

Enter the time and distance in the «السباقات» (Races) sheet and it calculates it for you: 100 m pace = total time / distance x 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 under minutes, 5 under seconds and 40 under hundredths. Do not enter more than 59 seconds. The sheet shows the total time in seconds with its written form beside it.

Are times from a 25 m pool compared with times from a 50 m pool?

No. The sheet calculates personal bests separately for each pool length, so you choose the pool length shown in «الإعدادات» (Settings) and switch between the two. An empty pool cell in a race row takes the length set in the settings.

Can the sheet replace a coach or doctor?

No. The sheet is only a record of your times. It is not a training program or medical advice. Follow your coach's guidance, and see a doctor if you feel pain or have an injury.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Gyms and fitness

More free templates

All templates · Free tools