Updated November 2026
A push pull/legs Excel sheet lets you log every set, rep, and load across your three training days, then shows you whether you are actually getting stronger. In this guide you will build a simple workbook with one tab per workout, automatic volume totals, and a progression column that tells you when to add weight. The whole setup takes about 30 minutes.
Step 1: Set Up the Workbook Structure
Create one workbook with four tabs: Push, Pull, Legs, and Summary. Keep the three training tabs identical in layout so your habits carry over from one day to the next. The Summary tab will pull totals from the other three.
Shopping for one? See our guide: 7 Best Push Pull Legs Split Posters and Training Aids for 2026.
Columns for Each Training Tab
Use the same header row on every training tab:
- Date and Week #
- Exercise
- Set 1 to Set 4 (enter the reps for each set)
- Load (lb) for the working weight
- Volume (a formula, covered in Step 3)
- Notes for RPE, pain, or form cues
Step 2: Build Your Exercise Lists
Fill each training tab with the exercises you actually perform. A typical split looks like this:
| Day | Main Lifts | Accessories |
|---|---|---|
| Push | Bench press, overhead press | Incline dumbbell press, lateral raises, triceps pushdowns |
| Pull | Weighted pull-ups or lat pulldown, barbell row | Face pulls, dumbbell curls, rear delt flyes |
| Legs | Back squat or leg press, Romanian deadlift | Leg curls, leg extensions, calf raises |
List exercises in the order you perform them, heaviest first. This keeps the sheet readable and makes trends easy to spot.
Step 3: Add Formulas for Volume and Progression
Two formulas do most of the work.
- Volume per exercise: In the Volume column, use
=Load*(Set1+Set2+Set3+Set4). Adjust the range if you use fewer sets. - Progression check: In the Notes column or a helper column, compare this week’s top set to last week’s using
=IF(Load>LastWeekLoad,"Up","Hold"). Replace the reference with the matching cell from the prior row.
Use conditional formatting to shade “Up” cells green. A row of green over several weeks tells you the program is working.
Step 4: Connect the Summary Tab
On the Summary tab, use SUMIF to total weekly volume for each muscle group. For example, =SUMIF(Push!B:B,"Bench press",Push!F:F) adds up all bench press volume. Group the totals by week so you can see whether chest, back, and leg work are roughly balanced.
If one area consistently lags, adjust the split before the imbalance turns into a weak point. Coaches generally recommend tracking this every four to six weeks rather than daily.
Common Mistakes
- Logging only the top set and skipping the rest, which makes volume numbers meaningless.
- Changing exercise names every week, so the sheet cannot compare progress.
- Forgetting to record bodyweight or assisted reps on pull days.
- Building a sheet so complex you stop updating it after two weeks.
- Ignoring the Notes column, where fatigue and soreness signals often appear first.
Recommended Gear
A tablet or laptop stand keeps the sheet visible on the bench or squat rack, which makes logging between sets easier. View on Amazon
A small pocket notebook works well as a backup when your phone is in the locker room. View on Amazon
Related Reading
If you are still choosing a split, compare options in What's a Good Push Pull Legs Split? 7 Best Programs Compared (2026) and Split vs Push Pull Legs (2026): Which Is Better for Your Training?. For a day-by-day template you can copy into your sheet, see Workout Routine Push Pull Legs: A Step-by-Step Guide to Building Your Split. Beginners wondering what the terms mean should start with What Does Push Pull Legs Mean? A Simple Guide to the Split.
FAQ
Do I need Excel, or will Google Sheets work?
Google Sheets uses the same formulas, including SUMIF and IF, so either works. Pick whichever you can open on your phone at the gym.
How often should I update the sheet?
Log each set during or right after your workout. Review the Summary tab once a week to check progression and volume balance.
Should I track bodyweight in the same workbook?
Yes, add a fifth tab with date and morning bodyweight. Recording it alongside your lifts helps you judge whether changes in strength reflect real progress or just water weight.
Conclusion
A well-built push pull/legs Excel sheet turns training days into clear data you can act on. Start with the four-tab structure, add the volume and progression formulas, and review your totals weekly. Consult a qualified coach or physician before starting any new training program, especially if you have an existing injury or health condition.
