Skip to content

Program template

Google Sheets workout program template: a layout that holds up at 20 clients

A spreadsheet is a fair place to run a coaching business, if the layout is strict. This page gives the tabs, the columns, the validation and flag rules, and the signs that the sheet has done its job.

By RaiNGE product teamUpdated 11 min read

Written for coaches who program in a spreadsheet and want a clean sheet layout that stays usable at 20 clients.

Jump to the weekly template

Short answer

A usable Google Sheets workout program template has five tabs: Clients, one Program card per client, a Log, Templates, and Review. Use one row per exercise slot, restrict RPE, pain, and Done with validation, and add three flag rules: RPE above target, pain of 3/10 or more, and a missed session.

  • Strict columns and dropdown lists matter more than clever formulas.
  • Name every client tab with a code, never a name or a condition.
  • Copy the card forward and change one variable a week, so every change is easy to see.
  • When two copies of one program exist, the sheet has stopped being your system.

Answer a short intake and get one drafted workout as a PDF to set beside your own card. Get a free sample workout

On this pageThe five tabs and the columns on each

The five tabs and the columns on each

Build the sheet around one rule: a fact lives in one place. The coach edits the Program card, the Log records what happened, and Review reads the Log. This also works in Excel.

The five tabs, what each one holds, and who edits it.
TabWhat it holdsWho edits it
ClientsOne row per client: client code, start date, goal in the client's words, equipment, training days, pain notes (location and score, not a diagnosis), current block, statusCoach only
Program card (one per client)The current block as one row per exercise slot, using the same six slots every day: squat, hinge, push, pull, carry, trunkCoach edits, client views
LogOne row per exercise per session: what was done, how hard, and any painCoach, or the client in the client's own copy
TemplatesYour two or three master cards, a list of every exercise name you use, and a swap list per slot for equipment gapsCoach only, protected
ReviewA four-week check per client that reads the Log: completion, RPE against target, pain, and the next decisionCoach only
The five tabs, what each one holds, and who edits it.
Column definitions. The Program card uses the first eight; the Log adds Date, Client, Done, and Pain.
ColumnHoldsFormatExample
DayWhich session of the weekDropdown: Day 1, Day 2, Day 3Day 1
SlotThe movement patternDropdown of the six slotsHinge
ExerciseThe exact exerciseDropdown from the Templates listDumbbell Romanian deadlift
SetsNumber of working setsWhole number, 1-103
RepsTarget reps or a rangePlain text, because ranges are allowed8-10
LoadWeight per set, in kg with the unit in the headerNumber, 0 or more16
RPETarget effort on the card, effort felt on the LogNumber, 1-10, halves allowed7
NotesThe cue you would say on the floorFree text, one lineStop the range just above the point the back rounds
DoneLog only: did the client finish the rowDropdown: Y or NY
PainLog only: pain on this exercise, 0-10Whole number, 0-102
Column definitions. The Program card uses the first eight; the Log adds Date, Client, Done, and Pain.

Keep the columns in this order on every tab and never merge cells, because merged cells break sorting, filters, and formulas. The program card CSV has the first eight columns with one row per slot, ready to paste into a new tab.

One day of a Program card, filled in

This is one tab of a client's card with Day 1 filled in. It is an example layout for a general-fitness client with a few months of training, not RaiNGE data and not a prescription. The six slots match the personal training program template. Keep the rules under the card on the Templates tab.

Program card tab, client C014, block 2, week 3 of 4

Day 1 of three, filled in. Loads are in kg with pounds in brackets. Each slot is one row with sets × reps, load, target RPE, and a floor cue.

Day 1

Full body A

Notes for the day: warm up the hips and shoulders for five minutes before the first set

Squat: goblet squat
3×10 · 20 kg (44 lb) · RPE 7 · note: heels down, elbows inside the knees
Hinge: dumbbell Romanian deadlift
3×8-10 · 2 × 16 kg (35 lb) · RPE 7 · note: stop the range just above where the back rounds
Push: incline dumbbell press
3×8-10 · 2 × 14 kg (31 lb) · RPE 7 · note: forearms vertical at the bottom
Pull: seated cable row
3×8-10 · 37.5 kg (83 lb) · RPE 7 · note: pause for a second at the chest
Carry: farmer carry
3×30 m · 2 × 20 kg (44 lb) · RPE 7 · note: ribs down, walk tall
Trunk: dead bug
3×8/side · bodyweight · RPE 6 · note: low back stays on the floor

