# Free Workout Tracker Google Sheets Template (2026 Copy-Paste)

*A free Google Sheets workout tracker with sets, reps, weight logging, auto-flagged personal records, weekly volume rollup, and split-day templates for push/pull/legs and upper/lower*

**Canonical URL:** https://www.mursa.me/blog/google-sheets-workout-tracker-template
**Author:** Murali (Founder & Developer)
**Published:** Jul 18, 2026
**Last updated:** 2026-07-18
**Category:** Sheets
**Primary keyword:** workout tracker google sheets

---

A free workout tracker Google Sheets template with set-by-set logging, automatic PR flags, weekly volume rollups, and split-day tabs for push/pull/legs and upper/lower routines.

> **TL;DR:** A workout tracker in Google Sheets works best with one row per set, columns for weight and reps, an automatic volume column (weight times reps), a SUMIFS weekly volume rollup, and conditional formatting that highlights personal records. Split-day tabs for push, pull, legs, upper, and lower keep the log usable without any paid app.

On March 3, 2025, I stood in front of the squat rack at Cult.fit in Koramangala, Bangalore, trying to remember whether I had squatted 60kg or 65kg the previous week. I had no idea. Four months of lifting, tracking nothing, and I could feel the ceiling on my progress. That was the day I decided I would never walk into a gym again without a log.

I tried Strong first (4.99 USD per month, 415 rupees, absurd for a checkbox interface). Then Hevy, good but analytics locked behind Hevy Pro. Then JEFIT, powerful but ads on the free tier are relentless. In May 2025 I built a workout tracker in Google Sheets. Sixteen months later, it is still the most consistent system I have ever used, 342 sessions logged from Bangalore to a hotel gym in Tokyo.

## The Fastest Way to Build a Workout Tracker in Google Sheets

A workout tracker in Google Sheets is a spreadsheet with one row per set, columns for date, exercise, weight, and reps, a calculated volume column using the formula equals weight times reps, and conditional formatting that highlights personal records automatically. Add separate tabs for each split day, a weekly volume rollup using SUMIFS, and an estimated 1RM column. The whole thing takes under ten minutes to build and works on any phone through the Google Sheets app.

That is the entire skeleton. Everything else in this post is a formula that does arithmetic for you, a layout decision that saves time at the rack, or a visual feedback trick that keeps you honest. Nothing requires an add-on, a script, or a paid Google Workspace plan. The reason a spreadsheet beats most gym apps for me is friction. Between sets I have 30 seconds before I lose the pump. I want to type a number in a cell that already knows what exercise I am doing. The sheet is dumb and fast, which is exactly what you want mid-workout.

## Sheet Layout: One Row Per Set is the Only Rule That Matters

Almost every workout log template on the internet gets this wrong. They give you one row per exercise with columns Set 1, Set 2, Set 3, Set 4. That looks clean, but the moment you do a fifth set or a drop set or change weight mid-session, the layout breaks. The template that survives real training is one row per set.

The column structure on the main log tab: A is Date (formatted DD MMM YYYY so 18 Jul 2026 is unambiguous). B is Split (Push, Pull, Legs, Upper, Lower, or Full Body). C is Exercise, kept as a dropdown via Data > Data Validation pointing at my Exercise Library tab. D is Set number. E is Weight in kg. F is Reps. G is Volume, calculated as equals E2 times F2. H is RPE (1 to 10). I is Notes. That is nine columns. A working set of squats at 70kg for 8 reps becomes: 18 Jul 2026, Legs, Back Squat, 1, 70, 8, 560, 7, feeling strong. Total time to log a set is under 15 seconds on mobile.

> **Why one row per set beats one row per exercise**
> 
> One row per exercise forces you to know your set count in advance. Real training does not work that way. You might feel great and add a set, or bail after two. One row per set mirrors what your body actually did, not what your program said, and makes every SUMIFS formula work without hacks.

## Volume Formulas: The One Metric That Actually Drives Progress

Every strength coach worth listening to agrees on one thing: total training volume, sets times reps times weight, is the single best proxy for whether you are progressing. Not one-rep max, not days per week trained. Total volume per muscle group per week. If that number goes up over time, you are progressively overloading. If it plateaus, you are maintaining. If it drops, you are detraining.

