Free Excel Workout Plan & Routine Template (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.

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

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.

Get the free workout plan template

We've already built the auto-calculating version. The personal training template takes a max and returns a full workout plan, while the seasonal planner maps the routine across a season. Both are free to download — grab the one that fits how you program.