Workout Log Template for Google Sheets: Setup & Tips

A useful workout log template for Google Sheets can be as simple as a table with the workout date, exercise, sets, reps, and weight or resistance. In a browser, create a blank sheet, add those headings, and record each exercise as a separate row; add a formula for training volume if you want an easy way to compare sessions over time.

What a workout log records

A workout log turns the details of a training session into a record you can review later. It can help answer practical questions: Did you complete the planned workout? Has the weight or number of repetitions changed? Which exercises do you tend to skip? A spreadsheet is flexible, so the template can be tailored to strength training, cardio, classes, or a mix.

For strength workouts, a useful distinction is between a session and a set. If an exercise has three sets, you can enter one row for the exercise and put the set results in separate columns, or use three rows so each set has its own weight and reps. The second approach takes more rows but captures changes between sets and makes later calculations more straightforward.

A log is a record, not a measure of overall health or a guarantee of progress. Numbers make some parts of training easier to track, but they do not capture everything, such as technique, sleep, stress, or how difficult a set felt. A short notes field can preserve context without turning logging into a second workout.

Set up the sheet in Google Sheets

Open Google Sheets in a web browser and create a blank spreadsheet. Give the file a clear name, such as Workout Log, and rename the first sheet to Log. Put one field name in each cell of row 1, then use one row per set or exercise entry. To keep the headings visible while you scroll, choose View > Freeze > 1 row. To make it easier to sort and filter entries, select the header row and choose Data > Create a filter.

Start with a small number of fields. You can add detail after you know what you will actually use. For a basic strength log, these headings are a workable starting point:

Date: the day the exercise was performed.
Workout: a short label such as Upper A, Lower, or Full body.
Exercise: the movement name, written consistently.
Set: the set number, if each set gets its own row.
Reps: completed repetitions.
Load: weight used, with the unit stated in the heading or a note.
Notes: optional details such as equipment, a modification, or perceived effort.

Use a real date value in the Date column rather than typing dates in several different styles. Select the date cells and choose Format > Number > Date. For a log used by more than one person, agree on a date and weight convention first. Mixing kilograms and pounds, for example, can make comparisons misleading unless the unit is recorded.

Choose columns that fit the training

The right template depends on what you want to review. A strength trainee may want sets, reps, load, and rest time. Someone tracking running might instead record distance, duration, route, and how the session felt. A class-based routine may need the class type and instructor rather than a row for every movement. Avoid adding columns simply because they seem impressive; a field that is rarely filled in can make the sheet harder to maintain.

For a mixed routine, consider a simple common structure with optional fields. Date, session, activity or exercise, duration, and notes can apply across many kinds of workouts. Add specialized columns only where they make sense, such as distance for running or load and reps for lifting. Blank cells are acceptable when a field does not apply, but separate tabs for very different activities can make data easier to interpret.

Use stable exercise names. If the same movement appears as Bench Press, bench, and Barbell Bench in different rows, a filter or summary may treat those entries as different exercises. You can create a separate Exercises tab as a reference list and use Data > Data validation to offer a drop-down list in the Exercise column. Keep the list manageable and update it when your routine changes.

Record sets and calculate training volume

There are two common ways to lay out strength entries. An exercise-per-row design is compact: enter the total sets, a representative rep target, and the load. It works well for a quick training diary, but it cannot accurately show different results on each set. A set-per-row design is more detailed. For example, a session with three sets of eight repetitions at 50 kg would use three rows, each with the date, exercise, set number, 8 reps, and 50 kg.

If you use one row per set, a volume column can multiply sets, reps, and load when the same values describe all sets on a row. With sets in C2, reps in D2, and load in E2, enter this in F2: =C2*D2*E2. If C2 is 3, D2 is 8, and E2 is 50, the result is 1,200 kg-repetitions. Fill the formula down for later rows. This is a simple workload measure, not a complete measure of training quality; it also assumes the values use consistent units and represent the work you intend to count.

When each set has its own row, use one set per row and calculate reps multiplied by load instead, or leave sets out of the calculation. Do not multiply by a total-set count that is repeated on every individual set row, or the volume will be overstated. For bodyweight movements or assisted exercises, a load figure may not be meaningful, so use notes or a separate field rather than forcing every exercise into the same calculation.

Review a week or compare sessions

Filters help answer simple questions without building a dashboard. Use the filter on the Date column to focus on a period, or filter Exercise to see its entries. For a weekly total, place the first date of the week in H2 and the final date in H3. If dates are in A2:A1000 and calculated volume is in F2:F1000, this formula sums entries from the start date through the end date, including the entire final day: =SUMIFS(F2:F1000,A2:A1000,">="&H2,A2:A1000,"<"&H3+1). If the included rows have volumes of 1,200, 900, and 600, the result is 2,700.

