Workout Log: Training Tracker with Progress Charts and Personal Bests (Google Sheets & Excel)

Log every session in a few taps and see how your training is moving. This Google Sheets workout log turns your entries into progress charts, weekly summaries and personal bests, with no app, account or subscription needed.

How it works

1. Add a row for each exercise: pick it from the dropdown, then enter sets, reps and weight, or time and distance.
2. Open Progress and choose any exercise to see its history and chart.
3. Check Weekly for your last 12 weeks at a glance.

What it does for you

• Marks new personal bests as you log: heaviest weight, most reps, longest hold or longest distance
• Charts any exercise over time, by estimated 1RM, weight, volume, reps, time, distance or pace
• Calculates volume and estimated 1RM for strength sets, and pace for runs, rides and rows
• Summarises each week: workouts, entries, volume, cardio time, distance and new bests, with two charts
• Keeps a library of 34 exercises across legs, push, pull, core, cardio and mobility, with times logged, last done and bests for each; add your own
• Works in kg or lb and km or mi
• Checks each row and tells you if something's missing

What's inside

• Log: up to 2,000 entries with date, session, exercise, sets, reps, weight, time, distance, effort and notes
• Progress: exercise and chart selectors, summary tiles, personal bests, a chart of up to 52 entries and your 15 most recent sessions
• Weekly: a 12-week table with workouts per week and volume per week charts
• Exercises: your library with stats for every exercise
• Lists: units, categories and exercise types
• 12 weeks of sample entries so you can see how it works before you start
• A Start Here guide with set-up steps, what to enter for each exercise type and how to read your progress

Format

• Delivered as an .xlsx file. Upload it to Google Drive and save it as a Google Sheet; the Start Here guide walks you through it.
• Log from your phone in the Google Sheets app.
• Also opens in Microsoft Excel and LibreOffice Calc. No macros or add-ons.
• Instant digital download. No physical item is shipped.

Good to know

This is a tracking tool, not a training programme, and it doesn't give medical or fitness advice. Estimated 1RM is a standard approximation for tracking trends, not a target. Sample data is fictional and shown for illustration. If you have a health condition or an injury, check with a doctor before starting a new exercise routine.

Licence

Personal use. Make copies for yourself and share your own log with a coach or doctor. Reselling or sharing the template is not permitted. See the included licence (VX-HLTH-04) for full terms.

Google Sheets is a trademark of Google LLC and Microsoft Excel is a trademark of Microsoft Corporation. This product is not affiliated with or endorsed by either company.