Personal training client tracking spreadsheet: template and limits

The 3-tab template

Tab 1: Profile

Name, start date, main goal, target date, training days, equipment, injuries and limitations, and the date of the last program change. This is your intake form in short form (see our client intake form template).

Tab 2: Program

One row per exercise per session:

• Day (for example "Day A - Upper")
• Exercise
• Sets
• Rep range (for example 6-8)
• Target RIR
• Rest
• Notes (tempo, setup cues)

Tab 3: Log

One row per set:

• Date
• Day
• Exercise
• Set number
• Weight
• Reps
• RIR
• Notes

Keeping one row per set makes it easy to filter by exercise and chart progress. Writing "80 x 8, 8, 7" in a single cell looks faster but makes the data impossible to analyze.

Add a weekly summary

On a separate tab, track per week: planned sessions, completed sessions, best set on each main lift (weight x reps at RIR) and body weight if relevant. This is the view you look at during the weekly review, not the raw log.

The weekly review routine

Pick a fixed day. For each client:

1. Check adherence: completed vs planned sessions.
2. Check the main lifts: are weight or reps going up at a similar RIR?
3. Read their notes for pain, missed sessions or fatigue.
4. Write one sentence of feedback and one change, if needed.

Where spreadsheets break

Spreadsheets fail in predictable places:

• Logging in the gym. Editing a spreadsheet on a phone between sets is awkward, so clients log from memory later, or not at all.
• No previous numbers. Clients cannot easily see what they lifted last time, so they guess loads.
• No overview. To know who trained this week, you open every file.
• Broken formulas and versions. One wrong paste and the history is gone, or there are three copies of the program.
• No rest timer, no exercise images, no reminders.

If two or more of these hurt every week, the spreadsheet costs you more time than it saves.

Moving from a spreadsheet to an app

The data model stays the same: profile, program, log. An app just puts the log in the client's hand at the right moment and builds the overview for you. In GoHarder you rebuild your program once as a template with sets, reps and RIR targets, assign it, and clients log each set on their phone with the previous session's numbers on screen. Your dashboard shows who trained, personal records and volume over time for every athlete. It is free for up to 3 athletes, so you can move your first clients over and compare.