All articles

Tools

Free 5/3/1 Spreadsheet (Generate & Download) — Or Skip It Entirely

Generate a free, fully-calculated 5/3/1 spreadsheet from your training maxes and download it as a CSV for Excel or Google Sheets. Plus: why most lifters outgrow it.

Build Your Free 5/3/1 Spreadsheet

Enter your training maxes, choose how many cycles you want, and download a complete 5/3/1 spreadsheet — every set and percentage pre-calculated, with blank columns to log your reps. It opens in Excel, Numbers, or Google Sheets.

Tip: enter your training max (≈85–90% of your 1RM), not your true max.


For years, the default way to run Jim Wendler’s 5/3/1 was a spreadsheet. You’d find one on a forum, plug in your maxes, and print the tab for the week. It works — and the generator above gives you a clean one for free, with your training-max progression already built in across every cycle.

But a spreadsheet has limits, and most lifters hit them within a few months. Here’s the honest case for both.

What the Spreadsheet Gets Right

A 5/3/1 spreadsheet is hard to beat for three things:

  • It’s free and offline. Download it once, open it anywhere, no account required.
  • The main-work math is fixed. Your working percentages never change, so a spreadsheet calculates them perfectly every time.
  • You own your data. It’s a file on your computer — no platform can take it away.

If you run a barebones program — main lifts plus a supplemental template and nothing fancy — a spreadsheet covers you indefinitely. The generator above is built exactly for that lifter.

Where Every 5/3/1 Spreadsheet Breaks Down

The problem isn’t the math. It’s everything around the math:

  1. Manual training-max updates. Every cycle you edit four numbers by hand. Miss one and your percentages silently drift.
  2. No AMRAP intelligence. A spreadsheet can’t tell you that your AMRAP reps have been falling for two cycles and your training max needs a reset. You have to notice that yourself — and most lifters don’t until they stall.
  3. Accessories are on you. The supplemental and accessory work that actually drives your physique and weak points isn’t in any spreadsheet. You’re guessing.
  4. Logging is clumsy. Typing reps into a cell at the gym, on your phone, between sets, is miserable — so most people stop logging, and then the data that makes 5/3/1 work disappears.
  5. No progress picture. Charting your estimated 1RM trend across lifts means building yet another tab. Almost nobody does.

A spreadsheet is a calculator you have to maintain. The maintenance is exactly the part that gets skipped.

The App Alternative

Train531 is what a 5/3/1 spreadsheet becomes when it grows up. It calculates the same main-work percentages, but it also:

  • Updates your training maxes automatically each cycle
  • Tracks every AMRAP set and flags a training-max reset before you stall
  • Prescribes your supplemental and accessory work with an AI coach that adapts to your history and equipment
  • Logs sets in a tap and charts your estimated 1RM over time

Start with the free spreadsheet above — it’s genuinely useful, and it’s yours. When you’re tired of maintaining it, Train531 picks up exactly where the spreadsheet leaves off.

Try Train531 Free

AI-powered 5/3/1 coaching. 10 workouts free, no credit card required.

Download on the App Store