When to adjust

A clean week: every row marked Done, RPE at or under target, pain 0-2/10 and familiar
Change one variable next week: a rep, or add 2.5 kg (5 lb) once the top of the rep range is met on every set
Readiness 70% or more
Train as planned
Readiness 60-69%
Trim: drop a set or cut load 5-10%
Readiness under 60%
Cut: drop a set, cap effort at RPE 7, and lengthen rest
Pain 0-2/10 and familiar
Continue and monitor
Pain 3-5/10
Reduce load or range first, then adjust the setup, then change the exercise
Pain 6-7/10
Stop the movement that provokes it and choose a conservative alternative
Pain above 7/10, or sharp, worsening, radiating, or unfamiliar pain
Stop loading and refer to a qualified professional
No equipment for a slot
Use the swap list for that slot on the Templates tab, and write the swap in Notes

The pain score guide and readiness guide explain each band. Double progression covers choosing the one variable to change.

Validation lists and flag rules to set up once

Validation stops the typos that make a sheet unreadable later, such as "Y", "y ", and "yes" in one column. Set it on the whole column, not just today's rows. Use a hard stop where one value is legal, and a warning where an exception is possible. Excel calls these Stop and Warning, and Google Sheets words them differently, so check your own version.

What to restrict, how strictly, and why.
ColumnRestrict toAlert styleWhy
SlotThe six slots from a listStopReview groups by slot, so a seventh spelling breaks the count
ExerciseThe exercise list on the Templates tabWarningOne name per exercise, but a new exercise should still be possible
RPEA number from 1 to 10StopA typed 70 or a text note in this column breaks the flag rule
DoneY or N onlyStopA completion count is only as good as the letters it counts
PainA whole number from 0 to 10StopPain flags need a number, and the location goes in Notes
LoadA number of 0 or moreStopUnits live in the header, so the cell never holds "20kg"
What to restrict, how strictly, and why.
Conditional formatting rules, described in words. Build each as a custom rule applied to the whole column.
FlagRule in wordsColor
RPE above targetHighlight the Log RPE cell when it is above the target RPE for that slot on the cardAmber
Pain 3-5/10Highlight the Pain cell when it is 3, 4, or 5Amber
Pain 6-7/10Highlight the Pain cell when it is 6 or 7Red
Pain above 7/10Highlight the whole row when Pain is above 7, and read the row before you read anything elseDark red
Missed sessionHighlight the row when the planned date has passed and Done is emptyGrey
Conditional formatting rules, described in words. Build each as a custom rule applied to the whole column.

The pain tiers start at 3/10 because that is where the pain bands first change what you do. A formula cannot see sharp, worsening, radiating, or unfamiliar pain, so write it in Notes and read the row. The simplest completion formula is =COUNTIF(range,"Y"), which counts the Done cells marked Y. Divide it by the number of planned rows for a completion rate. Test every formula in your own sheet before you trust it.

A weekly routine: copy forward, change one thing, log

Name tabs and files by code: client code, then the document, then the block and week. "C014 Card B2W3" tells you the client, the file, and the week. Do not put a name, a condition, or a body part in a file name.

  1. 1

    Read last week's Log rows for the client

    Sort the Log by client and date. Read the highlighted cells first, then check every row is marked Y or N.

  2. 2

    Decide the one variable

    If the week was clean, choose a rep, a load, a set, or a slower tempo. If a flag fired, hold the week or follow the pain and readiness rule on the card.

  3. 3

    Copy the card forward

    Duplicate last week's card tab and rename it with the next week code.

  4. 4

    Change the cell and note why

    Edit only the planned cell, then write the reason in Notes with the date. If your plan keeps version history, it shows what changed, and the note shows why.

  5. 5

    Send the client the new tab and log what comes back

    Share only that client's card. After each session, enter Done, RPE, and Pain.

Example: client C014 finished week 2 with every seated cable row set at 10 reps and RPE 7, which is the top of the 8-10 range. Nothing was highlighted. The coach duplicates the tab as "C014 Card B2W3", changes the row load from 35 kg (77 lb) to 37.5 kg (83 lb), leaves everything else as it was, and writes "+2.5 kg, 3 Nov" in Notes. If the client reports RPE 9 at the new load, the next card returns to 35 kg (77 lb).

