Workout Tracker Spreadsheet: A Free Template for Google Sheets and Excel

Quick answer: A workout tracker spreadsheet is a simple grid with one row per set and columns for date, exercise, weight, reps, and RPE. Add a formula column for estimated 1RM, then log every session so you can watch your numbers climb. Copy the free template below into Google Sheets or Excel and start this week.

You opened a blank sheet, typed "Bench", "60kg", "3x8", and then paused. What goes in the next column? And will you actually pull this thing up between sets on the gym floor?

A spreadsheet is a wonderful place to see your training. It is an awkward place to enter it. This guide gives you a template that works, plus an honest look at where spreadsheets start to fall apart.

What should a workout tracker spreadsheet include?

One row per set, not one row per workout. This is the single decision that makes or breaks the sheet. If you cram a whole session into one cell, you can never chart a single lift over time. Give every set its own line.

At a minimum, track these columns:

• Date so you can sort and filter by session.
• Exercise written the exact same way every time (pick "Bench Press", not "bench" one week and "BB bench" the next).
• Set number for that exercise on that day.
• Weight and Reps, the two numbers that actually move.
• RPE or reps in reserve, a quick note on how hard the set felt.
• Notes for anything odd: tweaky shoulder, short rest, new shoes.

Consistency in the Exercise column matters more than anything else. A pivot table or chart can only group "Bench Press" with "Bench Press". One stray spelling and that set vanishes from your trend.

The free workout tracker spreadsheet template

Here is the layout to copy. The same structure works as a Google Sheets workout template or an Excel workout tracker template with no changes. Paste this header row into row 1 of a new sheet, then add one row per set underneath.

The "Est. 1RM" and "Volume" columns are formulas, so you never type them by hand. Fill in Weight and Reps, and the rest calculates itself.

Want it printable instead of digital? If you would rather log on paper or in your phone, our plain-text workout log template covers the same fields without any spreadsheet setup.

How do you calculate 1RM and volume in the spreadsheet?

Two formulas turn raw numbers into progress signals. Both are one-liners you can drag down the whole column.

For estimated one-rep max, the Epley formula is the standard. If Weight is in column D and Reps in column E, put this in your Est. 1RM cell:

=D2*(1+E2/30)

That gives the weight you could theoretically lift once, without ever risking a true max attempt. Tracking estimated 1RM is the cleanest way to see strength trending up even when your working weights stay the same. For the full method and its accuracy, see our guide to estimated 1RM.

For volume, which is total work done per set, multiply weight by reps:

=D2*E2

Sum volume per exercise per week and you have a running measure of training load, the number most closely tied to muscle growth. These two columns are the entire reason a spreadsheet beats a plain list: the math happens for you.

Why do workout spreadsheets get abandoned?

The friction is on the gym floor, not at the desk. Building the sheet feels productive on a Sunday. Then Monday comes, you are three sets deep, hands chalky, phone auto-locking, and you are trying to tap a specific cell in a tiny grid without fat-fingering the wrong row.

Spreadsheets were built for a mouse and keyboard, not sweaty thumbs between sets. Most people log the first week religiously, then start "filling it in later", then stop.

There is a data-quality problem too. Spreadsheets are famously error-prone: a 2024 review led by Prof. Pak-Lok Poon found that 94% of business spreadsheets contain critical errors, most from simple manual mistakes. A mistyped weight or a formula dragged one row short quietly corrupts the trend you are relying on.

The habit is what matters. Self-monitoring genuinely works: in one controlled study, participants who logged their training averaged 7.24 workouts per week versus 4.74 in the control group, and their check-ins rose from under one to about six per week. The catch is that the benefit only shows up if you keep logging. A tool you abandon by week three tracks nothing.

Spreadsheet vs app: which tracks progress better?

Every tracking method trades speed for structure. Here is how the common options stack up.

Notes and paper win on speed but show no trend. You can scribble "Bench 60 10,9,9" in two seconds, then never see whether you are climbing. For more on that trade-off, see workout notebook vs app.

Spreadsheets win on visualization but lose on speed. They give you charts and formulas, but only after real setup, and only if you fight the mobile keyboard for every set. That is the exact gap this whole approach runs into, and why our deeper piece on how to track progressive overload without complex spreadsheets exists.

Keep the speed, drop the spreadsheet friction

If a spreadsheet already gives you the charts you want, keep it. You are tracking, and tracking is the win. The problem is almost never the sheet at home. It is the logging on the floor.

That is the gap Gym Note Plus is built to close. You type your sets in plain shorthand, the same way you would in a notes app, and it turns that text into structured logs, estimated 1RM, and progress charts automatically.

• Log in plain text, no cell-hunting or menus between sets.
• Get the formulas for free, with 1RM and volume trends calculated the moment you save.
• See every lift's history so you know last week's numbers before you start.

You keep the speed of notes and gain the charts a spreadsheet promised, without maintaining a single formula. If you like structured logging in general, our guide on how to track gym progress covers the full routine.

A spreadsheet is only as good as the sets you actually enter. The fastest tracker is the one you never stop using.

A simple starting plan

1. Copy the template above into a new Google Sheet or Excel file, one row per set.
2. Add the two formulas for Est. 1RM and Volume, then drag them down the columns.
3. Standardize your exercise names so charts and pivots group cleanly later.
4. Log every set the day you train, not "later", so nothing gets lost or guessed.
5. Review weekly. Sort by exercise, glance at the 1RM column, and confirm the line is going up.

Frequently Asked Questions

How do I make a workout tracker in Google Sheets?

To make a workout tracker in Google Sheets, open a new sheet and label row 1 with Date, Exercise, Set, Weight, Reps, RPE, Est. 1RM, Volume, and Notes. Enter one row per set. Add the formula =Weight*(1+Reps/30) for estimated 1RM and =Weight*Reps for volume, then drag both down. Log every session to build a trend.

What is the best free workout tracker spreadsheet template?

The best free workout tracker template uses one row per set and columns for date, exercise, weight, reps, RPE, and formula-driven estimated 1RM and volume. This structure works identically in Google Sheets and Excel, charts cleanly, and requires no paid add-ons. Copy the layout in this article and adjust the exercise names to match your routine.

How do you calculate 1RM in a spreadsheet?

Calculate estimated 1RM in a spreadsheet with the Epley formula: multiply the weight lifted by one plus reps divided by 30, written as =Weight*(1+Reps/30). For a set of 60 kg for 10 reps, that estimates a 80 kg one-rep max. This lets you track maximal strength from your normal working sets without ever attempting a true max.

Is a spreadsheet or an app better for tracking workouts?

A spreadsheet is better for deep analysis and full control, while an app is better for fast logging and automatic charts. Spreadsheets slow you down at the gym because you must tap precise cells on a phone, which is why many lifters abandon them. An app like Gym Note Plus keeps plain-text logging speed and calculates the trends for you.

Can I use Excel instead of Google Sheets for a workout log?

Yes, the same workout log template works in Excel exactly as it does in Google Sheets. The column layout and the Epley 1RM and volume formulas are identical in both programs. Excel is a strong choice if you already work offline in it, though Google Sheets syncs across your phone and laptop more easily for logging on the go.

Final Takeaways

• Use one row per set. It is the only layout that lets you chart a single lift over time.
• Let formulas do the math. Estimated 1RM and volume should calculate themselves, never typed by hand.
• Keep exercise names identical. Charts and pivots can only group names that match exactly.
• The habit beats the tool. Self-monitoring only pays off if you keep logging, so pick the method you will not abandon.
• Fix the friction, not the sheet. If entering data at the gym is the sticking point, a plain-text tracker keeps the speed and still gives you the charts.