A useful workout log spreadsheet records each exercise set on its own row, so you can compare sessions and see changes in repetitions, load, and training volume. In Excel for Microsoft 365 on Windows, create columns for date, session, exercise, set, reps, load, unit, effort, calculated volume, and notes; the example below includes a formula you can copy down.
A practical workout log template
Start with one row per completed set, rather than one row per workout. That makes it easier to filter for a particular exercise or date and to record different weights and repetitions across sets. Use these headers in row 1:
| Date | Session | Exercise | Set | Reps | Load | Unit | RPE | Volume | Notes |
|---|---|---|---|---|---|---|---|---|---|
| 2026-11-03 | Upper body | Bench press | 1 | 8 | 40 | kg | 7 | 320 | Controlled reps |
This sample row describes eight repetitions at an external load of 40 kg. “Volume” here means load multiplied by repetitions for that set, so 8 × 40 = 320 kg-repetitions. It is a simple tracking measure, not a complete measure of training stress or a recommendation about how much to lift. If you use pounds, keep the unit consistent when comparing totals; do not combine kilograms and pounds as if they were the same measurement.
Enter the date for each set, or fill it down for all sets in the same session. Repeat the session and exercise labels where needed rather than relying on blank cells to mean “same as above.” Repeated values make filtering, sorting, and later summaries more reliable. The example date is illustrative; use the date format and units that make sense for your log.
How to build it in Excel
- Open a blank workbook and enter the ten headers in row 1. Keep the header names short and distinct, since you will use them to identify columns.
- Enter each working set on a separate row. For example, a three-set exercise with different repetitions gets three rows, not one row with “8, 8, 6” in the Reps cell.
- Select the header row and the rows you have entered, then press Ctrl+T on Windows. Confirm that “My table has headers” is selected and choose OK. On Mac, use Insert > Table if the Windows shortcut differs in your Excel setup.
- Format the Date column as a date and the Load and Volume columns as numbers. Choose decimal places only if your equipment or activity calls for them.
- Save the workbook with a clear name, then add new set rows to the table as you train. Excel tables can extend as you type directly below them, and table filters help narrow the log.
To keep the headers visible while scrolling, use View > Freeze Panes > Freeze Top Row. If you want dropdowns for recurring session names or units, select the entry cells and use Data > Data Validation; create a short list such as “kg,lb” for the Unit column. A dropdown can reduce spelling variations, but it does not convert one unit into another.
Calculate set volume with a formula
A formula can calculate the basic volume measure without requiring you to multiply each set by hand. With the template layout above—repetitions in E2, load in F2, and volume in I2—enter this formula in I2:
=IF(OR(E2="",F2=""),"",E2*F2)
For the example row, E2 is 8 and F2 is 40, so the result is 320. If either input is blank, the cell stays blank rather than displaying a misleading zero. Copy the formula down the Volume column; if the data is in an Excel table, Excel may fill the formula through that table column automatically. Check the first few results after copying, especially if you pasted data from another source.
The calculation is appropriate only when repetitions and load are numeric and the load is an external weight. It does not produce a meaningful comparable value for every activity. For bodyweight movements, the actual resistance is not necessarily the athlete’s full body mass, and for running or cycling, distance, time, pace, or power may be more useful. You can leave Load blank for those rows or use a separate activity-specific log rather than treating unlike exercises as directly comparable.
Choose what else to record
A log works best when it captures information you will actually use. Start with the basics, then add fields only when they answer a question you have about your training. Useful optional columns include:
- Duration: helpful for timed intervals, cardio, or sessions where elapsed time matters.
- Distance: useful for running, walking, cycling, and other distance-based activities.
- Rest: record the rest interval if you are trying to keep it consistent between sets.
- Effort: RPE, or rate of perceived exertion, can capture how hard a set felt. Agree on a consistent scale and interpretation before comparing entries.
- Notes: record a brief context such as equipment variation, a planned modification, or discomfort that affected the session.
For strength training, sets, reps, load, and exercise name are often enough to answer basic questions such as whether a lift was performed with more repetitions or a heavier load than before. For a general fitness routine, session type and duration may matter more. Avoid turning the sheet into a diary of every possible detail: extra fields add typing and can make consistent logging harder.
Use the log to compare sessions
Once several sessions are recorded, the table makes it possible to filter by exercise, date, or session type using the dropdown arrows in the header row. You can then compare like with like: the same exercise, similar equipment, and a comparable range of repetitions. A heavier set is not automatically evidence of progress if the movement, range of motion, assistance, or effort changed substantially.
To review trends, consider a separate summary sheet rather than adding hand-calculated totals to the raw log. A simple chart of load or repetitions for one selected exercise can make changes easier to see, while a weekly view can help you check how often you trained. If you make a summary, define what it counts: total sessions, total sets, distance, or load-times-repetitions are different measures. A single “workout score” can conceal those differences.
Keep the original entries as a record. If a row is wrong, correct it and, when the reason matters, explain the correction in Notes. Avoid sorting only one column: select a cell in the Excel table and use its filter or sort control so each row stays intact. Before making large structural changes or importing old logs, save a copy of the workbook.
Common spreadsheet problems
- Mixed units: a row in pounds and another in kilograms can make a comparison or sum misleading. Record the unit on every relevant row, or choose one unit for the whole log.
- Inconsistent exercise names: “DB row,” “dumbbell row,” and “one-arm row” may refer to the same movement, but Excel treats those labels as different text. Use a consistent naming convention or a dropdown list.
- Blank cells used as shorthand: leaving Date or Exercise empty because it matches the row above can complicate filters and summaries. Repeat those values on each set row.
- Numbers stored as text: pasted entries may look like numbers but fail in calculations. If the volume formula does not calculate, check that Reps and Load contain numeric values and remove stray spaces or unit text from those cells.
- Overinterpreting volume: load × reps is a convenient arithmetic total, not a universal measure of effort, recovery, or workout quality. Compare equivalent exercises and conditions, and use other context where appropriate.
Also distinguish a planned workout from a completed one. If you want both, add a Status column with values such as Planned and Done, or keep the plan on a separate sheet. Otherwise, a future target can accidentally be counted alongside actual training.
Spreadsheet versus app or paper log
An Excel workbook is a good fit when you want control over the fields, formulas, and history, or when you already use Excel. It can be adapted to strength training, cardio, mobility, or a mixture, and you can keep a local copy. It does require manual entry and a little care with formulas, units, and backups. Excel for the web can open and edit workbooks in a browser, but some features and interface details can differ from Microsoft 365 for Windows.
A dedicated training app may offer a faster phone interface, exercise libraries, timers, or built-in charts. Those conveniences depend on the app and may involve account requirements or paid features. A paper notebook is simple, works without a device, and is easy to annotate, but searching and calculating totals takes more effort. The right choice is the one you can use consistently; there is no need to move a well-maintained paper log into a spreadsheet unless the spreadsheet solves a real problem.
Privacy, backups, and safe use
A workout log can reveal routines, locations, and personal health-related notes. Store it where you are comfortable keeping that information, limit sharing permissions if it is in cloud storage, and avoid putting sensitive details in a file that other people can access. If a coach or training partner needs a copy, share only what is useful and check that the workbook does not contain unrelated personal information.
Back up the workbook periodically, especially before editing formulas, importing data, or reorganizing sheets. A copy in another secure location can protect against accidental deletion or file damage. The spreadsheet itself is only a recordkeeping tool: it cannot determine whether a movement is safe for you or diagnose pain. Stop an activity that causes concerning symptoms and seek appropriate guidance from a qualified health professional when needed.
Frequently Asked Questions
What should a workout log spreadsheet include?
A basic log needs the date, exercise, set number, repetitions, and load when applicable. Session type, effort, duration, distance, and notes are useful additions when they help you review your own training.
Should I use one row per workout or one row per set?
Use one row per set if you want to compare repetitions and loads set by set. A one-row-per-workout layout can be simpler for brief notes or cardio sessions, but it is less convenient when sets differ.
How do I calculate workout volume in Excel?
For a set with repetitions in E2 and external load in F2, use =IF(OR(E2="",F2=""),"",E2*F2). Eight reps at 40 kg returns 320 kg-repetitions. Keep units consistent and do not treat this as a complete measure of training stress.
Can I use the same spreadsheet for cardio and strength training?
Yes, but the useful fields differ. Keep shared fields such as date and activity, and add cardio-specific fields such as time or distance. Avoid comparing a cardio measure with strength-training volume as though they were equivalent.
Is Excel or a workout app better?
Excel gives you flexibility and editable history; an app may make phone entry, timers, and exercise selection easier. Paper is another valid option. Choose based on which method you are most likely to maintain and the features you actually need.
Related
- How to Add Speaker Notes to Canva Presentations
- Daily Expense Tracker Spreadsheet: How to Build and Use One
- How to Add Slide Transitions in PowerPoint: A Quick Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Keyboard Shortcut to Duplicate a Sheet QuicklyIn Excel for Microsoft 365 on Windows, there is no single dedicated key combination that instantly duplicates a…
- Google Sheets Calendar: Create and Customize a Month ViewCreate a calendar view in Google Sheets by entering the first day of a month in cell B1,…
- Excel Keyboard Shortcuts: Options for Every TaskExcel keyboard shortcut options include built-in key combinations, ribbon Key Tips, the Search box, and commands added to…
- Google Sheets Checkbox Column: Add and Use CheckboxesTo add a checkbox column in Google Sheets, select the cells where the checkboxes should go, then choose…
- How to Open SharePoint Files in the Excel AppTo open a SharePoint workbook in the desktop Excel app, find the file in its SharePoint document library,…
- Excel Redo Shortcut: The Quick Key and When It WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Y to redo the last action you undid. On a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.