Softwiro
Free Excel template

Martial arts and boxing training log

A free Excel sheet for logging boxing, karate, judo, taekwondo and Muay Thai training. Log each session in one row (date, type, length, rounds, perceived effort RPE and body weight) and the sheet works out the session load and round time. The weekly sheet then shows the last 10 weeks and the change in your average weight, a weight-cut panel for your competition class with the kilograms remaining and the weekly loss required, a warning when it goes past the limit you set, and a table for your belt and grade history.

Excel file (.xlsx) · 173 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.
بداية الأسبوعالحصصالدقائقالجولاتجولات السباراجحمل التدريبمتوسط RPEمتوسط الوزن (كجم)تغير الوزن عن الأسبوع السابقتنبيه الوزن
46333528526141,8506.469.40-0.20
46326530526142,1356.869.60-0.20
46319532526142,1306.669.80-1.50نزول سريع
46312528526141,8506.471.30-0.20
46305530526142,1356.871.50-0.30
46298532526142,1306.671.80-0.00
46291632529142,2106.871.80-0.10
46284530526142,1356.871.90-0.10
46277532526142,1306.672.00-0.10
46270528526141,8506.472.10

Example from the “الأسبوعي” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • «الإعدادات» (Settings): The athlete's name, sport, weight class, target class weight, today's date and the competition date, plus the weekly weight-loss warning limit and default round length, and the lists of sports, session types, belts and grades.
  • «الحصص» (Sessions): For each session: date, type from the list, length in minutes, number of rounds, round length, RPE, your weight and a note. For each row it calculates the session load (minutes x RPE) and the round time, and writes an alert if the date or length is missing. It holds 1,500 sessions.
  • «الأسبوعي» (Weekly): For each of the last 10 weeks: sessions, minutes, rounds, sparring rounds, load, average RPE, average weight and its change from the previous week. Below it are the competition weight-cut panel and the table of belts and grades with your current belt.

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

What makes it different

Log each session once and get the training load, the weekly totals and a weight panel out of it, so you know whether your load is rising or falling and whether your cut to the competition class is steady or faster than it should be, instead of estimating from memory or loose papers.

How to use it

  1. In the «الإعدادات» (Settings) sheet, enter the athlete's name, sport, target class weight in kilograms, today's date and the competition date, and review the lists of session types and belts.
  2. In the «الحصص» (Sessions) sheet, log each session in one row: the date, its type from the list, its length in minutes, the number of rounds and the round length (leave it empty to use 3 minutes).
  3. Enter your perceived effort RPE from 1 (very light) to 10 (maximum effort), and your weight in kilograms on the days you weigh yourself.
  4. Leave the grey columns alone: session load = minutes x RPE, and round time = number of rounds x round length.
  5. Open the «الأسبوعي» (Weekly) sheet to see the last 10 weeks: sessions, minutes, rounds, sparring rounds, load, average weight and its change.
  6. In the weight-cut panel, check the kilograms remaining to the class, the days left and the weekly loss required, and log your belts and grades in their table at the bottom of the sheet.

Before you start:

  • Warning: cutting weight quickly before a competition is a health risk (dehydration, exhaustion and injuries). The sheet is not medical advice; consult a doctor and your coach before any plan.
  • The default warning limit is 1 kg per week, and many people consider 0.5 to 1 kg per week a reasonable limit. Change it in «الإعدادات» (Settings) as your doctor advises.
  • Session load = minutes x RPE. It is a personal indicator for comparing weeks, not a precise scientific measure. A session without an RPE gets no load.
  • The weekly average weight depends on the days you logged your weight, and the current weight is the weight on the last day recorded in the weight column.
  • Sparring rounds count only sessions of the "sparring" type; competition bouts are included in total rounds, round time and load.
  • The sheet holds 1,500 sessions; do not delete a row from the middle of the list. The sheet's week starts on Saturday and ends on Friday.

Excel file (.xlsx) · 173 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: boxing and martial arts (1/3)Cheat sheet: boxing and martial arts (2/3)Cheat sheet: boxing and martial arts (3/3)
0 downloads · 3 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 training load with RPE in Excel?

Enter the session length in minutes and your RPE (perceived effort) from 1 to 10 in the «الحصص» (Sessions) sheet, and the sheet calculates load = minutes x RPE. For example, a 70-minute sparring session at an effort of 8 is 560. It is a personal indicator for comparing one week with another, not a precise scientific measure, and a session without an RPE gets no load.

How do I know how many kilograms I need to lose each week before a competition?

Enter the target class weight and the competition date in «الإعدادات» (Settings) and log your weight in «الحصص» (Sessions). The weight panel in «الأسبوعي» (Weekly) shows the kilograms remaining to the class, the days left and the weekly loss required, and compares it with a warning limit that you set (1 kg by default). If the required loss exceeds the limit, a danger message appears.

Is rapid weight loss safe, and can the sheet replace a coach or doctor?

No. Cutting weight quickly before a competition is a health risk and can cause dehydration, exhaustion and injuries. The sheet is only a tool for logging and calculating; it is not medical advice and does not replace a coach or doctor. Agree the warning limit and weight class with them before starting any plan.

Is it suitable for karate, judo and taekwondo, or only boxing?

It suits any combat sport. You can edit the lists of sports, session types, belts and grades in «الإعدادات» (Settings): boxing, karate, judo, taekwondo, jiu-jitsu, Muay Thai and kickboxing. It also has a table for your belt and grade history.

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