Skip to content
Swim Training Log cover: a sample sheet with sessions logged, total distance (m) and hours in the pool and a bar chart, beside the Dashboard and Sessions tabs

Swim Training Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This log suits swimmers who train in a pool and want to track distance and speed by stroke. The Sessions tab records each swim as a line, with the date, stroke (freestyle, backstroke, breaststroke, butterfly or mixed), distance in meters, time in minutes, seconds per 100 meters and notes. The Dashboard sums your distance and time in the water, finds your fastest pace, and charts distance and best pace for each stroke.

Time a repeat distance every month, so seconds per 100 meters stay fair to compare across months. Enter the total time for the swim itself, not the rest between sets. Mixed sessions go under mixed. A warm-up lowers the average, so log the main set on its own row if you want a clean pace figure. Use the notes column for the pool length and the focus of each session.

Useful for

  • Tracking base distance across a winter swim season
  • Comparing freestyle and backstroke pace over a month
  • Logging laps for a masters swim team

What's included

  • 3 tabs: Dashboard, Sessions, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Sessions: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sessions tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What does seconds per 100 meters mean?

It is the time it takes to swim 100 meters at your average pace in that session. A figure of 120 means two minutes per 100 meters, and lower numbers are faster. Formulas derive it from the time and distance you enter, so only those two values need typing.

Should I log warm-up and cool-down swims?

Yes, if you want the weekly total to match the time you spent in the pool. For pace, log the main set separately, since easy warm-up lengths pull the average down. Add a note such as 'with warm-up', so you know what each figure includes.

How do I log a pool length in yards?

Enter the distance in yards and change the distance header to show yards, and the pace becomes seconds per 100 yards. Stick to one unit throughout the log, or the Dashboard sums will not add up.

  • #fitness-tracker
  • #swimming-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More fitness tracker templates

See all 16

Also in Business operations

All business operations templates
Get this template

Preparing your template…