Free Workout Log Template (Paper, Sheets, or App) for 2026
Quick answer
A workout log needs six columns: Date, Exercise, Set, Weight, Reps, Notes. One row per set, filled in between sets, not from memory afterwards. Paper is fastest at the gym and useless for maths; a spreadsheet adds volume and estimated 1RM with two formulas but is slow to type on a phone; an app removes the typing and does the sums for you. Copy the template below, use it for three weeks, then decide which format you can keep.
Most workout log templates fail in one of two ways. Either they ask for fifteen columns and get abandoned by the second week, or they ask for so little that six months later nothing in them can answer "am I stronger than I was?" The template below sits between those failures: six columns, one row per set, and enough structure that a spreadsheet or an app can do the maths on it later. Copy it, print it, or paste it into a sheet — the same columns work in all three.
The template
One row per set. Date and Exercise repeat on every row, which looks wasteful on paper but is what makes the log sortable and searchable later.
| Date | Exercise | Set | Weight | Reps | Notes |
|---|---|---|---|---|---|
Here is one filled session so the shape is clear. Weight is in kilograms, but the template is unit-agnostic — pick one and never mix.
| Date | Exercise | Set | Weight | Reps | Notes |
|---|---|---|---|---|---|
| 2026-09-11 | Back squat | 1 | 100 | 5 | |
| 2026-09-11 | Back squat | 2 | 100 | 5 | |
| 2026-09-11 | Back squat | 3 | 100 | 5 | Owned all reps, add 2.5 next time |
| 2026-09-11 | Bench press | 1 | 80 | 8 | |
| 2026-09-11 | Bench press | 2 | 80 | 8 | |
| 2026-09-11 | Bench press | 3 | 80 | 7 | Missed the last rep |
| 2026-09-11 | Barbell row | 1 | 70 | 10 | |
| 2026-09-11 | Barbell row | 2 | 70 | 10 | |
| 2026-09-11 | Barbell row | 3 | 70 | 10 | |
| 2026-09-11 | Plank | 1 | 0 | 60 | Seconds, not reps |
Ten rows, three lifts and a finisher, about ninety seconds of writing spread across a session. That is the cost of a log that can later tell you your squat moved 10 kg in a quarter.
What each column is for
Date. Write it in year-month-day order, 2026-09-11, on every row. It sorts correctly in any spreadsheet and never gets confused between day-first and month-first readers. This column is what turns a pile of sets into a history.
Exercise. Use the same name every time. "Bench", "bench press" and "BP" are three different exercises to a spreadsheet, and the search for your best bench set will miss two of them. Decide the name once and keep it.
Set. A counter, 1, 2, 3. Its main job is showing whether the third set dropped a rep, which is the earliest sign a weight is heavy for you.
Weight. The load on the bar or the stack, in one unit, for the whole log. For bodyweight movements write 0 or the added weight; for timed holds, treat Reps as seconds and say so in Notes.
Reps. Completed reps, not attempted. A missed rep is information; a rep rounded up is a lie the log will tell you back in a month.
Notes. Short and optional. The useful notes are about the next session — "add 2.5", "felt heavy, repeat" — not a diary entry. Leaving it blank is fine.
Notice what is missing: rest time, RPE, tempo, mood. All are legitimate, and all are the columns that stop getting filled in first. Add one when you have a specific question only that column can answer.
The spreadsheet version
Paste the six headers into row 1 of a Google Sheet or an Excel workbook, with Date in column A, Exercise in B, Set in C, Weight in D, Reps in E and Notes in F. Then add two computed columns.
Column G, volume per set. In G2, type:
=D2*E2
That is weight times reps — the unit of training work. Fill it down. For the plank row above it will produce 0, which is correct: timed holds do not belong in a load-based volume number.
Column H, estimated one-rep max. In H2, type:
=D2/(1.0278-0.0278*E2)
This is the Brzycki formula. For the 100 × 5 squat set it gives 112.5 kg; for the 80 × 8 bench set, 99.3 kg. It is an estimate of the heaviest single you could probably lift, computed from a set you actually did, and its job is to let a week of fives and a week of eights land on the same chart. It is reasonable up to about ten reps and drifts optimistic beyond that, so wrap it if you like: =IF(E2>10,"",D2/(1.0278-0.0278*E2)).
Session and weekly totals. Somewhere off to the side, a date and a sum:
=SUMIF(A:A,"2026-09-11",G:G)
gives that day's volume. For a week, sum the days, or add a column I with =WEEKNUM(A2) and use =SUMIF(I:I,37,G:G) for week 37. The number you are watching is whether this week's total is up, level or down against last week's.
Best estimated 1RM per exercise. With the exercise name in a cell, say K2:
=MAXIFS(H:H,B:B,K2)
returns your best estimated max for that lift across the whole log. Put five exercises in K2 to K6 and you have a personal records panel that updates every time you add a row.
That is the whole spreadsheet: six typed columns, two formulas per row, three summary formulas. Charts, conditional formatting and per-muscle splits are optional, and are where the hobby begins. The thing to be honest about is the capture step: every row still means tapping into four cells on a phone keyboard between sets, and that is what decides whether the sheet has data in it in November.
The paper version
Print the six-column table with about thirty blank rows per page — enough for a full session with room to spare — and keep the pages in a folder or a clipboard in your gym bag. Three details make the paper version work better than a blank notebook:
- Pre-print the date column blank, not the exercise names. Programmes change; a page with your old exercises printed on it is a page you skip.
- Leave a wide Notes column and a narrow Set column. The natural instinct is the opposite, and it produces cramped notes and a set column nobody uses.
- Write last session's numbers in pencil at the top of the page before you train. Paper cannot prefill anything, so you do it by hand. Knowing you did 100 × 5 × 3 last time is the whole point of a log during the session, not after it.
Paper's advantage is honest: it is the fastest capture there is and nobody has ever been distracted by a notification on a clipboard. Its costs are equally honest: no maths, no search, and one lost folder or wet gym bag deletes the history. If you use paper, photograph each finished page or transfer the rows into a sheet once a week.
Paper vs spreadsheet vs app
Three formats, four things that matter. "Survival past week 3" is the one that decides the rest, because a log with gaps cannot answer any question reliably.
| Paper | Spreadsheet | App | |
|---|---|---|---|
| Capture speed at the gym | Fastest: pen, six characters per set | Slowest: four phone-keyboard cells per set | Fast: three taps per set with last session prefilled, or one spoken sentence |
| Maths (volume, e1RM, records) | None; done by hand or never | Full, once the formulas are in place; maintained by you | Automatic from raw sets, nothing to maintain |
| Search ("best bench triple in March") | Flip pages | Filter and sort, works well | Per-exercise history, records by month |
| Survival past week 3 | High at first, then pages go missing | Low; the phone-entry cost wears people down | Highest where capture is near-instant; otherwise no better than a sheet |
Each format is strong exactly where the previous one is weak. Paper wins capture and loses everything after; the spreadsheet wins the maths and loses capture. An app is only worth the switch if it recovers the capture speed of paper while keeping the maths of the sheet — that is the whole test to apply when choosing one.
How to fill the template in so it lasts
The template is the easy part. These habits are what keep it full.
- Log between sets, not after the session. Memory rounds weights up and forgets sets. The number written while the bar is still loaded is the true one.
- Every set, not just the top set. Volume needs all of them, and a log that only holds top sets quietly understates your leg and back work.
- Same name, same unit, forever. The log is only searchable if "bench press" is always "bench press" and kilograms never turn into pounds halfway through a page.
- Read last session before you start. Public health guidance from the NHS and the CDC asks adults for strength work on at least two days a week; the log's job is to make each of those days measurably a little more than the last, which only happens if last session's numbers are in front of you.
- Review once a week, briefly. Volume up or down against last week, and did any lift's estimated max move. That is the whole review; a longer one is a hobby, not what makes you stronger.
When the template stops being enough
There is a moment, usually in the second month, when the template is working — the rows are there, the formulas are correct — and the problem is no longer the template. It is the typing per session, the PR you set on Tuesday and did not notice until Sunday, or the sheet you stopped opening because the phone keyboard between sets was the worst part of training.
That is the point at which the same six columns are better held by an app. Strongbro is built around exactly this row shape, with the capture step shortened and the maths taken out of your hands:
- Capture is either the keypad — weight × reps in large digits, last session prefilled, one tap on the arrow to log a set that matches last time — or voice logging, where one sentence like "bench 80, three sets of ten" becomes structured sets you review before saving. Both write the same Date, Exercise, Set, Weight, Reps rows this template does.
- Maths happens on every saved set. Personal records checks each set against your history for two kinds of PR — best weight at each rep count and estimated one-rep max, using the same Brzycki formula as the sheet above — and shows the heaviest lift per exercise per month. Volume, the change against last month and a list of lifts ready for the next increment come from the same rows without a formula to maintain.
- Search is a tap on an exercise: best weight, estimated 1RM, session count and every past set, with any day editable.
If you would rather stay with a minimal log for now, the simple workout log guide makes the case for exactly that, and how to track gym progress on iPhone covers what to do with the numbers once you have them — the four figures worth reviewing and the five-minute weekly loop that turns a full log into a decision.
The bottom line
A workout log template is six columns: Date, Exercise, Set, Weight, Reps, Notes, one row per set. On paper it is the fastest thing you can carry into a gym. In a sheet, two formulas — =D2*E2 for volume and =D2/(1.0278-0.0278*E2) for estimated 1RM — turn those rows into the two numbers that prove progress. In an app, the same rows are captured in three taps or one sentence and the maths does itself. Pick the format you will still be filling in at week three, then keep the columns and the habit for as long as you train.
Get Strongbro on the App StoreFree for 3 days. $19.99 once for lifetime.
Frequently asked questions
What columns does a workout log need?
Six: Date, Exercise, Set number, Weight, Reps, and Notes. Everything useful — weekly volume, estimated one-rep max, personal records — is computed from those. Columns like RPE, rest time or tempo are optional and tend to be abandoned by week three, so add them only if you will actually fill them in every session.
Is a Google Sheets workout log good enough?
For the maths, yes: two formulas give you per-set volume and estimated 1RM, and a SUMIF gives you weekly totals. The weak point is capture. Typing a date, an exercise name and two numbers into a phone-sized cell between sets is slow enough that most sheets go quiet after a few weeks. If yours has survived six months, keep it.
How do I calculate volume in a workout log?
Volume is weight multiplied by reps for each set, then summed. In a spreadsheet, with weight in column D and reps in column E, the per-set formula is =D2*E2. Sum that column per session or per week and you have the number that tells you how much work you did compared with last week.
How do I estimate my one-rep max from the log?
Use the Brzycki formula: weight divided by (1.0278 minus 0.0278 times reps). In a sheet that is =D2/(1.0278-0.0278*E2). It is reliable up to about ten reps and it is an estimate for tracking direction, not a reason to attempt a true max. Watch the trend across weeks, not one day's number.
Should I log warm-up sets?
Log working sets always, and warm-ups only if you want them in your volume totals. Most lifters leave warm-ups out so the volume number reflects real training stress. If you do log them, mark them in the Notes column so they can be filtered out of your sums later.
How long should I keep a workout log?
Indefinitely. The value of a log compounds: your best set on bench in March is only useful if you can find it in September. Paper logs get lost, so photograph each page or transfer the numbers weekly. A spreadsheet or app keeps the history searchable as long as you keep the file or the account.
Paper, spreadsheet or app — which should a beginner use?
Whichever you will still be filling in after week three. Paper if you want zero friction on day one and do not care about maths yet; a spreadsheet if you enjoy the formulas; an app if you want the sums, records and search without typing. The format matters less than the habit of logging every set during the session.
What this is based on
Get Strongbro on the App StoreFree for 3 days. $19.99 once for lifetime.