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 templateAnswer 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.
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.
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
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
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
Copy the card forward
Duplicate last week's card tab and rename it with the next week code.
- 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
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).
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
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.