Personal records get lost for a boring reason: they live in a phone note, a chalkboard, or somebody’s memory of what happened in March. The Gym Personal Records (PR) Tracker in Google Sheets is one register that keeps them. Six muscle groups, three statuses, a 16-column table with five columns that calculate themselves, one Total PRs Logged card and four charts that redraw as you type. Fifteen worked sample rows ship with it so the logic is visible before you replace them.Gym Personal Records (PR) Tracker in Google Sheets
One thing to be clear about up front: this is a record-keeping sheet, not a coach and not a medical tool. It stores and charts the numbers you type in. It does not write programmes, recommend loads or reps, and it cannot judge whether a lift is appropriate for you – those decisions belong with you and a qualified coach or clinician. This article walks through each page, what calculates and what you type, how it compares with a hand-built Excel file and with a paid lifting app, and the habits that keep the sheet current. The template itself is available here.Gym Personal Records (PR) Tracker in Google Sheets
Key Features of the Gym Personal Records (PR) Tracker in Google Sheets
- Total PRs Logged card. One large KPI on the left of the page counting every record in the register, so the size of your own history is always on screen.Gym Personal Records (PR) Tracker in Google Sheets
- PR Count by Muscle Group. A pie chart splitting your records across Legs, Chest, Back, Shoulders, Arms and Glutes – the quickest way to notice that one group has three entries and another has none.Gym Personal Records (PR) Tracker in Google Sheets
- PR Count by Status. A doughnut chart across New PR, Maintained and Working On, which is the chart to look at when you want to know how much of your list is actually moving.
- Est. 1RM by Exercise. A horizontal bar chart ranking every exercise by its estimated one-rep max, so machine lifts and barbell lifts sort themselves into visible tiers.
- Est. 1RM vs Goal 1RM. Paired columns per exercise putting the current estimate beside the number you wrote down, so a gap shows as a gap rather than hiding inside a percentage.
- Five automatic columns. PR ID, Est. 1RM, Gain, Strength Ratio and % to Goal are all formulas – you never type them.
- The Epley estimate, in the open. Est. 1RM is weight x (1 + reps / 30). The formula sits in the cell where you can read it, change it, or swap in a different estimator if you prefer one.
- Gain against your previous best. Previous 1RM stays in the row, so Gain is a plain record of what changed – and a negative number stays negative rather than being quietly hidden.
- Strength Ratio. The estimate divided by the Body Weight you entered for that record, which keeps the numbers in proportion when body weight itself is moving.
- Auto-expanding dropdowns. Muscle Group, Equipment and Status all read from the List tab, so adding a new movement pattern or a new machine takes one line.
- Room for 985 records. Formulas and chart ranges already run to row 1000.
Tracker Pages Explained
Page 1 – the Tracker
Everything you use lives here. The teal banner runs across the top; underneath, the Total PRs Logged card sits at the left with the four charts beside it on one row, so the whole summary fits on a single screen. Below that the register starts at row 16.
The columns are 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. You fill eleven of those; the other five are formulas. Colour carries the meaning: each muscle group has its own tint in column C, and Status shows New PR in green, Maintained in amber and Working On in blue, so a scan down two columns tells you what kind of list you are looking at.
The fifteen sample rows are deliberately mixed. A barbell back squat at 315 for 3 with the note “Depth checked”. A lat pulldown where the Gain column reads -7 and the status is Working On, because the previous best was higher. A dumbbell shoulder press logged “Per hand” so the number is not misread. A leg press at 720 for 10, sitting far above everything else on the Est. 1RM chart precisely because a machine lift is not comparable to a barbell lift. They exist so you can see how each column behaves before you delete them.
Page 2 – How to Use
A short setup page in plain language: which columns you fill, which calculate, the routine for updating a lift after a new best, and how the dropdowns are wired. It also covers the one-time ten-second trick that turns the validation dropdowns into the coloured chips you can see in the screenshots. Google does not let a script set that display style, so it is done by hand once – select the column, then Data, Data validation, click the rule, Advanced options, Display style: Chip. Google’s own guide to drop-down lists and data validation covers the same settings. The page also notes where the units and the colour palette live.
Page 3 – Explore More Templates
A recommendation page with a discount code and links to related NextGenTemplates products, plus category links for browsing the wider library.
The List tab
Muscle Group, Equipment and Status all read from here across roughly 500 rows. The shipped values are the common ones – Legs, Chest, Back, Shoulders, Arms, Glutes; Barbell, Dumbbell, Cable, Machine; New PR, Maintained, Working On – but they are just text. Add kettlebell, band, or a movement-pattern label like Hinge, and it appears in the dropdown immediately.
Gym PR Tracker vs. a Hand-Built Excel File vs. a Paid Lifting App – Feature Comparison
| This Google Sheets tracker | A hand-built Excel file | Paid lifting app | |
|---|---|---|---|
| Cost | Under $10 once | Free, plus your build time | Recurring monthly or annual |
| Platform | Google Sheets, any browser | Excel on desktop | Phone app, sometimes a web view |
| Setup time | About 5 minutes | Several hours of design | Minutes, inside the app’s own exercise list |
| Real-time collaboration | Yes – you and your coach at once | Only via OneDrive co-authoring | Usually one account per person |
| Mobile access | Yes, free Sheets app | Limited | Yes – the strong point |
| Customisable fields | Yes, via the List tab | Yes, if you rebuild the charts | Within the vendor’s model |
| Share with a link | Yes, one link to a coach or training partner | Attachments and version confusion | In-app invite or an export |
| Year-1 cost at 5 users | Under $10 total | Existing licences plus a weekend | Five separate subscriptions |
| 1RM estimate you can read and edit | Yes – Epley, visible in the cell | You write it | Calculated behind the scenes |
| Set-by-set session logging | No – one row per record | Only if you build it | Yes |
| Automatic sync from a watch or sensor | No | No | Sometimes |
| Your data stays yours | Yes, in your own Drive | Yes | Depends on the export offered |
Who Should Use This Template
It fits lifters who want a permanent, searchable record of every best lift rather than a phone app they may stop paying for. It fits anyone chasing a specific number on a specific lift, because Goal 1RM and % to Goal sit in the same row as the record and the gap is written down instead of remembered. It fits coaches who would rather keep one shared sheet per athlete than a chat thread of screenshots, and it fits people coming back from a break, who want body weight logged next to the load so the numbers stay in proportion.
It is not for you if you want a programme written for you – this sheet records what happened, it does not prescribe what comes next. If you want every set of every session captured, that is a workout diary rather than a PR register, and the two are different documents. If you need automatic sync from a watch or a bar-speed sensor, no spreadsheet does that. And if you run a gym as a business, membership and renewals are a different tracker entirely.Gym Personal Records (PR) Tracker in Google Sheets
Real-World Use Cases
The lifter four years in. 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 moved and when. The Est. 1RM vs Goal 1RM chart shows which bars are still short of the numbers he wrote down in January – a question he used to answer by scrolling three months of notes.
The returner. Ines marks most of her lifts Working On and a few Maintained, and logs Body Weight alongside each record so Strength Ratio keeps the load in context while her body weight itself is changing. The PR Count by Status doughnut tells her at a glance how much of the list is still in progress, which is more useful to her right now than any single number.
The remote coach. Tomas coaches six lifters and keeps one copy of the tracker per athlete in a shared Drive folder. Because it is a link rather than an attachment, he always sees current numbers, and the Notes column carries the context – belt, paused reps, per hand – that a bare weight never captures.Gym Personal Records (PR) Tracker in Google Sheets
Advantages of the Gym Personal Records (PR) Tracker
- Nothing to install. Native formulas, data validation, conditional formatting and charts. No add-on, no macro, no permission prompt.Gym Personal Records (PR) Tracker in Google Sheets
- Charts that grow with you. All four read the data columns directly using the built-in Aggregate option across rows 16 to 1000, so new records appear without anyone touching a chart range.
- Equipment kept as its own field. A 315 lb barbell squat and a 720 lb leg press are both on the Est. 1RM chart, and the Equipment column is what stops you reading them as the same kind of number.Gym Personal Records (PR) Tracker in Google Sheets
- Negative gains stay visible. A lift that has gone backwards shows a negative Gain and can be marked Working On rather than being quietly overwritten.
- The goal lives with the record. % to Goal is not a separate planning document; it is a column in the same row.Gym Personal Records (PR) Tracker in Google Sheets
- Pounds or kilos. The lb labels are just headers – rename them and enter kilos, because every calculated column is a ratio or a difference.
Opportunities for Improvement
Where it stops: it is a record of bests, not a session diary, so there is no place for every set and rep of a Tuesday evening – that is a deliberate scope choice, and a session log is the natural companion sheet. There is no history of a single lift over time either; each exercise holds a current best and one previous figure, so if you want a full progression curve you will want a second sheet and a chart over dated rows. The Est. 1RM is one estimator among several, and while the formula is editable it ships as Epley rather than offering a choice. The dropdown chip styling has to be applied once by hand because Google’s API does not expose it. And nothing syncs automatically – every number is typed, which is the trade for owning your own file.Gym Personal Records (PR) Tracker in Google Sheets
Best Practices
- Set the List tab up before entering anything. Getting your exercise vocabulary and equipment labels right first is far easier than re-labelling 200 rows later.
- One row per exercise, not per session. The register is a list of bests. Keeping it that way is what makes the charts readable.
- Fill Previous 1RM honestly. The Gain column is only as useful as the number you are comparing against.
- Log Body Weight with the record, not once. Strength Ratio is calculated per row, so a stale body weight quietly distorts every row that uses it.
- Use Working On rather than deleting. A lift you have not beaten in six months is information; removing the row throws it away.
- Keep the Notes column verbose. “Belt + straps”, “Paused reps”, “Per hand” is the context you will want a year from now when the raw number looks strange.
- Sort by % to Goal before you set the next target. It turns a sixteen-row table into a short list of what is actually close.Gym Personal Records (PR) Tracker in Google Sheets
Explore Relevant Templates
- Gym Personal Records (PR) Tracker in Google Sheets – the template covered in this article.
- Workout Log Tracker in Google Sheets – the session-by-session diary this register deliberately does not try to be.Gym Personal Records (PR) Tracker in Google Sheets
- Weight Loss Tracker in Google Sheets – body weight over time, next to the figure Strength Ratio depends on.
- Gym Membership Tracker in Google Sheets – the admin side: members, renewals and payments.Gym Personal Records (PR) Tracker in Google Sheets
- Fitness and Wellness Dashboard in Google Sheets – a wider multi-page view when one register is not enough.
- Gym Retention Dashboard in Google Sheets – built for operators who need churn rather than lifts.Gym Personal Records (PR) Tracker in Google Sheets
Frequently Asked Questions
Is the Est. 1RM a real one-rep max?
No. It is the Epley estimate – weight x (1 + reps / 30) – a standard way to put sets of different rep counts on one scale. It is arithmetic applied to what you typed, not a measurement, and it is not a suggestion to attempt that load.Gym Personal Records (PR) Tracker in Google Sheets
Does the tracker tell me what to lift next?
No. It records and charts what you enter. It does not write programmes or give training, medical or nutrition advice.Gym Personal Records (PR) Tracker in Google Sheets
Can I use kilograms instead of pounds?
Yes. The lb in the headers is only a label. Rename the headers to kg and enter kilos; Est. 1RM, Gain, Strength Ratio and % to Goal all behave identically because they are ratios and differences, not conversions.Gym Personal Records (PR) Tracker in Google Sheets
Is this a full workout log?
No. It holds one row per exercise record rather than every set of every session. The two documents work well side by side, but this one is the register of bests.Gym Personal Records (PR) Tracker in Google Sheets
Do I need a paid Google account?
No. A free personal Google account is enough. The download is a PDF containing a Make a copy link that places an editable copy in your own Drive.
Will the charts break when I add rows?
No. All four charts and the KPI card already cover rows 16 to 1000, so new records appear automatically until you pass 985 rows.Gym Personal Records (PR) Tracker in Google Sheets
Why do my dropdowns look like plain text?
The chip display style cannot be set by a script. Select the column, then Data, Data validation, click the rule, Advanced options, Display style: Chip. Ten seconds per column, one time, for columns C, D and L.
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
Conclusion
A personal record is only worth having if you can find it again. One register with six muscle groups, three statuses, an estimate you can read, a gain against the previous best and a written-down goal is enough structure to keep that history intact, and it takes about five minutes to set up. Type in the bests you already remember tonight, and let the sheet hold them from there.Gym Personal Records (PR) Tracker in Google Sheets
Get the template here: Gym Personal Records (PR) Tracker in Google Sheets. For walkthroughs of this and other Google Sheets builds, subscribe to youtube.com/@NeoTechNavigators.