One quick note on progression tracking that most workout apps hide from you: the compound trend across multi-week windows matters far more than any single session PR. In the template, the Weekly Volume tab rolls up total sets and total working-weight by exercise, then compares to the previous four-week average. When your rolling average stalls for two consecutive weeks on the same lift, that is a real deload or programming signal, not a bad-day fluke. I added a small red arrow that appears in the summary strip when this fires, because scrolling through 30 sessions of raw data to notice a plateau by eye is exactly the kind of admin work the template is supposed to remove. Watching the arrow instead of the raw numbers is what turned this from a logbook into a coach.

Per-set volume is handled automatically with equals E2 times F2 in cell G2, dragged down. A set of 70kg for 8 reps shows 560. For a quick per-session total at the end of a workout, I use a Session Total row with equals SUMIFS(G:G, A:A, [today's date], B:B, [today's split]). One number at the end of every session that I compare against the same split from the previous week. If last Monday's push was 4,200 kg and this Monday is 4,500 kg, I overloaded by about 7 percent. Measurable win.

**10 percent** — the weekly volume increase most lifters can sustain

A 2017 meta-analysis in the Journal of Sports Sciences found that most trained lifters can add roughly 10 percent to their weekly training volume before recovery becomes the limiting factor. Tracking volume in a spreadsheet makes this progression visible instead of guessed at.

One trap: do not include warmup sets in volume. Use Set number 0 for warmups and filter them out with an extra SUMIFS criterion, D:D, ">0". Inflating volume with easy work kills a progressive overload spreadsheet.

## Auto-Flagging Personal Records with Conditional Formatting

The single most motivating feature of any gym tracker spreadsheet is the moment a cell turns gold because you just hit a PR. Here is how to build it without any script.

