App Tutorials

How to Track Your Child's Swimming Progress (Without a Spreadsheet)

By Fabio Verschoor•02 May 2025•5 min
How to Track Your Child's Swimming Progress (Without a Spreadsheet)

I used to track Rafa's progress in a spreadsheet. Pulling times from different websites, converting between short course and long course, realizing I had missed an entire meet's results. One night, staring at a mess of tabs and half-entered data, I thought: "There has to be a better way." That frustration is the reason Gophin exists.

Your child just swam a 1:12.34 in the 100 backstroke. Is that good? Is it better than last month? How does it compare to the qualifying standard for provincials?

If you are like most swim parents, you have no idea. And it is not because you do not care. It is because the information is scattered across half a dozen places, and nobody has made it easy to piece together.

Welcome to one of the most quietly frustrating parts of being a competitive swim parent: tracking progress.

The Problem: Times Are Everywhere and Nowhere

Here is what a typical swim parent's data landscape looks like. Meet results live on one website. The club might post times on a team app. Your child's coach may mention splits at practice but never write them down. You have a few photos of scoreboard screens on your phone. And somewhere in a kitchen drawer, there is a crumpled heat sheet from last month with a personal best circled in pen.

None of these sources talk to each other. None of them give you the complete picture. And when your child asks, "Am I getting faster?", you end up scrolling through old text messages trying to find the answer.

This is not a minor inconvenience. It is a real barrier to one of the most important things in youth sports: helping your child see and understand their own progress.

Why Tracking Matters More Than You Think

Tracking swimming progress is not about obsessing over hundredths of a second. It is about three things that genuinely affect your child's experience in the sport.

Motivation. When swimmers can see their improvement over time, mapped out clearly, it fuels their drive to keep going. A chart showing steady progress over six months is more motivating than any pep talk. Research by Prof. Robyn Jorgensen at Griffith University found that children who swim competitively develop stronger cognitive and academic skills — including the ability to understand structured feedback and track their own progress [1]. Kids are visual. Showing them the trendline of their work turns abstract effort into tangible evidence.

Identifying strengths and weaknesses. Maybe your child drops time consistently in freestyle but plateaus in backstroke. Maybe their short course times are strong but long course conversions lag behind. You cannot spot these patterns without organized data. And once you spot them, you can have informed conversations with coaches about where to focus training.

Catching plateaus early. Every swimmer hits plateaus. They are a normal part of development. A large-scale PMC study analyzing nearly 10,000 swimming years of data found that performance improvement rates drop from 9-10% per year at ages 8-10 to just 1-2% per year by ages 15-18, with females typically plateauing around age 14 and males around age 16 [2]. But a plateau that goes unnoticed for an entire season can lead to frustration, self-doubt, and even burnout. When you track progress consistently, you see the plateau forming. You can address it proactively, whether through technique adjustments, rest, or simply acknowledging it and managing expectations.

The Manual Approach: Notebooks and Spreadsheets

Some dedicated parents keep meticulous records. They maintain spreadsheets with columns for date, meet, event, time, and splits. They calculate improvement percentages. They build their own charts.

This works. It really does. If you have the time and the discipline to maintain it, a well-organized spreadsheet gives you total control over the data.

But let us be honest about the limitations.

Manual tracking requires you to find the results after every meet, enter them accurately, and keep the spreadsheet updated. Life gets in the way. A busy weekend, a missed meet, or a few weeks of procrastination, and suddenly you are three months behind. The spreadsheet becomes a guilt-inducing reminder sitting in your Google Drive.

There is also the problem of context. A spreadsheet shows you the numbers, but it does not automatically tell you how those numbers relate to standards, age group rankings, or season progression. You have to layer that context in yourself, and that requires knowledge most parents simply do not have.

The Modern Approach: Let Technology Do the Work

The good news is that tracking swimming progress no longer requires manual data entry. Modern tools can pull your child's times directly from official competition databases, organizing everything in one place automatically.

