Personal Trainer Client Tracker V3, Coaching Spreadsheet, Workout Log, Google Sheets & Excel

PERSONAL TRAINER CLIENT TRACKER V3

A structured 1:1 coaching spreadsheet built for personal trainers who want one place to organize client information, log workouts, monitor training progress, review weekly feedback, track coaching decisions, and analyze monthly performance and adherence.

PT Tracker V3 goes beyond a basic workout log by connecting training data, client adherence, recovery, progress, feedback, coaching adjustments, and monthly review in one structured system.

WHAT’S INCLUDED

CLIENT CARD
• Client profile and program information
• Planned sessions, completed sessions and overall program consistency
• BMI and Lean Body Mass calculations
• Body Fat % and Muscle Mass % input fields
• Physical limitations and main goal
• Starting vs current 1RM progress snapshot
• Coach notes and planned changes
• Start, Checkpoint and Current client progress photos

CLIENT WORKOUT LOG
• Date, program phase and workout split
• Exercise, sets, reps and load/body weight
• Automatic training volume calculation
• Estimated 1RM
• Rest time tracking
• Coach notes and exercise modifications
• Volume distribution chart

PROGRESS OVERVIEW
• Track selected key lifts across multiple weeks
• Weight and reps trends
• PR tracking
• Quality of execution
• Quality of rest between sets
• Coach notes

CLIENT WEEKLY CHECK-IN
• Sessions completed
• Weekly consistency
• Total weekly training volume
• RPE and top lift of the week
• Recovery quality
• Soreness and stress levels
• Average sleep and energy level
• Weekly Score
• Client feedback
• Coach review and next coaching focus
• Weekly volume trend

COACHING ADJUSTMENTS
Turn client data into documented coaching decisions.

• Track client issues and coaching adjustments
• Record the decision and reason for each change
• Define expected outcomes
• Record whether the adjustment worked
• Track client response and next-week focus
• Total Adjustments
• Successful Adjustments
• Adjustment Success Rate
• Most Adjusted Area
• Suggested Weekly Action

MONTHLY REVIEW
• Total sessions completed
• Monthly consistency
• Total monthly training volume
• Average weekly RPE
• Average recovery quality
• Average energy quality
• Monthly volume comparison
• Weight and reps comparisons for selected exercises
• Monthly adherence tracking and trend chart

Historical monthly tables are designed to be updated as the coaching process progresses, creating a clear month-by-month record for each client.

FILES & VERSIONS INCLUDED

✓ Google Sheets
✓ Microsoft Excel
✓ Example Version
✓ Clean Version
✓ DOT Version
✓ COMMA Version
✓ Professional How-to Guide with clickable Google Sheets access links

Example Version: explore a completed tracker first to understand the workflow and formulas.

Clean Version: start with a fresh tracker for your own client.

DOT OR COMMA?

Choose the version that matches your spreadsheet’s regional settings:

DOT: decimal point format, for example 75.5
COMMA: decimal comma format, for example 75,5

HOW TO USE

Choose the correct DOT or COMMA version.
Open the Example Version first.
Create your own personal copy of the tracker.
Use the Clean Version for your client.
Complete the Client Card.
Log client workouts and performance data.
Review weekly check-ins and coaching adjustments.
Use the Monthly Review to monitor longer-term progress and adherence.

Create a separate copy for each client you manage.

GOOGLE SHEETS & EXCEL

Google Sheets is recommended for the intended tracker experience.

Editable cells only: Fill in the designated input areas only. Formula cells, summaries, and charts are protected to prevent accidental changes.

Excel versions are also included for customers who prefer Microsoft Excel. Some spreadsheet behavior may vary depending on software version and regional settings.

CLIENT DATA & PROGRESS PHOTOS

Client progress photos are optional. Only upload or store client photos and personal information when appropriate and with the client’s permission. You are responsible for managing client information in accordance with your professional requirements and applicable privacy rules.

IMPORTANT

• This is a digital spreadsheet product. No physical item will be shipped.
• This tracker does not automatically create a workout or coaching program.
• Body Fat % and Muscle Mass % should be entered from appropriate external measurements when available.
• Lean Body Mass % is calculated from the entered Body Fat %.
• Outputs and calculations depend on the accuracy of the data entered.
• This tracker is an organizational and analysis tool and does not replace professional, medical, or individualized training judgment.

LICENSE

You may use this tracker to manage your own 1:1 coaching clients.

The files may not be resold, redistributed, shared as a template, reproduced for resale, or distributed for team-wide use.

Need help?

If you have any questions about accessing the files, choosing the correct version, or setting up your tracker, feel free to message me through Etsy.

ClarityFrameworksCo