Excel Workout Tracker Template (Formulas Included)

Quick answer: A good Excel workout tracker needs one flat table with eight columns: date, exercise, set, weight, reps, RPE, estimated 1RM and notes. Format it as an Excel Table, add an Epley 1RM formula, and build one PivotTable for weekly volume. Everything else is decoration.

Most gym spreadsheets die the same way. Someone builds a beautiful tab per week, colour codes it, and abandons it in March because adding one exercise means restructuring the sheet.

The version that survives is uglier and flatter: one sheet, one row per set, added to forever.

What columns does an Excel workout tracker need?

Eight, and they all fit on a phone screen. Anything beyond this you can derive later.

Keep it flat. One row per set, never one column per week. Flat data is what PivotTables, charts and filters are built for; a grid of weeks is what they choke on.

That is also the difference between a tracker and a plan. A plan can afford to be pretty, whereas a tracker only has to accept another row.

Which Excel formulas actually matter?

Three. Estimated 1RM, volume, and a lookup for last session's weight. Everything else is a nice-to-have you will never open.

Estimated one rep max

The Epley formula is the standard, and it fits in one cell:

=IF(OR(D2="",E2=""),"",ROUND(D2*(1+E2/30),1))

Weight in D, reps in E. The IF wrapper stops the column filling with errors on blank rows, which is the single most common reason people abandon a sheet.

This is the column that makes different sets comparable. 80 kg for 8 and 90 kg for 5 look unrelated until you see 101 kg and 105 kg sitting next to each other. If you would rather not build it, the one rep max calculator does the same maths, and how estimated 1RM tracks real strength explains where it breaks down.

Volume

=IF(OR(D2="",E2=""),"",D2*E2)

Weight times reps, per set. On its own it tells you nothing. Summed by muscle across a week, it becomes the number that most training decisions hang on.

Last session's weight

XLOOKUP searching bottom-up is the cleanest way to answer "what did I do last time":

=XLOOKUP(K2,Log[Exercise],Log[Weight],"no record",0,-1)

Put the exercise name in K2 and you get the most recent weight for it. The -1 is the part that matters: it searches from the bottom of the table, so it finds your latest entry rather than your first. On older Excel versions without XLOOKUP, a LOOKUP with a reversed range does the same job less elegantly.

What does Excel do that Google Sheets does not?

PivotTables, real Tables with structured references, and sparklines that live inside a cell. These are the three features worth using.

Format your data as a Table first (select the range, then Ctrl+T). Formulas then auto-fill down as you add rows, and your ranges expand on their own. Without this, every new session means dragging formulas, which is the second most common reason spreadsheets get abandoned.

One PivotTable, for weekly volume. Rows: exercise. Columns: date grouped by week. Values: sum of volume. That single table answers most of what a gym app charts.

Weekly volume is worth watching because the dose-response research, a meta-analysis by Schoenfeld, Ogborn and Krieger covering 34 treatment groups from 15 studies, found each additional weekly set was associated with roughly 0.37 percent more muscle gain. Knowing your real weekly number turns that finding into something you can act on, and how many sets per week to build muscle covers the targets.

Sparklines for per-exercise trend. Insert > Sparklines > Line on a filtered range gives you a tiny chart in a single cell next to each exercise. It is the fastest read on whether a lift is moving.

Conditional formatting for PRs. A rule of =H2=MAX($H$2:$H$1000) on the estimated 1RM column highlights your best-ever set automatically.

Where does the Excel approach break down?

At the gym, holding a phone, between sets. This is the honest limitation, and it has nothing to do with Excel's capability.

• Typing into a spreadsheet on a phone is slow. Cell selection with a thumb, on a 90 second rest, while someone waits for your bench.
• Formulas do not always survive mobile editing. Excel mobile handles them, but one accidental paste over a formula cell and the column quietly stops calculating.
• PivotTables need refreshing. Your weekly volume is stale until you remember to hit refresh.
• It only helps if you open it. The analysis lives in a file you have to deliberately go and look at.

Most people who build a spreadsheet end up logging into their notes app at the gym and transcribing it into Excel later. That works, and it is two jobs where there should be one. The workout tracker spreadsheet post covers the same trade in more depth.

A simple starting plan

1. Build one sheet, eight columns, one row per set. No tab per week, no merged cells.
2. Press Ctrl+T immediately to make it a Table, so formulas fill themselves as you add rows.
3. Add the two formula columns: Epley 1RM and volume, both wrapped in IF so blanks stay blank.
4. Create one PivotTable for weekly volume by exercise. Refresh it on a Sunday.
5. Decide where you log during the session. If the answer is your notes app, plan for the transcription instead of pretending it will not happen.

Keep logging the way you already do

If you type sets into Apple Notes at the gym and paste them into Excel later, the notes half is fine. It is the transcription that eventually stops.

Gym Note Plus removes the second job. You write the same plain text you already write, and the structure gets built for you:

• Type Bench 80 8,8,7 and it becomes rows, with weight, reps and set number already separated.
• Every exercise gets its own progress chart, without a PivotTable to refresh.
• Estimated 1RM calculates as you log, using the same Epley maths as the formula above.
• Your whole history is searchable, so any lift is one tap away rather than one filter away.

Want to see the difference before you build anything? Paste a recent session into the free notes to workout translator and watch it come back as structured sets and charts.

A spreadsheet is an excellent place to analyse your training and a poor place to record it. Most people only need to fix the second half.

Frequently Asked Questions

What should an Excel workout tracker template include?

An Excel workout tracker template needs eight columns: date, exercise, set number, weight, reps, RPE, estimated 1RM and notes, with one row per set. Format the range as an Excel Table so formulas fill down automatically, and add a single PivotTable summarising weekly volume by exercise.

What is the Excel formula for estimated one rep max?

The Epley formula in Excel is =ROUND(D2*(1+E2/30),1), where D2 holds the weight and E2 holds the reps. Wrap it in =IF(OR(D2="",E2=""),"",...) so empty rows stay blank instead of showing errors. The estimate becomes less accurate above roughly ten reps.

Is Excel or a workout app better for tracking lifts?

Excel is better for analysis and worse for capture. It gives you PivotTables, sparklines and complete control over your data, but typing into cells on a phone between sets is slow. Most spreadsheet users log elsewhere during the session and transcribe later, which is the step that usually gets abandoned.

How do you find your last workout weight in Excel?

Use XLOOKUP with a reverse search: =XLOOKUP(K2,Log[Exercise],Log[Weight],"no record",0,-1), where K2 contains the exercise name. The -1 argument searches from the bottom of the table, returning your most recent entry rather than your oldest one.

Can you use an Excel workout tracker on your phone?

You can, using the Excel mobile app, but it is slow between sets. Cell selection is fiddly on a small screen, and pasting over a formula cell can silently break a calculated column. Many lifters log in a notes app during the session and paste into Excel afterwards.

Final Takeaways

• One flat sheet, eight columns, one row per set. A tab per week is what kills spreadsheets.
• Press Ctrl+T first. An Excel Table makes formulas and ranges self-maintaining.
• Three formulas do everything: Epley 1RM, volume, and an XLOOKUP for last session's weight.
• One PivotTable for weekly volume replaces most of what a gym app charts.
• Excel analyses well and captures badly. Decide now where you will log during the session, because that is where spreadsheets fail.