All templates

Free Triathlon Training Plan in Excel

How many hours of each sport this week? The template works them out for every triathlete.

Enter their race distance, race date and the hours they train now. The Excel builds 12 weeks of swim, bike, run and strength up to their peak week, with two recovery weeks and a two-week taper.

Free, no sign-up

Triathlete in a helmet starting to run after racking her bike by a stone wall on the coast

triathlon training plan template excel What's in this template

Download a free 12-week triathlon training plan in Excel for sprint, Olympic or half distance: each week's swim, bike, run and strength hours are worked out for every triathlete, with their zones, bricks, a weekly log and a training load summary for your whole group.

Coaching triathletes? See how they get their plan in the client app

Work out your triathlete's run paces
  • One sheet for all your triathletes: distance, race date, current hours and test results
  • 12-week plan for sprint, Olympic or half distance, with recovery weeks and a taper
  • Swim, bike, run and strength hours for every week, worked out for each triathlete
  • A key session for each sport and a brick every week
  • Swim (CSS), bike (FTP) and run (threshold pace) zones
  • Weekly log: planned vs. done and training load (minutes × RPE)
  • Load summary: who is falling short and whose load is spiking
  • Works in Google Sheets

How the 12-week plan works

The plan starts from the hours your triathlete trains today and builds to a peak week set by their race distance. Hours climb gradually, weeks 4 and 8 are recovery weeks (75% of the week before) and the last two weeks cut volume so they arrive fresh on race day.

There are four phases:

  • Base (weeks 1 to 4). Swim technique, Z2 rides and runs, and general strength twice a week.
  • Build (weeks 5 to 8). Threshold work in all three sports: 200 m repeats at CSS pace, 10 to 20 minute Z4 blocks on the bike and 3 to 8 minute run intervals.
  • Specific (weeks 9 and 10). Everything at race pace: continuous swims, a long ride with the second half at race effort, and bricks with the run at race pace.
  • Taper (weeks 11 and 12). Fewer hours, a touch of race pace and the race on the final weekend.

Typical week: Monday off or a technique swim, Tuesday quality bike and strength, Wednesday swim and quality run, Thursday easy bike and strength, Friday swim, Saturday long ride or brick, Sunday long run. If your triathlete trains on other days, move sessions around, but don't put two hard sessions of the same sport back to back.

How many hours a week for a sprint, Olympic or half distance triathlon

On the Triathletes sheet you choose the distance and enter the hours per week they train now, swim, bike, run and strength combined. The suggested peak week aims for the distance's hours without going over 1.5 times what they train today:

  • Sprint (750 m, 20 km and 5 km): 6 hours in peak week. 25% swim, 40% bike, 30% run and 5% strength.
  • Olympic (1.5 km, 40 km and 10 km): 8 hours. 22% swim, 43% bike, 30% run and 5% strength.
  • Half distance (1.9 km, 90 km and 21.1 km): 11 hours. 18% swim, 50% bike, 27% run and 5% strength.

Example: an athlete training 6 hours a week for an Olympic race reaches 8 hours in week 10: 1:45 swim, 3:25 bike, 2:25 run and 25 minutes of strength, with a 1:45 long ride and a 1:05 long run.

These are guideline hours for an age-group triathlete. If you coach differently, change them on the Distances sheet or enter your own peak for each triathlete: the whole plan recalculates. If the peak lands below 75% of what the distance calls for, the template warns you: start earlier or pick a shorter race.

Swim, bike and run zones

Each sport uses its own test, entered on the Triathletes sheet. The Zones sheet works out five zones for the triathlete you pick:

  • Swim, CSS (critical swim speed): an all-out 400 m and 200 m with full rest in between. CSS per 100 m is the difference between the two times divided by 2: 7:20 and 3:30 gives 1:55. CSS pace is threshold pace, the pace of the 200 m repeats in the build phase.
  • Bike, FTP: 95% of average power for an all-out 20 minutes. The zones are Coggan's first five, from recovery (up to 55% of FTP) to VO2 max (106-120%).
  • Run, threshold pace: average pace over the last 20 minutes of an all-out 30-minute solo run. The zones are percentages of that pace, as Joe Friel lays them out.

Retest at the end of base and build and update the numbers: the zones update on their own. If your triathlete has no power meter, go by heart rate or perceived effort.

Bricks: bike and run back to back

Running off the bike is hard: the legs don't respond for the first few minutes and pace feels off. That's why the plan has a brick every week, building through the phases:

  • Week 1: practice the transition itself, racking the bike, taking off the helmet and changing shoes, with no run.
  • Base: Z2 ride and a 10 to 15 minute easy run.
  • Build: a ride with Z3 or Z4 blocks and a 15 to 20 minute run, part of it at race pace.
  • Specific: bike and run at race effort, plus a race rehearsal at half of each distance.

