October 15, 2026
7 Free Excel Templates for Personal Trainers (2026)
Ready-to-use spreadsheets for programming, clients, money, nutrition and business metrics, and how to know when you’ve outgrown them.
If you still run your training business on scattered notes, WhatsApp screenshots and memory, you’ve probably thought about setting something up in Excel. The problem is that building a well-structured spreadsheet from scratch takes hours, and once you finish, you realize you need five more to cover clients, programs, payments and follow-up.
This article is your shortcut: seven templates, each solving one area of your day. Six are free downloads from our templates library; for the seventh (business KPIs) we give you the exact columns to build it in 15 minutes.
1. Weekly workout programming
Ideal for: In-person and online trainers who program weekly or monthly.
The template you’ll use most. It lays out each client’s week from Monday to Sunday with room for strength and cardio work, training time and daily performance notes. Duplicate the sheet to create next week in seconds.
Tip
Use conditional formatting to turn a cell green when a client beats a previous best. It’s a small detail that clients love.
2. Macrocycle and periodization
Ideal for: Trainers working toward a goal date 12–52 weeks out.
The bird’s-eye view. A 52-week calendar with color-coded preparatory, competition and transition phases, mesocycle detail (goals, methods, volume) and weekly volume and intensity percentages. Essential for athletes, test candidates or anyone with a target date.
Tip
Start from the client’s target date (a race, a holiday, a fitness test) and work backward. Print it and keep it visible: the big picture helps you make better daily decisions.
3. Client tracking
Ideal for: Any trainer with more than 5 active clients.
A basic CRM built for trainers: a client list with contact details, plan and status, a summary of active clients, revenue and sessions, individual weight, adherence and sleep records, and payment tracking with upcoming payments. It works in Google Sheets too.
Tip
Start with name, start date, plan and renewal date; fill in the rest gradually. And protect the file: health data in an unencrypted shared spreadsheet is a privacy risk.
4. Income, expenses and invoicing
Ideal for: Self-employed trainers who need basic financial control.
Two templates that work together: an income and expense tracker (automatic totals, expenses by category, monthly summary with quarterly subtotals) and an invoice template with automatic tax calculations, an annual invoice log with sequential numbering and a quarterly summary.
Tip
Spreadsheets complement, but don’t replace, the invoicing and tax rules where you work. Check what your local tax authority requires for invoices.
Download the income and expense tracker and the invoice template.
5. Initial fitness assessment
Ideal for: Trainers who want a professional first session with new clients.
A printable A4 template (PDF) with anthropometry (weight, height, BMI, body composition), 7-site skinfolds, strength, endurance, flexibility and mobility tests, a postural assessment and space for observations. Pair it with a health questionnaire such as the PAR-Q+ before the first session.
Tip
Repeat the assessment every 8–12 weeks. Comparing results with the baseline is one of the best ways to show value and justify renewal.
6. Weekly diet plan
Ideal for: Trainers who give general nutrition guidance alongside training.
Nutrition targets for training and rest days, a weekly plan with 6 meals a day, daily calorie and macro tracking with an automatic weekly average, and adherence, water and hunger tracking. Use our macros calculator to set the starting targets.
Tip
Know your scope: in many places individualized clinical diets are reserved for registered dietitians. Stick to general guidance and refer out when in doubt.
7. Business metrics (KPIs)
Ideal for: trainers who want to make decisions on data instead of gut feeling.
If you don’t measure it, you can’t improve it. A simple monthly sheet is enough: one row per month and one column per metric.
- Active clients at month end
- New clients and cancellations
- Monthly recurring revenue and average revenue per client
- Leads received, discovery calls, proposals sent and clients signed
- Retention rate and average client lifetime
- Hours worked
Add two formulas: lifetime value (average monthly revenue per client × average months retained) and acquisition cost (marketing spend ÷ new clients). If lifetime value is at least three times acquisition cost, the business is healthy. On the first day of each month, spend 15–20 minutes filling in last month and ask: what went well, what didn’t and what will I do differently? Our guide to fitness business KPIs explains each metric.
Excel vs dedicated software: when to switch
Excel is incredibly versatile and these templates will save you hours. But it has real limits that show up as your business grows.
- You have more than 10–15 active clients and spend more time updating spreadsheets than coaching.
- Clients need to see their workouts and the only way is a PDF or screenshot. They can’t tick off exercises, log weights or send feedback.
- You chase payments by hand and sometimes miss one.
- Communication is scattered across WhatsApp, email, calls and paper notes, with no single history per client.
- You do things that could be automatic, like sending a new program or collecting the monthly fee.
| Job | Excel | Coaching software |
|---|---|---|
| Delivering workouts | Send a PDF or screenshot over WhatsApp | The client opens the app and sees an interactive workout |
| Logging loads and progress | You type it in after the session | The client logs it in real time from their phone |
| Monthly payments | Bank transfer + manual reminders | Recurring card payments |
| Client communication | WhatsApp, email, calls (fragmented) | Chat built into the platform |
| Progress history | Charts built by hand | Built from the client’s own logs |
| Exercise videos | Manual YouTube links | Built-in library with demos |
Outgrowing Excel? Try TrainerStudio
Workout programming, client tracking, forms, payments and chat in one platform, with a branded app for your clients. The free plan includes up to 3 clients, no credit card required.
Frequently asked questions
Do the templates work in Google Sheets?
Yes. The Excel templates are .xlsx files that open in Microsoft Excel, Google Sheets and LibreOffice Calc. Some advanced conditional formatting can look slightly different between apps, but the core features work everywhere.
Can I edit the templates?
Yes. Add columns, change formulas, adjust colors or adapt any section to the way you work. The more you tailor them, the more useful they become.
Are they really free?
Yes. You can download them from our templates library without creating a TrainerStudio account. We offer them because many trainers start with spreadsheets, whether or not they later use our platform.
How many clients can I manage with spreadsheets?
As a rule of thumb, spreadsheets work well up to 10–15 clients. Beyond that, the time you spend maintaining them starts competing with the time you spend coaching.
What about data privacy?
Spreadsheets aren’t encrypted by default and have no fine-grained access control. If you store client health data, password-protect the files, keep them in a secure cloud service and get your clients’ written consent to process their data under the privacy law that applies to you.
Conclusion: start with Excel, grow with software
These seven templates cover the basics of running a personal training business without spending money on software. They take you from chaos to a minimum viable system. When you need clients to log workouts in real time, recurring payments and one place for every conversation, it’s time for a tool designed for what you do.