# Strength workout log (free Excel template)

> Free Excel strength training log: enter reps and weight per set to get volume, estimated 1RM, personal records and weekly training volume for the last 8 weeks.

Source: https://softwiro.com/templates/strength-workout-log
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Strength workout log

A free Excel sheet for logging strength training. You enter each set on its own row (date, exercise, reps and weight) and the sheet works out its volume and an estimated one-rep max (1RM). For each exercise you then see the number of sets, best 1RM, heaviest weight and the last time you trained it, and whether you set a personal record. It also shows your training volume for each of the last 8 weeks and for each muscle group.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-strength-workout-log.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-strength-workout-log-blank.xlsx)

Excel file (.xlsx) · 210 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| التمرين | المجموعة | المجموعات | الحجم (كجم) | أفضل 1RM | أثقل وزن | آخر تاريخ | 1RM آخر تمرين | الرقم القياسي |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| بنش برس | صدر | 18 | 7,585.0 | 87.5 | 75.0 | 46335 | 84.6 |  |
| سكوات | أرجل | 15 | 8,320.0 | 122.5 | 110.0 | 46328 | 122.5 | رقم قياسي جديد |
| ديدلفت | ظهر | 9 | 4,170.0 | 138.7 | 130.0 | 46330 | 138.7 | رقم قياسي جديد |
| أوفر هيد برس | أكتاف | 9 | 2,290.0 | 47.5 | 37.5 | 46337 | 44.3 |  |
| سحب بار منحني | ظهر | 6 | 2,877.5 | 79.2 | 62.5 | 46328 | 79.2 | رقم قياسي جديد |
| بايسبس بار | ذراعين | 6 | 1,685.0 | 43.3 | 32.5 | 46335 | 43.3 | رقم قياسي جديد |
| ليج برس | أرجل | 0 | 0.0 |  |  |  |  |  |

Example from the “التقدم” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- “الإعدادات” (Settings): Your name, body weight and the date of the first day of the current week, plus your list of exercises (up to 30) and the muscle group for each.
- “التمارين” (Exercises): A record of each set: date, exercise from the list, set number, reps, weight in kg and RPE (rate of perceived exertion, optional). For each row it works out the volume, the estimated 1RM and the muscle group. It holds up to 1,500 sets.
- “التقدم” (Progress): At the top: total sets, volume and the number of exercises with a personal record, your volume for each of the last 8 weeks and its change from the previous week, and your volume for each muscle group. Below it, for each exercise: sets, volume, best 1RM, heaviest weight, last date, personal record and 1RM as a ratio of your body weight.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

You record each set once, and the volume, estimated 1RM, personal record and weekly figures come out of it. You can see whether you are really progressing or standing still, instead of comparing from memory or across scattered pages.

## How to use it

1. In the “الإعدادات” (Settings) tab, enter your name, body weight and the date of the first day of the current week (for example Saturday). Then enter your exercises (up to 30) and their muscle groups.
2. In the “التمارين” (Exercises) tab, record each set on a row: date, exercise from the list, set number, reps and weight in kg, and RPE if you want.
3. For each row the sheet works out the volume (reps × weight), the estimated 1RM and the muscle group.
4. Open the “التقدم” (Progress) tab to find, for each exercise, the number of sets, volume, best 1RM, heaviest weight, last date, and whether the last session was a personal record.
5. At the top of “التقدم” is your volume for each of the last 8 weeks and for each muscle group, so you can tell whether you are going up or down.
6. Update the week start date in “الإعدادات” every week, and the weekly tables move with it.

**Before you start:**

- Volume = reps × weight in kg. Estimated 1RM by the Epley formula = weight × (1 + reps ÷ 30). It is a rough estimate and gets less accurate above 10 reps.
- Personal record: “رقم قياسي جديد” appears next to an exercise if the best 1RM on its last training day equals or exceeds the best 1RM you have recorded over all time.
- For a bodyweight exercise (such as pull-ups), enter the added weight or your body weight, whichever you prefer to compare, and stay consistent with it.
- An exercise name that is not in “الإعدادات” (Settings) shows “غير موجود” (not found) in the muscle group column. It is left out of the exercise table but counted in the total.
- The four hidden columns in “التمارين” (J to M) are helper columns for the calculations; do not delete them or type in them.
- This sheet is only for recording your training. It is not medical advice or a training programme; consult a coach or doctor before lifting heavy weights. It holds 1,500 sets and 30 exercises.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-strength-workout-log.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-strength-workout-log-blank.xlsx)

Excel file (.xlsx) · 210 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## 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)

## Frequently asked questions

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

Enter the weight and reps in the “التمارين” (Exercises) tab 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 a rough estimate that gets less accurate above 10 reps, and it is not a weight you have actually lifted.

### What does “volume” mean, and should I increase it every week?

Volume = reps × weight in kg, and a week's total is what you lifted that week. The “التقدم” (Progress) tab shows each week's volume for the last 8 weeks and its change from the week before. It only tells you what you did; ask your coach how much of an increase suits you.

### When does “رقم قياسي جديد” (new personal record) appear next to an exercise?

It appears when the best 1RM on the last day you trained that exercise equals or exceeds the best 1RM you have recorded for it over all time. If your last day was weaker than your best day, it does not appear.

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

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

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Gyms and fitness

## More free templates

- Gym memberships tracker (Excel)
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Basketball player game stats
- Swimming times and personal bests
- Martial arts and boxing training log
- Tennis and padel match log
- Athletics results and personal bests log
- Padel and 5-a-side court booking sheet (hourly)
- Ad budget media plan across platforms
- Ad campaign performance tracker
- Ads A/B test log
- Ads break-even and unit economics sheet
- Ad agency client management and reports
- UTM link builder and campaign naming
- Ad account audit checklist
- Ads creative production calendar

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