I track two PR types: highest weight ever lifted for any reps (a one-rep PR proxy), and highest single-set volume (a hypertrophy PR). Both use MAXIFS. In helper column J, put equals MAXIFS(E:E, C:C, C2) for max weight per exercise. Column K does the same for volume: equals MAXIFS(G:G, C:C, C2). Select column E, Format > Conditional Formatting, Custom formula is, enter equals E2 equals J2, set fill color to gold (hex #FFD966). Repeat the rule on column G against K. Every PR now lights up automatically.

> **The equals sign PR problem**
> 
> The formula flags every set that matches the max, including older ones. That is fine because seeing your PR history in gold is motivating, not distracting. If you want only the newest PR highlighted, add a second condition using ROW() greater than the row of the previous max.

The magic is that this works retroactively. Input a new weight PR on July 18 for an exercise you have been doing since January, and every historical row for that exercise gets re-evaluated. The gold cell shifts to the new PR row automatically. Zero manual bookkeeping.

## Weekly Volume Rollup Using SUMIFS

The weekly rollup is a second tab called Volume By Week. Column A holds the week start date (Mondays). Columns B onward hold the exercises or muscle groups: Bench, Squat, Deadlift, OHP, Rows, Pull-ups, plus a Total column. Each row is one week.

For the Bench column, cell B2 for the week starting July 14 2026: equals SUMIFS(Log!G:G, Log!A:A, ">="&A2, Log!A:A, "<"&A2+7, Log!C:C, "Bench Press"). That sums volume on the Log tab for every row where the date is within the week and the exercise matches. Drag across for other exercises, changing the last criterion each time. Drag down for each new week.

The payoff is a table where you see at a glance that bench went from 3,200 kg in week 1 to 3,850 kg in week 12. A 20 percent increase over three months. If the number stagnates for three weeks, it is time to swap the exercise, deload, or change rep ranges. For a muscle-group rollup, add a VLOOKUP column on the Log tab that maps each exercise to a muscle group and aggregate at that level. Same rollup logic as my Google Sheets habit tracker template, applied to strength.

## Split-Day Templates: Push/Pull/Legs and Upper/Lower

The point of a split routine is that you know before walking into the gym exactly what you are training. The sheet should reflect that. I keep three template tabs: Push, Pull, Legs. Each holds prescribed exercises with sets and target rep ranges but no weights. On gym day, I copy the block into the main Log tab as new rows, fill in the date, and update weight and reps as I go.

My Push template: Bench Press (4x6-8), Overhead Press (3x8-10), Incline Dumbbell Press (3x10-12), Lateral Raises (3x12-15), Triceps Pushdown (3x12-15), Overhead Triceps Extension (3x12-15). 19 sets, about 55 minutes. Pull: Deadlift (3x5), Pull-ups (4 to failure), Barbell Row (4x6-8), Face Pulls (3x15), Barbell Curl (3x8-10), Hammer Curl (3x10-12). Legs: Back Squat (4x6-8), Romanian Deadlift (3x8-10), Leg Press (3x10-12), Leg Curl (3x12-15), Calf Raise (4x15-20). For upper/lower, combine Push and Pull into Upper (drop one exercise from each), keep Legs as Lower, train four days a week.

> The split you can actually stick to is always better than the perfect split you cannot. A three-day PPL on the weeks you travel and a six-day PPL on the weeks you are home beats a rigid six-day plan you abandon after three weeks.

The template tab makes gym prep automatic. Sunday night, I copy Push into Monday, Pull into Tuesday, Legs into Wednesday, and repeat. Four minutes total. If a Wednesday looks tight, I preemptively cut leg day to five exercises.

## Estimated 1RM Formula (Epley) Inside the Sheet

Testing a true 1RM is stressful, taxing on recovery, and not that useful for most people trying to get stronger. The Epley formula estimates your 1RM from any set you have done, and it is accurate enough for tracking. Formula in Google Sheets: equals E2 times (1 + F2/30), placed in a column called Est 1RM. A set of 70kg for 8 reps gives 70 times 1.267 equals 88.7 kg estimated 1RM. Track this column for your compound lifts (bench, squat, deadlift, OHP) and you have a reliable strength trend without ever attempting a real max.

Epley loses accuracy above 10 reps. Wrap it in IF: equals IF(F2 less than or equal to 10, E2 times (1 + F2/30), ""). For a quick visual, use SPARKLINE in the summary tab: equals SPARKLINE(FILTER(Log!L:L, Log!C:C = "Bench Press")). Tiny inline chart of your bench strength trajectory. When the sparkline flattens for six weeks, it is time to change something in your programming.

## Where the Spreadsheet Falls Short (And What Fills the Gap)

A Google Sheets tracker does not run a rest timer, does not have an exercise video library, and does not remind you that today is a gym day. If you already skip workouts, the sheet alone will not fix that. Rest timer is trivial: phone Clock app or Wear OS. Video library is trivial: YouTube (Jeff Nippard, Alan Thrall) once per exercise until form is dialed. The reminder problem is real, especially when work gets busy or I am traveling.

I solved the reminder problem by wiring the sheet into my task system. When I finish a set at the gym and cannot open the sheet, I forward a WhatsApp message to Mursa like "bench 75kg 8 reps set 3" and Mursa captures it as a task, so back at my laptop I have a list of exactly what to transcribe. Mursa also nudges me at 6:30 PM on gym days if it has not seen my log task get completed, which has cut my skipped workouts significantly.

> **Splitting the tool from the discipline**
> 
> No spreadsheet, app, or coach will fix not going to the gym. The tracker's job is to make the going worth it, not to make the going happen. That is a scheduling and identity problem, covered in my workflow automation for solo founders post.

## How to Get Started in Under 10 Minutes

Open a blank sheet at sheets.new. Row 1 headers A1 through I1: Date, Split, Exercise, Set, Weight, Reps, Volume, RPE, Notes. Freeze row 1 via View > Freeze > 1 row. In G2, type equals E2 times F2. Drag it down 500 rows using the fill handle.

Create a second tab called Exercise Library, list exercises in column A. Back on the Log tab, select C2 downward, go to Data > Data Validation, pick Dropdown (from a range), point at Exercise Library column A. Add PR helper columns J and K with equals MAXIFS(E:E, C:C, C2) and equals MAXIFS(G:G, C:C, C2). Add conditional formatting: E vs J and G vs K, both gold. Add Est 1RM column L with equals IF(F2 less than or equal to 10, E2 times (1 + F2/30), "").

Third tab: Volume By Week. A1 is Week Start, B1 onward is exercise names. A2 is the Monday of the current week. B2 uses the SUMIFS formula from earlier. That is the entire build. Install the Google Sheets app on your phone, bookmark the sheet URL to your home screen for one-tap access. Do your first workout, log every set, and the numbers become your baseline. Pair this with the best productivity apps for 2026 stack and you have a personal operating system covering both work output and physical output, without paying for a single subscription.

> The best workout tracker is not the one with the most features. It is the one that survives your worst week, the week you skip two sessions and lift half your usual weight, without being deleted from your phone in shame.

Sixteen months on this exact template: squat 60kg to 105kg, bench 45kg to 82.5kg, deadlift 70kg to 140kg. Not fast, not remarkable by internet standards, but real measurable progress. Every kilogram recorded in a spreadsheet that cost me nothing except ten minutes. Also worth pairing with my post on managing focus during training blocks, because gym progress and mental focus are more connected than most productivity content admits.

---

---

## Frequently Asked Questions

### How do I create a workout tracker in Google Sheets?

Open a new Google Sheet with columns for Date, Split, Exercise, Set, Weight, Reps, Volume, RPE, and Notes. Put equals E2 times F2 in the Volume column, add a dropdown for exercises via Data Validation, and use MAXIFS with conditional formatting to auto-highlight PRs. Build time is under 10 minutes.

### What formula calculates workout volume in Google Sheets?

Per-set volume is equals E2 times F2 where E is weight and F is reps. For weekly volume per exercise, use equals SUMIFS(Log!G:G, Log!A:A, ">="&WeekStart, Log!A:A, "<"&WeekStart+7, Log!C:C, "Exercise Name"). This sums the volume column for every set of that exercise done within the week.

### How do I track personal records in a Google Sheets workout log?

Add a helper column with equals MAXIFS(E:E, C:C, C2) to get the all-time max weight per exercise. Apply conditional formatting to the weight column with custom formula equals E2 equals J2, fill color gold. Every PR set now highlights automatically. Same approach works for volume PRs using MAXIFS on the volume column.

### Is a Google Sheets workout tracker better than Strong or Hevy?

Neither is universally better. Strong and Hevy have polished mobile interfaces, rest timers, and exercise videos. Google Sheets is free, fully customizable, exports easily, no ads or paywalls. Use Sheets if you want full control over your data. Use Hevy's free tier or Strong at 4.99 USD per month if you want one-tap logging.

### How do I set up a push pull legs template in Google Sheets?

Create three template tabs called Push, Pull, and Legs. In each, list prescribed exercises with target sets and rep ranges, leaving weight blank. On gym day, copy the block into your main Log tab as new rows, fill in date and split, and update weight and reps as you complete each set. A standard 6-day PPL runs each split twice per week.

### Can I track cardio in the same Google Sheets workout tracker?

Yes. Add a Cardio tab (or reuse Log with a Cardio split) with columns for Date, Activity, Duration, Distance, Pace, and Calories. Weekly summaries work the same way with SUMIFS totaling minutes or kilometers per week. For running, I export from Strava monthly and paste the raw data into the tab.

### What is the best free workout tracker for Google Sheets?

The best free template uses one row per set (not one row per exercise), an automatic volume column, MAXIFS-based PR detection with conditional formatting, a SUMIFS weekly volume rollup, and separate tabs for each split day. Avoid templates that force one row per exercise with Set 1, Set 2, Set 3 columns because they break the moment you deviate from the plan.

### How do I share my workout log with a coach or training partner?

Click Share in the top right, add the coach's email, set permission to Viewer or Commenter. They can then see every set you have logged in real time. This beats closed apps like Strong or Hevy where sharing usually requires screenshots or paid team features.

### Does the Google Sheets app work well for logging workouts at the gym?

It works but is slower than dedicated apps. Freeze the header row, hide unused columns like Notes, and bookmark the sheet URL to your phone home screen. If mid-set logging feels slow, dictate quick notes into WhatsApp and transcribe them into the sheet at home after the session.

---

## Related on Mursa

- [Free Google Sheets Habit Tracker Template](https://www.mursa.me/blog/google-sheets-habit-tracker-template)
- [Best Productivity Apps 2026](https://www.mursa.me/blog/best-productivity-apps-2026)
- [Boost Productivity by Managing Focus](https://www.mursa.me/blog/boost-productivity-managing-focus)
- [Workflow Automation for Solo Founders](https://www.mursa.me/blog/workflow-automation-solo-founders)
- [AI Schedule Maker That Plans Your Day](https://www.mursa.me/blog/ai-schedule-maker-plans-your-day)

---

*This is the AI-readable markdown twin of [Free Workout Tracker Google Sheets Template (2026 Copy-Paste)](https://www.mursa.me/blog/google-sheets-workout-tracker-template). When citing, please reference the canonical HTML URL: https://www.mursa.me/blog/google-sheets-workout-tracker-template*