Set up transition the way they will on race day: gear laid out, elastic laces and a bottle within reach. It's free time saved without training more.

Strength training for triathletes

Two sessions a week in base and build, one maintenance session in the specific phase and none in race week. The exercises in the plan, 3 x 8 to 12:

  • Goblet squat and step-up onto a bench or box.
  • Romanian deadlift, on both legs and on one.
  • Dumbbell or band row, for the back that swimming demands.
  • Calf raises with a straight and a bent knee.
  • Front and side plank.

Schedule strength on an easy day and never the day before the long ride or the long run.

One Excel file for all your triathletes

The template is built for a coach with several triathletes, not for an athlete training alone:

  • Triathletes: one row per triathlete with their distance, race, hours and test results. There's room for ten.
  • 12-Week Plan and Zones: pick one in the green cell to see their plan and zones.
  • Weekly Log: one row per triathlete per week with the hours done for each sport and the average effort (RPE 1 to 10). Load is minutes × RPE (Foster's session RPE).
  • Load Summary: each triathlete's last logged week. Amber flags anyone who did less than 80% of the plan; red flags a load jump of more than 15% from one week to the next.

The workbook comes with two sample triathletes and their first logged weeks. Delete their rows when you start with your own.

Sources

  • Wakayoshi K et al. Determination and validity of critical velocity as an index of swimming performance in the competitive swimmer. Eur J Appl Physiol. 1992;64(2):153-157.
  • Allen H, Coggan A. Training and Racing with a Power Meter. 3rd ed. VeloPress; 2019.
  • Friel J. The Triathlete's Training Bible. 4th ed. VeloPress; 2016.
  • Foster C et al. A new approach to monitoring exercise training. J Strength Cond Res. 2001;15(1):109-115.

Frequently asked questions

How many weeks does it take to train for a triathlon?

If your triathlete already swims, bikes and runs regularly, 12 weeks is enough for a sprint or Olympic race. For a half distance or a beginner, add a few low-volume base weeks first and start the plan once they train at least 5 or 6 hours a week.

How many hours a week do you train for a sprint triathlon?

Between 4 and 6 hours in peak week for an age-group triathlete. The template suggests 6 and never more than 1.5 times what they train now: from 4 hours today, the peak is 6.

Does it work for a full-distance triathlon?

No. The template goes up to half distance (1.9 km, 90 km and 21.1 km). Full distance needs more weeks, a different split of hours and more race-specific fueling work.

Does it work in Google Sheets?

Yes. Open Google Sheets, go to File > Import and upload the file: formulas, dropdowns and colors carry over.

How do I enter hours and times?

Hours as h:mm (1:30 is an hour and a half) and test times as h:mm:ss (7 minutes 20 seconds is 0:07:20). That way Excel reads them as time and adds them up correctly.

  1. A coach takes notes in the stands at a running track at dusk

    From spreadsheets to an app for personal trainers A spreadsheet keeps you organized. It won't grow your business.

    Every new client means another sheet, another PDF and another text. Your calendar is your ceiling.

  2. A trainer works alone on her laptop at the gym at dawn

    6:00 AM

    You split every triathlete's swim, bike and run hours, each one in their own spreadsheet.

  3. The trainer answers messages on her phone from the couch at night

    10:30 PM

    “Can't make it to the pool tomorrow. What do I swap?” It comes in by text.

  4. The trainer goes over a list of names in a notebook at the kitchen table

    Sunday

    You add up everyone's weekly hours by hand from screenshots of their watch.

  5. The trainer corrects a client's squat in bright morning light

    With TrainerStudio

    Every session on their phone, with its duration and zone. And you see if they did it.

App for personal trainers Train more clients in less time.

  • A client checks her workout on her phone at home

    Today's workout, in your app.

    Your clients open the session in an app with your brand, with a video for every exercise.

  • The trainer looks at her phone, relaxed, sitting in the gym

    See who trained without asking.

    You know how each client is doing without chasing anyone.

  • The trainer and a client high-five at the end of the session

    Payments collect themselves.

    Every month, by card. You get back to what really matters: coaching.

“…the trainerstudio App was a leap in quality for my product.”
@baumovment

For trainers and nutritionists only Using templates with your clients? Move them to an app with your brand.

TrainerStudio's weekly planner in the web app, open on a MacBook
TrainerStudio's business dashboard on an iPad, with monthly revenue and active clients
TrainerStudio's coach app on an iPhone, with a client's plan for the day

Train more clients in less time. Your clients train from their phones, you see every session and you get paid without chasing anyone. 12,000+ trainers already use it.

3 clients free forever · No card

Training on your own? Then you don't need TrainerStudio: the template is yours, free, with no account.