Free Excel Workout Plan Template for 2026 (Auto-Calculating)

A workout plan in Excel should do one thing a notebook can't: the math. You shouldn't be punching "275 for a triple" into a cell when the spreadsheet already knows the athlete's max and what percentage you're after. That's busywork — and busywork is where mistakes (and too-heavy Mondays) come from.

Here's how to build a workout plan template in Excel that calculates itself, plus a free one you can download and run today.

Updated for 2026 — the formulas below work in current Excel, Excel for Mac, and Google Sheets.

Start with the value that drives everything

Every smart workout plan is anchored to a number. For strength work it's a max; for general fitness it might be a goal weight or a baseline. Put that number in one cell, and write every working set as a percentage of it:

• =Max*0.85 for a heavy triple
• =Max*0.70 for volume
• =Max*0.50 for speed work

New to the percentage math itself? Here's how to work out percentages in Excel — every formula, step by step.

Change that one cell, and the entire plan re-weights instantly. That's the whole trick — and it's why a real template beats a static PDF you'd have to redo every block.

Lay the week out so it reads at a glance

A workout routine template should map cleanly to how training actually runs:

• Rows = exercises
• Columns = sets, reps, % and the calculated load
• Tabs = weeks or training days

When the structure mirrors the session, a coach can scan a column and know exactly what the floor should look like. No decoding required.

Build progression into the plan, not your memory

The point of a plan is that next week is already decided. Bake the progression in: bump the percentage, add a set, or drop the reps from week to week so the routine advances on its own. When you re-test, you change the max once and the back half of the plan updates for that athlete automatically.

A workout planner you have to manually update isn't a plan — it's a chore you reset every Monday.

One template, many athletes

A good fitness Excel spreadsheet scales. Duplicate the tab, drop in a new max, and you've got an individualized plan in seconds — same logic, different numbers. That's how one well-built template covers a whole roster without becoming a data-entry job.

Build your workout plan template in five steps

If you'd rather build it yourself, here's the whole thing start to finish:

1. Drop the anchor number in one cell. Put the athlete's max (or goal weight) in a single labeled cell — say B1. Everything downstream points back to it.
2. Lay out the grid. One row per exercise; columns for sets, reps, target %, and calculated load. Add a tab for each training day or week.
3. Write the load as a formula, not a number. In the load column, reference the anchor: =$B$1*0.85. Lock the cell with $ so you can drag the formula down the whole session without it drifting.
4. Bake in the progression. Copy the week-1 tab, then nudge the percentages, sets, or reps on each new tab so the plan advances on its own. Re-test day? Change the max once and the back half re-weights automatically.
5. Duplicate per athlete. Copy the workbook (or a tab), drop in the next person's max, and you've got an individualized plan — same logic, new numbers.

That's a complete auto-calculating workout plan template. The only maintenance is updating one cell when someone re-tests.

Prefer Google Sheets?

Every one of these templates is just Excel formulas — and those import straight into Google Sheets. Upload the .xlsx, open it with Sheets, and the percentage math keeps working, so you can build and share your plan in the browser. We walk through it in the free Google Sheets workout template guide.

Get the free workout plan template

We've already built the auto-calculating version. The free personal training templates for Excel & Google Sheets take a max and return a full workout plan, while the seasonal planner maps the routine across a season. Both are free to download — in Excel or Google Sheets — so grab the one that fits how you program.