Softwiro
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.

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

Example from the “التقدم” tab (Arabic), with the numbers and formulas that are in the file.
التمرينالمجموعةالمجموعاتالحجم (كجم)أفضل 1RMأثقل وزنآخر تاريخ1RM آخر تمرينالرقم القياسي
بنش برسصدر187,585.087.575.04633584.6
سكواتأرجل158,320.0122.5110.046328122.5رقم قياسي جديد
ديدلفتظهر94,170.0138.7130.046330138.7رقم قياسي جديد
أوفر هيد برسأكتاف92,290.047.537.54633744.3
سحب بار منحنيظهر62,877.579.262.54632879.2رقم قياسي جديد
بايسبس بارذراعين61,685.043.332.54633543.3رقم قياسي جديد
ليج برسأرجل00.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.

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)Cheat sheet: strength training (2/4)Cheat sheet: strength training (3/4)Cheat sheet: strength training (4/4)
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 sheetIn 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 · Ask for a demo

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

More free templates for: Gyms and fitness

More free templates

All templates · Free tools