Google Sheets for Personal Trainers (Free Client Template)

Most personal trainers don't need coaching software. They need a program their clients can actually open, a way to see what got done, and to not spend Sunday night rebuilding the same plan for the fourth time.

Google Sheets does all three — for free, on every phone — provided you set it up like a coaching system rather than a document. Here's how trainers actually run a roster out of Sheets, and the free template that skips the setup.

Why trainers land on Sheets rather than Excel

Excel is the better spreadsheet. Sheets is the better coaching spreadsheet, for three reasons that have nothing to do with formulas:

• Sharing is a link, not an attachment. Send it once. Every change you make is what the client sees next time they open it. No "v3_FINAL.xlsx" in an email thread.
• It's already on their phone. The free Sheets app opens the same file, so the client logs a set on the gym floor and it's in your copy before they've racked the bar.
• It's free for both of you. No licence for you, nothing to buy for the client.

The math is identical either way. Our templates are built in Excel, and the percentage logic imports into Sheets untouched — we walk through that conversion in the free Google Sheets workout template guide.

Set it up: one file per client

The instinct is to make one workbook with a tab per client. Don't — the moment you share a link, that client can see every other client's numbers, weights, and body weight log.

One file per client, built from the same master:

1. Build the master once. Set your logic — the percentages, the progressions, the exercise library. This is the only time you do real spreadsheet work.
2. Copy it per client. In Drive, right-click the master and choose Make a copy, then rename it to the client's name.
3. Enter their numbers. Their goals and working maxes go in the input cells; the program fills itself in.
4. Share the copy. Share → send the link with edit access so they can log what they did.

Adding a client is now a 60-second job instead of a program build.

Make the sheet worth opening

A program a client doesn't open isn't a program. Two things move that needle more than anything else:

Put a "did it" column next to the "do this" column. Prescribe 4×8 at 165, and leave the cell beside it blank for what they actually hit. That single column is what turns the sheet from a handout into a record.

Keep the current week at the top. Clients scroll about as far as they scroll a menu. If week 6 is the one that matters, week 6 goes first.

The sheet's job is to make the next session obvious in under five seconds. Anything that takes longer to read is decoration.

The check-in this makes possible

Because the file holds both what you prescribed and what the client did, a check-in stops being a conversation about how they feel and becomes a comparison of two columns.

You can see the sessions that got skipped, the lift that stalled three weeks running, and the accessory work that quietly got dropped. Then the next block gets written off evidence instead of memory — and the client sees the same progress you do, which is most of why people renew.

Where Sheets stops being enough

Being honest about the ceiling: a spreadsheet has no reminders, no exercise video, no way to see at a glance which of 40 clients trained this week, and no history beyond what you remember to keep. Under roughly a dozen clients, none of that matters and Sheets is the right call. Past that, the admin starts eating the coaching, and that's the point to look at TeamBuildr — same max-based logic, built to run a roster.

Until then, the spreadsheet genuinely is enough.

Get the free template

Skip the master build. The free personal training templates for Excel & Google Sheets carry the client goal fields, body weight and mood tracking, the cardio log, and the custom set and rep builder — download it, upload it to Drive, open it with Sheets, and copy it per client. Or browse all four free templates if you're programming teams as well as individuals.