How to Build a 12‑Week Training Plan for a 200 km Road Race (Free Spreadsheet Included)

If you’ve ever stared at a 200 km race flyer and felt your heart skip a beat, you know the first question that pops up: “How on earth do I train for this?” The answer is a solid plan that builds you up week by week, and the good news is you don’t need a PhD in exercise science to create one. In today’s post I’ll walk you through a simple 12‑week schedule, show you where to plug in your own numbers, and hand you a free spreadsheet that does the heavy lifting for you.

Why a Structured Plan Matters

Racing 200 km is not a sprint; it’s a marathon on two wheels. Without a plan you’ll either burn out early or finish feeling like you could have ridden another 50 km. A structured plan gives you three things:

1. Progressive overload – each week you add a little more stress, so your body adapts without crashing.
2. Recovery windows – built‑in easy days keep you fresh and lower injury risk.
3. Confidence – you know exactly what to do on any given day, so race day feels like the last piece of a puzzle you’ve already solved.

The Building Blocks

Before we dive into the calendar, let’s define the key workouts you’ll see in the plan.

Endurance Ride

Long, steady rides at a comfortable pace (usually 60‑70% of your max heart rate). Think “talking pace” – you could hold a conversation without gasping. These rides teach your muscles to burn fat efficiently and improve your mental stamina.

Tempo Ride

A step up in intensity, riding just below your threshold (about 80‑85% of max heart rate). You’re breathing harder, but you can still keep a short sentence together. Tempo work raises your lactate threshold, meaning you can go faster before fatigue sets in.

Sweet Spot

A sweet spot sits between endurance and threshold, around 85‑90% of max heart rate. It’s a bit uncomfortable, but you can sustain it for 20‑40 minutes. This zone gives you a lot of fitness for the time you spend on the bike.

Interval

Short bursts of high effort (90‑100% of max heart rate) followed by recovery. Intervals sharpen your speed and improve how quickly you can clear lactate from your muscles.

Recovery Ride

Very easy spin, under 55% of max heart rate. The goal is to move blood through tired legs without adding stress. Think of it as a “active massage.”

Step‑by‑Step: Fill the Spreadsheet

I’ve built a simple spreadsheet that you can download from the Pedal Pursuits site. It has columns for:

• Week (1‑12)
• Day (Mon‑Sun)
• Workout Type
• Target Duration or Distance
• Intensity Zone (Endurance, Tempo, Sweet Spot, Interval, Recovery)
• Notes (how you felt, gear, weather)

Here’s how to use it:

1. Print or open the file – I keep a printed copy on my kitchen fridge. Seeing the plan in plain sight makes it harder to skip a day.
2. Enter your baseline – In week 1, set the long ride distance to something you can already do comfortably (maybe 80 km). The spreadsheet will automatically suggest a 10‑15% increase for the following weeks.
3. Adjust for life – If a work trip or a family event pops up, move the “Rest” day to another slot. The plan is flexible; just keep the total weekly load roughly the same.
4. Track effort – After each ride, jot a quick note: “Felt strong on hills” or “Cold wind made it tough.” Over time you’ll see patterns that help you tweak the plan.

The 12‑Week Calendar

Below is a sample layout. Feel free to copy it into the spreadsheet or use it as a mental guide.

Weeks 1‑4: Base Building

• Mon: Rest or easy spin (30‑45 min, Recovery)
• Tue: 1‑hour Endurance ride
• Wed: 45‑min Sweet Spot (2×20 min blocks)
• Thu: 1‑hour Endurance ride
• Fri: Rest
• Sat: Long ride (start 80 km, add 10 km each week)
• Sun: Recovery ride (45 min, very easy)

Weeks 5‑8: Adding Intensity

• Mon: Rest
• Tue: 1‑hour Tempo ride (3×12 min blocks)
• Wed: 1‑hour Endurance ride
• Thu: 1‑hour Sweet Spot (3×15 min blocks)
• Fri: Rest
• Sat: Long ride (120‑150 km, keep the 10‑15% increase rule)
• Sun: Recovery ride or optional short spin

Weeks 9‑11: Race‑Specific Sharpening

• Mon: Rest
• Tue: 1‑hour Interval session (5×3 min at high intensity, 3 min easy)
• Wed: 1‑hour Endurance ride
• Thu: 1‑hour Tempo ride (2×20 min)
• Fri: Rest
• Sat: Long ride (peak 180‑200 km, then drop back a bit in week 11)
• Sun: Recovery ride

Week 12: Taper

• Mon: Rest
• Tue: 45‑min Sweet Spot (1×20 min)
• Wed: 1‑hour Endurance ride (easy)
• Thu: 30‑min easy spin
• Fri: Rest
• Sat: 20‑km shake‑out ride (very easy)
• Sun: Race Day – 200 km

Tips to Keep You on Track

• Listen to your body. If you feel a nagging ache, swap a hard day for an extra recovery ride. The plan is a guide, not a law.
• Fuel early and often. Practice your race nutrition on long rides. A mix of carbs (like a banana or energy gel) and electrolytes works for most riders.
• Sleep matters. Aim for 7‑9 hours a night, especially after hard sessions.
• Bike fit is king. A comfortable saddle and proper handlebar height can save you from a sore backside that will ruin a long ride.
• Weather‑proof your plan. If a storm hits, move the long ride to the next clear day. Consistency over perfection.

Why the Free Spreadsheet Is Worth It

I’ve tried dozens of generic training templates, and most of them feel like a one‑size‑fits‑all t‑shirt – they either pinch or hang loose. My spreadsheet lets you set the starting point, auto‑calculates weekly increases, and gives you space for personal notes. It’s like having a coach in a spreadsheet, without the hourly fee.

Grab it from the Pedal Pursuits resources page, plug in your numbers, and you’ll have a clear roadmap from “I can’t even finish 100 km” to “I’m crossing the 200 km line with a smile.”

Happy training, and see you on the road!