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
| الأسلوب | المسافة (م) | عدد المرات | الرقم الشخصي | تاريخه | التحسن (ث) | أفضل زمن في الموسم | تنبيه |
|---|---|---|---|---|---|---|---|
| حرة | 50 | 3 | 0:29.60 | 46291 | 0.35 | 0:29.60 | رقم شخصي جديد |
| حرة | 100 | 4 | 1:04.85 | 46305 | 0.55 | 1:04.85 | |
| حرة | 200 | 3 | 2:21.95 | 46319 | 2.15 | 2:21.95 | |
| حرة | 400 | 2 | 4:59.80 | 46333 | 2.50 | 4:59.80 | رقم شخصي جديد |
| ظهر | 50 | 3 | 0:32.60 | 46333 | 0.30 | 0:32.60 | رقم شخصي جديد |
| ظهر | 100 | 2 | 1:11.95 | 46326 | 0.45 | 1:11.95 | رقم شخصي جديد |
| ظهر | 200 | 0 | |||||
| ظهر | 400 | 0 |
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
- 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.
- 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.
- 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.
- The grey columns calculate the total time and its written form, the pace per 100 m, the second-half time and the split type.
- 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.
- 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.
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.
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 sheet | In 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. |
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
- Gym memberships tracker (Excel)
- Strength workout log
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Basketball player game stats
- Martial arts and boxing training log
- Tennis and padel match log
- Athletics results and personal bests log
- Padel and 5-a-side court booking sheet (hourly)
- Ad budget media plan across platforms
- Ad campaign performance tracker
- Ads A/B test log
- Ads break-even and unit economics sheet
- Ad agency client management and reports
- UTM link builder and campaign naming
- Ad account audit checklist
- Ads creative production calendar