The four-week review block, one row per week on the Review tab.
WeekCheck on the Review tabDecision
Week 1Completion and the first RPE against targetFix any target that was clearly wrong, and change nothing else
Week 2Which rows went unflagged and finished at the top of the rep rangeProgress those rows by one variable and hold the rest
Week 3Pain cells, RPE above target, and missed sessionsHold, trim, or progress each slot following the rules on the card
Week 4Week 1 loads against week 4 loads, slot by slotChoose the next block, or a lighter week; the deload week guide covers when
The four-week review block, one row per week on the Review tab.

A privacy checklist for client data in a spreadsheet

One client's pain history and body measurements are health information, and a shared link is the easiest way to leak them. Local privacy rules apply to health details, and this page is not legal advice. This checklist covers common setup mistakes. Menu names and defaults differ by app and account type, so check each setting in your own account.

Set this up before the first client goes in

  • General access is restricted on every file, so a link should work only for people you added by email.
  • Each client has their own file or folder, so a link to one client's card does not open another client's tab.
  • Clients get view-only access to the card, and any log they fill in is their own copy.
  • File and tab names use client codes only: no names, no conditions, and no body parts.
  • The Clients tab, which links codes to people and holds pain notes, sits in a separate coach-only file.
  • Only coaches who need a client have edit access to that folder, and the access list is rechecked each quarter.
  • The Templates tab is protected, so a stray edit cannot change every client's exercise list.
  • When a coach leaves: transfer ownership of every file before closing the account, remove the coach's access, and turn off any link that was open.
  • Downloaded copies of the sheet, such as a CSV on a laptop, are deleted when a client leaves.

What to do at 10, 20, and 40 clients, and when to stop

How the layout behaves as the roster grows. These are rough markers, not thresholds.
RosterThe sheet still works whenIt starts to strain whenWhat to do about it
10 clientsYou are the only editor and most clients run the card as writtenYou hold flags in your head instead of reading the highlighted cellsUse the flag rules from day one, with one file per client
20 clientsValidation and naming are strict, and you read Review each weekYou copy a card forward by hand and miss a changed cell, or a client has two cards openProtect the Templates tab, retire old tabs after each block, and schedule the weekly routine
40 clientsOne person holds the whole system and rarely goes on leavePain reports across clients can only be seen by scanning, or a second coach needs accessSplit by coach or by group, give each coach their own sheet, or look at software
How the layout behaves as the roster grows. These are rough markers, not thresholds.

Signs this layout is straining

  • One client has two Program card tabs open, and the Log rows point at the wrong one.
  • You skipped the Review tab two weeks running.
  • A pain flag sat in a Log you did not open until the next session.
  • Copying the card forward broke a formula, and a client told you before you saw it.
  • A second coach needs the Clients tab to cover you, and you cannot share it without sharing every client.

One sign is a reason to tighten the sheet. For the roster-level thresholds that say when to compare tools, and what to keep when you switch, use the spreadsheet vs software comparison.

If you do compare tools, RaiNGE is one of them, in private beta. Drafts start from client context: goals, training history, equipment, schedule, injury and pain notes, and readiness check-ins. A coach reviews, edits, and approves each program before it reaches the client, and a readiness check-in can create a pending adjustment that changes nothing until the coach approves. See personal training programming software for the details.

Common questions

How do I stop clients editing their own program tab?

Share the client's file as view-only, and protect the Program card range so only you can edit it. Give the client a separate place to record sessions, such as their own copy of the Log or a form that writes to a sheet you control. Test the link in a private window.

Should each client get a separate file or a separate tab?

A separate file per client is safer, because sharing is set per file and one client's link opens only that client's file. Tabs in one workbook are quicker to build, but everyone with access sees every tab. Use tabs only in a workbook you never share.

Why do formulas break when I copy the card forward?

Copied tabs can keep references that point at the old tab or at a fixed range that no longer matches. After copying, click one formula cell and read its range. Prefer full-column ranges on the Log and Review tabs, and keep a test client whose answers you know.

Can I see pain trends across all my clients in one view?

Only if every client's Log rows sit in one place with a client code on each row. Then a filter on Pain of 3 or more, sorted by date, gives the cross-client scan. If clients keep their own files, you must copy their rows in first, and that step is where reports get missed.

Next step

Answer a short intake and get one drafted workout as a PDF to set beside your own card.