Google Sheets can also turn selected data into a chart using Insert > Chart. A chart is most useful when the data is consistent and the question is clear, such as how weekly running distance changes. For strength logs, a chart of load for one exercise may be more interpretable than a chart combining unrelated movements. Check that the chart uses the right date and value columns, and remember that a heavier recorded load does not by itself show whether repetitions, range of motion, or technique were comparable.

Do not treat a missing entry as a zero. A blank may mean the workout was missed, the field did not apply, or the person forgot to log it. If those cases matter, add a short status field, such as Completed, Rest, or Not logged. Clear definitions make summaries more useful than trying to infer meaning from empty cells.

Make logging quick and consistent

A log is only useful if it is realistic to maintain. Set up the headings once, then record the session shortly after training while the details are fresh. Keep notes brief and specific: for example, “used a lighter dumbbell because the usual pair was unavailable” tells you more than “felt off.” If you record effort, choose one consistent scale and explain it at the top of the sheet; otherwise, ratings from different days may not be comparable.

For a recurring plan, you can add a Plan tab with the intended workout and leave the Log tab for what actually happened. This separates goals from completed work and helps prevent a planned set from being mistaken for a performed one. You can also duplicate a blank weekly layout, but avoid manually copying old workout results into new dates. A clean record makes it easier to see what changed.

Google Sheets saves changes as you work when you are online, and a shared file can be edited by people with appropriate access. That convenience does not replace a backup or a clear ownership arrangement. If several people log workouts in the same file, agree who maintains exercise names and whether users should edit the template itself or only add entries.

Common problems and how to avoid them

Inconsistent units: Label the load as kg or lb and do not combine them in one comparison without converting consistently.
Changing exercise names: Pick a naming convention and use it for each entry so filters and summaries group rows correctly.
Overcomplicated tracking: Begin with a few useful fields. Add a column only when you have a real question it will help answer.
Overwriting formulas: Keep calculated columns separate from manual-entry columns, and check a few results after filling a formula down.
Sorting only part of the table: Use the filter controls or select the full data range before sorting so dates do not become separated from their exercise details.

One common misconception is that more recorded data automatically means better training decisions. A spreadsheet can show patterns, but it cannot tell whether a movement was performed safely or whether a change is appropriate for an individual. Use the log as a memory aid and a way to ask better questions, not as a substitute for sound instruction or medical guidance.

Privacy, sharing, and alternatives

Workout information can reveal routines, locations, or health-related details. Review sharing access before sending a link: in Google Sheets, use the Share button and check who can view or edit the file. Avoid putting sensitive personal information in a broadly shared log. If you use a work or school account, its administrator may control sharing options, so the available choices can differ.

Google Sheets is a good fit if you want a customizable table that works in a browser and supports collaboration. A dedicated fitness app may be more convenient for features such as exercise libraries, timers, or automatic charts, while a paper notebook may be better if you do not want a screen at the gym. A spreadsheet offers flexibility, but you may need to build and maintain the layout yourself. Excel can open spreadsheet files and supports basic arithmetic and SUMIFS, though its menu labels and collaboration experience differ from Google Sheets.

Frequently Asked Questions

Does Google Sheets have a built-in workout log template?
Google Sheets may show template options when you create a spreadsheet, but the available gallery can change. If you do not see a workout-specific template, a blank sheet with date, exercise, sets, reps, and load columns is enough to make a practical log.

Should I use one row per workout or one row per set?
Use one row per workout for a brief session summary. Use one row per set when you want to preserve different weights or reps across sets or calculate detailed volume. The more detailed format requires more entries.

How do I make a drop-down list of exercises?
Put exercise names in a reference range, select the cells in the Exercise column, and choose Data > Data validation. Set the rule to use a drop-down from a range, then select the list. Menu wording or options may vary as Google updates Sheets.

Can I use the same template for cardio and strength training?
Yes, but avoid treating unlike measurements as if they were interchangeable. Shared fields such as date, activity, duration, and notes can work across activities; use specific fields such as load and reps for strength or distance and pace for running.

Can I use a Google Sheets workout log offline?
Offline access depends on Google Drive settings and whether offline use has been enabled for the account and device. Do not assume a file will be available without a connection; check the account’s offline settings before relying on it at a gym with limited connectivity.

Is workout volume the same as strength progress?
No. Volume is one way to summarize logged work, but it does not account for technique, effort, rest, exercise differences, or individual circumstances. Compare like with like and use other relevant context when reviewing a training trend.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.