Instead of hunting through results websites after every meet, the data comes to you. Times, events, meets, personal bests, all updated and organized without you lifting a finger.

This is not about replacing the parent who loves their spreadsheet. It is about giving every parent, including the ones who barely have time to pack a meet bag, access to the same clarity.

What Should You Actually Track?

Whether you go manual or digital, here is what matters most when monitoring a young swimmer's progress.

Best times. The most fundamental metric. You want a clear, current record of your child's personal best in every event they swim. This is the baseline everything else is measured against.

Season progression. How are times trending within a single season? Are they dropping steadily, holding flat, or creeping up? Season-over-season comparison is where the real story of development lives.

Standards achievement. Most swimming organizations publish time standards that represent different levels of achievement. Tracking where your child stands relative to these standards gives both of you clear, motivating milestones to work toward. It also helps with meet selection and goal setting.

Splits. For longer events, splits tell you how the race was executed. Did your child go out too fast and fade? Did they negative split and finish strong? Splits add a layer of insight that finish times alone cannot provide.

Event breadth. Young swimmers should be developing across multiple strokes and distances. Tracking all events, not just the favorites, helps ensure balanced development and may reveal hidden strengths.

How Gophin Solves This

Gophin was built specifically to address the tracking problem that swim families face. It connects to official competition databases and automatically pulls in your swimmer's meet results, organizing them into a clean, visual dashboard.

Here is what that means in practice.

Automatic data. After your child swims a meet, their times appear in Gophin without you doing anything. No manual entry. No hunting through results pages. The data is simply there.

Best times at a glance. Gophin maintains a current record of personal bests across all events, updated automatically as new results come in.

Visual progress tracking. Evolution charts show how times are trending over weeks, months, and seasons. Your child can see their improvement laid out visually, which is both motivating and informative.

Standards comparison. Gophin maps your swimmer's times against published standards from over 38 organizations, so you always know where they stand and what the next milestone looks like. Full standards comparison across all organizations is available with Gophin Pro.

Meet history. Every meet, every event, every time, organized chronologically and by event. No more searching through old emails or scrolling through results websites.

The free version of Gophin gives you access to best times, meet history, standards reference, records, evolution charts, and limited rankings. For families who want deeper analysis, Gophin Pro at $5 CAD/month unlocks swimmer comparisons, full rankings, and standards comparison across all organizations.

The Bottom Line

Your child works hard in the pool. They deserve to see that work reflected clearly, not buried in scattered meet results and forgotten spreadsheets.

Tracking progress is not about adding pressure. It is about creating clarity. According to USA Swimming's 2024 demographic data, membership retention sits at just 66.9%, with the steepest dropout among 13-year-old girls and 17-year-old boys [3]. When swimmers and their families can see the trajectory of improvement, it transforms the experience of the sport. Bad races become data points, not disasters. Plateaus become identifiable challenges, not invisible walls. And personal bests become celebrations grounded in visible, undeniable evidence of growth.

You do not need to be a data scientist to track your child's swimming. You just need the right tool.

Start tracking free at gophin.app — no card needed.

Sources

  • 1. Jorgensen, R. et al. (2014). Griffith University study of 7,000+ children: swimmers 6-15 months ahead academically.
  • 2. PMC Backstroke Study (2006-2017). n=9,956 swimming years. Performance improvement rates by age: 9-10%/year ages 8-10, 5%/year ages 11-14, 1-2%/year ages 15-18. Females plateau ~14, males ~16.
  • 3. USA Swimming Demographics (2024). Membership retention 66.9%; worst dropout at age 13 girls and age 17 boys.
Fabio Verschoor

Fabio Verschoor

Founder & CEO, Gophin

Swim dad, computer scientist, and serial entrepreneur. When my daughter dove into competitive swimming, I combined my passion for sports and technology to build Gophin — so every family can track performance with clarity.

Track your swimming times for free

See all your PBs, meet results, and progress in one place. No card needed.

Start Free →

Related Articles

How to Track Your Child's Swimming Progress (Without a Spreadsheet) | Gophin Blog