# Strength workout log Excel (free) + online

> Free Excel gym log: record sets, reps and weight and get volume, estimated 1RM, personal records, weekly volume and volume per muscle group. Excel or online.

Source: https://softwiro.com/blog/strength-workout-log-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Strength workout log in Excel (free): sets, volume, estimated 1RM and personal records

Log each set once and see every exercise's volume, estimated 1RM and records, plus your weekly volume.

13 November 2026 6 min read

## In short

- Log each set once: date, exercise, reps and weight.
- Volume and an estimated 1RM (Epley) are worked out for every set.
- Per exercise: best 1RM, heaviest weight, last date and a record flag.
- Volume for the last 8 weeks and per muscle group. A log, not medical advice.

Anyone who trains with weights knows memory is not enough: did you lift more last week than this week? Is today's squat really heavier than last month's? The free [strength workout log sheet](https://softwiro.com/templates/strength-workout-log) records every set and works out its volume, an estimated one-rep max (1RM) and your personal records, so you see your progress on one page.

## The problem it solves

When you jot your workout in a notes app or on paper, you know what you lifted today but not the direction of the weeks: is your training volume rising or falling, which exercise reached its best level and which slipped. Here you enter each set once and the sheet does the rest, summarised per exercise, per week and per muscle group.

## Steps from opening the file to your progress

1. Settings: your name, body weight and the date of the first day of the current week (for example Saturday), then your exercises (up to 30) and the muscle group of each.
2. Workouts: log each set in a row: the date, the exercise from the list, the set number, the reps and the weight in kg, and the RPE effort score if you like.
3. For every row the sheet works out the volume (reps × weight), the estimated 1RM and the muscle group.
4. Open Progress for each exercise's number of sets, volume, best 1RM, heaviest weight and last date, and whether the last session was a record.
5. At the top of Progress are your volume for each of the last 8 weeks and your volume per muscle group. Update the week-start date in Settings every week and the tables move with it.

## Worked example (sample data)

The name and figures are sample data for an example athlete with a body weight of 82 kg, and the week start is 7 November 2026. 64 sets were logged with a total volume of **27,127.5** kg, one of them for an exercise that is not on the list:

- Bench press: 18 sets, volume 7,585, best 1RM 87.5 (75 kg × 5 reps), heaviest weight 75. The last session, on 9 November, had a best 1RM of 84.58 (72.5 × 5), so no record is shown.
- Squat: 15 sets, volume 8,320, best 1RM 122.5 (105 × 5), heaviest weight 110. The last session (2 November) is the best level, so "new record" shows. Its ratio to body weight is 1.49.
- Deadlift: 9 sets, volume 4,170, best 1RM 138.67 (130 × 2), heaviest weight 130, and a new record on 4 November.
- Bent-over row: 6 sets, volume 2,877.5, best 1RM 79.17, and barbell biceps curl: 6 sets, volume 1,685, best 1RM 43.33. Both show a new record.
- Overhead press: 9 sets, volume 2,290, best 1RM 47.5 (37.5 × 8 on 28 October); the last session (11 November) gave 44.33, so no record.
- Exercises with a record: 4 of 6.
- Weekly volume: the week of 31 October was 4,227.5 kg in 10 sets, up 60.1% on the week before (2,640). The current week, which started on 7 November, is 2,595 in 9 sets; it is not over yet, so it shows −38.6%.
- By muscle group: chest 7,585, legs 8,320, back 7,047.5, shoulders 2,290 and arms 1,685.
- Unlisted exercise: one set with a volume of 200 was entered under an exercise name that is not on the list. It is not lost from the total and shows "not found" in the muscle-group column so you can correct the name.

## How the numbers are worked out

- Volume = reps × weight in kg.
- Estimated 1RM (Epley formula) = weight × (1 + reps ÷ 30). For example 105 × (1 + 5 ÷ 30) = 122.5.
- Record: shown when the best 1RM on an exercise's last training day equals or exceeds the best 1RM you have logged for it over all time.
- Change on the previous week = the week's volume ÷ the previous week's volume − 1.

## Limits and tips

- The 1RM here is an estimate, not a weight you have tested, and it is less accurate beyond 10 reps. Do not load a heavy weight just because the sheet estimated it.
- The sheet only logs your training. It is not a training programme or medical or nutrition advice, and it does not replace a coach, a doctor or a dietitian; consult them before lifting heavy weights.
- Pick the exercise from the list instead of typing it; one wrong letter makes it "not found". Do not delete a row from the middle of the exercise list.
- For a bodyweight exercise (such as pull-ups) enter the added weight or your body weight, and stay consistent with whichever you choose.
- Do not delete or type in the four hidden columns (J to M) on the Workouts sheet; they are used for the calculations.
- The sheet does not write you a plan or suggest raising your loads, and it sends no alerts or shows your training to your coach unless you send them the file.

## Try it

[Open the sheet and try it online, or download it for Excel](https://softwiro.com/templates/strength-workout-log). It holds 1500 sets and 30 exercises. If you want an app where your coach follows his athletes' progress, [ask for it here](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: strength training (1/4)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-1.jpg)[![Cheat sheet: strength training (2/4)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-2.jpg)[![Cheat sheet: strength training (3/4)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-3.jpg)[![Cheat sheet: strength training (4/4)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-4.jpg)](https://softwiro.com/uploads/cheatsheets/strength-workout-log/en-4.jpg)

0 downloads · 4 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I work out my one-rep max (1RM) in Excel?

Log the weight and reps on the Workouts sheet and the sheet estimates it with the Epley formula: 1RM = weight × (1 + reps ÷ 30). For example 75 kg × 5 reps = 87.5 kg. It is an estimate, less accurate beyond 10 reps, and not a weight you have tested.

### What does "volume" mean and should I raise it every week?

Volume = reps × weight in kg, and a week's volume is what you lifted in it. The Progress sheet shows the volume of each of the last 8 weeks and its change on the week before. It tells you only what you did; ask your coach how much to increase.

### When does "new record" show next to an exercise?

It shows when the best 1RM on the exercise's last training day equals or exceeds the best 1RM you have logged for it over all time. If your last day was weaker than your best day, it does not show.

### Does the sheet replace a coach, a doctor or a dietitian?

No. It is only a log of your training, not a training programme or medical or nutrition advice. Consult a coach or a doctor before lifting heavy weights or if you have an injury or illness.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
