The Gym Personal Records (PR) Tracker in Google Sheets keeps every best lift you have logged on one screen – a live Total PRs Logged card, four charts that redraw as you type, and a 16-column register that works out your estimated one-rep max, your gain over the previous best, your strength ratio and your % to goal for you. It ships with 15 worked sample rows spread across six muscle groups so the logic is visible before you replace them. Part of a library of 2,000+ hand-built templates from NextGenTemplates, whose YouTube channels reach 300K+ subscribers. One-time $6.99, no subscription, unlimited devices, free lifetime updates – and if the copy link does not work for you, email us and we will fix it or refund you.Gym Personal Records (PR) Tracker in Google Sheets
Please read: this is a record-keeping sheet, not a coaching, medical or nutrition tool. It stores, totals and charts the numbers you type in. It does not write training programmes, recommend loads or reps, and it cannot judge whether a lift is appropriate for you. The Est. 1RM column is a well-known arithmetic estimate, not a measured maximum. Training and health decisions belong with you and a qualified coach or clinician.Gym Personal Records (PR) Tracker in Google Sheets
Key Features of Gym Personal Records (PR) Tracker in Google Sheets
- One Total PRs Logged card. A single large KPI on the left of the page that counts the rows in the register and moves the moment you add a lift.
- Four charts wired straight to the data. PR Count by Muscle Group, PR Count by Status, Est. 1RM by Exercise and Est. 1RM vs Goal 1RM. Each reads rows 16-1000 of the register directly using the built-in Aggregate option, so there are no hidden helper tables to repair when you add rows.
- A 16-column PR register. PR ID, Exercise, Muscle Group, Equipment, Best Weight, Reps @ PR, Est. 1RM, Previous 1RM, Gain, Body Weight, Strength Ratio, Status, Goal 1RM, % to Goal, Date Achieved and Notes.
- Five columns that fill themselves in. PR ID numbers each row, Est. 1RM applies the Epley formula, Gain is the difference against your Previous 1RM, Strength Ratio compares the estimate to the Body Weight you entered, and % to Goal is the estimate against your Goal 1RM.
- The Epley estimate, shown not hidden. Est. 1RM is weight x (1 + reps / 30), so a set of 8 at a moderate load and a heavy single are put on the same scale. The formula sits in the cell where you can read and change it.
- Six muscle groups out of the box. Legs, Chest, Back, Shoulders, Arms and Glutes, each with its own colour in the Muscle Group column.
- Equipment kept separate. Barbell, Dumbbell, Cable and Machine are their own dropdown, so a 315 lb barbell squat and a 720 lb leg press never get compared as if they were the same lift.
- Three statuses. New PR, Maintained and Working On, colour-coded so one glance down the column tells you which lifts are moving and which are parked.
- Goals in the same row as the record. Goal 1RM sits beside Est. 1RM and % to Goal fills the gap, and the Est. 1RM vs Goal 1RM chart puts the two bars side by side for every exercise.
- Auto-expanding dropdowns. Muscle Group, Equipment and Status all pull from the List tab, rows 2-500. Add a new movement pattern or a new machine there and it appears in the dropdown immediately – no re-setup.
- Room for 985 PRs. Formulas and chart ranges already run to row 1000, which is years of logging across a full exercise library.
- Pounds or kilos. Weight columns say lb by default; rename the headers to kg and enter kilos instead – the arithmetic is identical either way.
- Recolour in one place. The whole palette lives in a single const C block at the top of the build script, so the teal theme becomes your own colour in about a minute.
What’s Inside the Gym Personal Records (PR) Tracker in Google Sheets
Your download is a PDF that carries the Make a copy link. Clicking it drops a private, fully editable copy into your own Google Drive – nothing is shared with anyone, and no one else can see your numbers. That copy contains four tabs.
1. Tracker – the working page
The teal title banner runs across the top. Underneath, the Total PRs Logged card sits on the left with the four charts beside it, and the register starts at row 16. Header row, dropdowns, colour rules and formulas are all in place; you type into the white cells and everything else responds.
2. List – the dropdown source
A plain lookup tab holding the values behind every dropdown: the six muscle groups, the equipment types and the three statuses. Add your own entries here rather than editing the validation rules.
3. How to Use – the printable guide
A four-step walkthrough covering data entry, which columns calculate themselves, the routine for updating a lift after a new best, and how the dropdowns work. It also explains the one-time, ten-second Data validation setting that turns the dropdowns into the coloured chips you can see in the screenshots, and where to change the units and the colour palette.
4. Explore More Templates – the directory
A linked table of related NextGenTemplates products by category, format and price, plus a WELCOME15 coupon worth 15% off your next purchase.
Gym Personal Records (PR) Tracker in Google Sheets vs. a Home-Built Excel File vs. a Paid Lifting App – Where This Fits
| This tracker (Google Sheets) | Excel file you build yourself | Paid lifting app subscription | |
|---|---|---|---|
| Cost | $6.99 one-time | Free if you already own Excel, plus your build time | Recurring monthly or annual subscription |
| Platform | Google Sheets, any browser | Desktop Excel, Microsoft 365 | Phone app, sometimes a web view |
| Setup time | About 5 minutes – copy, replace 15 sample rows | Several hours to design the columns, formulas and charts | Minutes, but you start inside the app’s own exercise list |
| Real-time collaboration | Yes, native multi-user editing | Only through OneDrive co-authoring | Usually one account per person |
| Mobile access | Yes, Google Sheets app | Limited on the Excel mobile app | Yes – that is the strong point |
| Customisable fields | Yes – add columns, edit the List tab, recolour | Yes, but you maintain every formula | Restricted to what the vendor exposes |
| Share with a link | Yes, one link to your coach or training partner | File attachments and version confusion | Usually an in-app invite or an export |
| Year-1 cost at 5 users | $6.99 total – share one sheet, or one copy each | Existing Microsoft 365 licences plus build time | Five separate subscriptions |
| 1RM estimate you can read and edit | Yes – the Epley formula sits in the cell | You write it | Calculated behind the scenes |
| Your data leaves with you | It is a spreadsheet in your own Drive | Yes, a local file | Depends on the export the vendor offers |
Who This Template Is For – and Who It’s Not For
A good fit if you are: a lifter who wants a permanent, searchable record of every best lift rather than a phone app you may stop paying for; someone chasing a specific number on a specific lift and wanting the gap to that number in writing; a coach who wants one shared sheet per athlete instead of screenshots in a chat thread; anyone who has been keeping PRs in a notes app and wants the estimates and percentages calculated instead of guessed.
Not a good fit if you: want a programme written for you – this sheet records what you did, it does not prescribe what to do next; want set-by-set logging inside every session, since this register holds one row per exercise record rather than a full workout diary (the Workout Log Tracker in Google Sheets is the session-level companion); need automatic sync from a watch or a bar-speed sensor, which no spreadsheet does; or run a gym as a business, where Gym Membership Tracker in Google Sheets is the right tool instead.
How to Use the Gym Personal Records (PR) Tracker in Google Sheets
- Open the PDF and click the copy link. Google creates your own copy in your Drive. Rename it and it is yours.
- Skim the sample. Rows 16-30 hold 15 worked examples across all six muscle groups and all three statuses. Look at how Gain and % to Goal behave before you delete them.
- Enter your records. Fill Exercise, Muscle Group, Equipment, Best Weight, Reps @ PR, Previous 1RM, Body Weight, Status, Goal 1RM and Date Achieved. Leave PR ID, Est. 1RM, Gain, Strength Ratio and % to Goal alone – they are formulas.
- Add your own dropdown values. If a movement pattern or a machine is not listed, add it on the List tab and it appears in the dropdown right away.
- Turn the dropdowns into chips (optional, ten seconds). Select column C, then Data, Data validation, click the rule, Advanced options, Display style Chip. Repeat for column D and column L to match the screenshots.
- Update after each new best. Change Best Weight and Reps @ PR, set Status to New PR and enter the date. The Total PRs Logged card, Gain, % to Goal and all four charts refresh instantly.
- Review the gap. Sort by % to Goal to see which lifts are closest to the number you set, and filter by Status to find anything still marked Working On.
Real-World Use Cases
Andre, four years into barbell training. Andre keeps one row per main lift and one for each accessory he cares about. Because Previous 1RM stays in the row, the Gain column is a plain record of what changed and when – and the Est. 1RM vs Goal 1RM chart shows him which bars are still short of the number he wrote down in January.
Ines, returning after a long break. Ines marks most of her lifts Working On and a few Maintained, and logs Body Weight alongside each record so the Strength Ratio column keeps the numbers in context as she rebuilds. The PR Count by Status donut tells her at a glance how much of her list is still in progress.
Tomas, coaching six lifters remotely. Tomas keeps one copy of the tracker per athlete in a shared Drive folder and gives each of them edit access. Because it is a link rather than an attachment, he always sees the current numbers, and the Notes column carries the running explanation – belt, paused reps, per hand – that a bare weight never captures.
Frequently Asked Questions
Is the Est. 1RM a real one-rep max?
No. It is the Epley estimate – weight x (1 + reps / 30) – which is a standard way to put sets of different rep counts on one scale. It is arithmetic applied to the numbers you typed, not a measurement, and it is not a recommendation to attempt that load.
Does this tell me what to lift next?
No. The tracker is a record. It does not write programmes, suggest loads, or give training, medical or nutrition advice – it shows you what you entered and how it has changed.
Can I use kilograms instead of pounds?
Yes. The headers say lb only as a label. Rename them to kg and enter kilos; Est. 1RM, Gain, Strength Ratio and % to Goal all work the same way because they are ratios and differences, not conversions.
Is this a full workout log?
No – it holds one row per exercise record, not every set of every session. If you want set-by-set session logging, the Workout Log Tracker in Google Sheets covers that and the two sit side by side well.Gym Personal Records (PR) Tracker in Google Sheets
What do I actually download?
A PDF that contains the Make a copy link plus setup notes. Click the link, Google places a private editable copy in your Drive. There is no add-on to install and no permission to grant.Gym Personal Records (PR) Tracker in Google Sheets
Will the charts break when I add rows?
No. All four charts and the KPI card cover rows 16 to 1000 already, so new records appear automatically until you exceed 985 rows.
Can I share it with my coach?
Yes. Share your copy from Google Sheets like any other file. A coach can be given edit access to add notes, or view access to watch without changing anything.Gym Personal Records (PR) Tracker in Google Sheets
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.Gym Personal Records (PR) Tracker in Google Sheets
Explore Related Templates
- Workout Log Tracker in Google Sheets – the session-by-session diary that feeds the records you keep here.
- Weight Loss Tracker in Google Sheets – log body weight over time next to the Body Weight figure this sheet uses for Strength Ratio.
- Gym Membership Tracker in Google Sheets – the admin side: who is a member, when they renew, what they paid.
- Fitness and Wellness Dashboard in Google Sheets – a wider multi-page view when one register stops being enough.
- Gym Retention Dashboard in Google Sheets – built for gym operators who need to see churn rather than lifts.
Browse the full Google Sheets templates collection, or go straight to the Google Sheets Trackers category.Gym Personal Records (PR) Tracker in Google Sheets
Get the Gym Personal Records (PR) Tracker in Google Sheets for $6.99 (regular $12.99) – instant download, one-time payment, unlimited use, free lifetime updates. Need a custom version with your own exercise library or a kilos-first layout? Email info@nextgentemplates.com.Gym Personal Records (PR) Tracker in Google Sheets
Watch the step-by-step video Demo:
Last updated: 13 August 2026.
Reviews
There are no reviews yet.