Free Workout Templates for Personal Trainers (Excel + Google Sheets)
Workout Template for Personal Trainers: What's Inside
The workbook has two linked tabs. Clients is your roster: one row per paying client with their goal (weight loss, muscle gain, strength, general fitness, rehab, sport performance), program type, and start date - up to 60 clients.
Programs is where you log training: client name, exercise, week, sets, reps and weight per session, up to 300 rows across all your clients. Type the client name exactly as it appears on the Clients tab and every session rolls up automatically.
Multi-Client Roster with Goals, Program Type and Progress at a Glance
Most free workout spreadsheets - including the round-up of Google Sheets templates trainers find most often - are single-client static sheets: one file per person, no shared roster view. That works for a solo client but breaks down the moment you're running programs for 10, 20 or 40 people at once.
This template's Clients tab solves that: sessions logged and total volume pull automatically from the Programs sheet for every client, using COUNTIF and SUMIF against the client name column. Open one file, scroll the roster, and see who's active and how much training volume they've logged - no separate spreadsheet per client, no manual counting.
Automated Volume and Progressive-Overload Tracking (Sets x Reps x Weight)
Every logged session calculates its own training volume - sets times reps times weight - the moment you enter the three numbers. None of the free single-client Google Sheets templates trainers commonly find calculate this automatically; you'd normally do that math by hand or build the formula yourself.
Because volume rolls up per client on the Clients tab, you can see at a glance whether a client's total logged volume is trending up week over week, which is the practical, spreadsheet-native version of progressive-overload tracking without a dedicated coaching app.
A Free Alternative to Paid Brandable Program Bundles
At least one established fitness-education site sells a branded, white-labeled 12-program bundle for $169 (discounted to $31) specifically because assembling a professional, multi-client program from scratch is tedious. This template gives you the automated, formula-driven multi-client structure for free - you supply your own branding in the cells.
It's a working spreadsheet, not a static PDF pack: every roster rollup and every session's volume recalculates the moment you type a new number, so the file stays useful session after session rather than becoming a one-time handout.
How to use it
- Add each client to the Clients sheet: name, goal, program type, start date.
- Log every session on the Programs sheet with the exact same client name, plus exercise, week, sets, reps and weight.
- Check the Clients sheet for automatic sessions-logged and total-volume rollups per client.
- Check the summary rows below each table for active clients, total sessions and total volume across your whole roster.
Download the free Free Workout Templates for Personal Trainers (Excel + Google Sheets)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
How many clients and sessions can this template handle?
Up to 60 clients on the Clients sheet and up to 300 logged sessions on the Programs sheet across all of them combined.
Why don't my client's sessions show up in the rollup?
The client name must be typed exactly the same way on both sheets - the rollup matches on exact text, so "Jane Doe" and "jane doe" or "J. Doe" won't match each other.
Does this work in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. Every rollup formula carries over and calculates the same way.
Can I use this for online or remote coaching clients, not just in-person?
Yes. The Programs sheet only needs client name, exercise, sets, reps and weight per session - it doesn't care whether the session happened in your gym or was reported to you remotely.
Is this medical or injury advice?
No. This template organizes program design and tracks logged training volume - it is not medical advice and does not replace a qualified assessment of a client's health, injuries or physical limitations.
What's the usage license?
Personal use or use within one training business. It's not meant to be resold or redistributed as a template product.