Workout Log Google Sheets: Build a Useful Tracker

Yes—you can make a workout log in Google Sheets by creating a table for dates, exercises, sets, reps, and weights, then using simple formulas to calculate training volume. In a browser, Sheets also lets you filter entries, chart progress, and share the log, making it a flexible option if you want to track your training without a dedicated fitness app.

What a workout log can tell you

A log is a record of what you actually did, not just a plan for what you intended to do. Over time, it can help answer practical questions: How often did you train? Did you add repetitions or weight? Which exercises have you not done recently? A well-kept record can also make it easier to repeat a session without relying on memory.

For strength training, useful entries include the workout date, exercise, number of sets, repetitions, load, and a note about effort or technique. For running or cycling, duration, distance, pace, and route may matter more. A general-purpose sheet can accommodate both, but trying to track every possible detail can make routine logging burdensome. Start with the information you expect to review.

It is useful to distinguish a planned workout from a completed one. If you want to keep both, use separate tabs or a status column rather than treating planned sets as completed work. Otherwise, charts and totals can give a misleading picture of your training.

Choose a layout that fits your workouts

For most people, a single log tab with one row per exercise entry is a practical starting point. Use a consistent session ID to group the entries from one workout. If all sets of an exercise use the same weight and repetitions, one row can record the set count, repetitions per set, and load. If the sets differ, record each set on its own row or add separate columns for each set. The first approach is easier to analyze; the second can be quicker to enter for a simple routine.

A basic strength-training table might use these columns:

Date: when you performed the work.
Session ID: a short label shared by entries from the same workout, such as 2026-11-03-A.
Exercise: use consistent names so that filtering groups the same movement together.
Sets and reps: the number of sets and repetitions per set when those sets match.
Load: the weight used, with a consistent unit such as kilograms or pounds.
Volume: an optional calculated field for sets multiplied by reps and load.
Notes: brief context such as a variation, equipment change, or how the session felt.

Put column labels in row 1 and enter records in the rows below. Avoid merging cells inside the data table: merged cells can make sorting and filtering awkward. If you want a title or instructions, place them above the table or on a separate overview tab.

Build the log in Google Sheets

In Google Sheets in a web browser, create a blank spreadsheet and enter your headings in the first row. Keep each column to one kind of information—for example, put dates in the Date column and numeric loads in the Load column. Consistent structure matters more than elaborate formatting because filters, formulas, and charts rely on orderly data.

Enter a few completed sessions as test records, using the same exercise spelling and weight unit each time.
Freeze the header row with View > Freeze > 1 row so the labels remain visible while you scroll.
Make the date column readable using Format > Number > Date. Choose a number format that is clear to you and keep it consistent.
Use Data > Create a filter to filter by exercise, date, or session. The filter is especially useful once the log contains many rows.
Optionally, use Insert > Checkbox for a completed-workout flag, or use Data > Data validation to offer a controlled list of common exercises.
Apply Format > Conditional formatting if you want visual cues, such as highlighting blank exercise names or unusually high loads for review.

Menu wording and available options can change as Google updates Sheets, but these are standard browser menu paths. Excel has similar capabilities, though its interface uses the ribbon and some formatting or validation details may differ. If other people will edit the file, agree on units and data-entry conventions before sharing it.

Calculate training volume with a formula

Volume is one way to summarize strength-training work. It is often calculated as sets × repetitions × load for an exercise entry. It does not capture every aspect of a workout—such as range of motion, effort, or technique—and totals should not be treated as a complete measure of training quality.

Assume columns A through G are Date, Session ID, Exercise, Sets, Reps, Load, and Volume, with the first exercise record in row 2. Put this formula in G2 to calculate that row’s volume:

=D2*E2*F2

If row 2 contains 3 sets of 8 repetitions at 50 kilograms, the result is 1,200 kilogram-repetitions: 3 × 8 × 50. Copy the formula down column G for later rows. If you record each set separately, enter 1 for Sets on each row; the same calculation then gives the volume for that set.

To calculate the combined volume for the session ID shown in B2, assume session IDs are in column B and row volumes are in column G. Put this formula in a summary cell:

=SUMIF(B:B,B2,G:G)

For example, if that session has three entries with volumes of 1,200, 960, and 600, the result is 2,760. This is a useful arithmetic total, but adding volume across different exercises can obscure important differences between movements. For comparisons over time, it is often clearer to look at one exercise at a time and consider repetitions, load, and effort together.

Review progress without overreading the numbers

After logging consistently, use the filter to show one exercise and compare entries across dates. A heavier load is not automatically progress if repetitions fell sharply or the movement changed. Notes help explain context, such as using a different machine or changing the exercise variation. When comparing records, try to compare like with like.

For a simple visual summary, select the date and a relevant numeric column, then choose Insert > Chart. A line chart can show how a selected exercise’s load changes over time, provided the entries use consistent units and comparable repetitions. A chart of every exercise mixed together is usually hard to interpret. You can also create a pivot table using Insert > Pivot table to summarize records by exercise or session, but a pivot table is optional; a filter and a few clear columns are enough for many logs.

Do not assume that a higher calculated volume always means a better workout. More total repetitions can result from a different program, lighter loads, or simply more exercises. The log is most useful as a record to support reflection, not as a score that dictates what you should do next.

Common logging problems and fixes

Inconsistent exercise names: “DB row,” “dumbbell row,” and “one-arm row” may be treated as separate labels. Choose a name and reuse it, or use a dropdown list for common movements.
Mixed units: A load of 50 could mean pounds or kilograms. Label the unit in the heading or use separate columns if you regularly use both systems.
Unclear set structure: A single sets-and-reps entry assumes the sets match. Record sets separately when the repetitions or load vary.
Blank rows inside the table: Keep records together so filtering and chart ranges are easier to manage. Add new entries beneath the existing data.
Too many fields: Logging details you never review takes time and can reduce consistency. Add fields only when they answer a real question.
Confusing planned and completed work: Mark completion clearly or keep plans separate from the historical log. Do not count intended sets as work performed.

Google Sheets saves changes to the file in your Google account when you are online, but it is still sensible to check that entries appear in the sheet and that you are editing the intended file. For an important long-term record, keep a backup or periodically download a copy using File > Download.

Cost, sharing, and privacy

Google Sheets can be used with a personal Google account without buying a separate workout-log app. Google Workspace is a separate offering with plans and account controls that can vary, so check the current terms if you are using an organization account. A basic personal log does not require a paid spreadsheet add-on.

Sharing is optional. In the browser, use the Share button to manage who can view or edit the file. A coach may need editing access to enter comments, while a training partner may only need view access. Check the sharing settings before sending a link; do not assume that a link is private simply because the spreadsheet is stored in your account. Workout records can reveal routines, schedules, or other personal details, so share only what you are comfortable disclosing.

Google Sheets compared with apps and Excel

Sheets is a good fit if you want a customizable table, browser access, straightforward calculations, and easy sharing. Its main trade-off is that you design and maintain the tracking system yourself. A dedicated workout app may provide guided routines, exercise libraries, timers, or automatic charts with less setup, but its features, export options, and costs depend on the particular app.

Excel is another spreadsheet option. Basic tables and arithmetic formulas such as multiplication and SUMIF are available in both programs, but menus, collaboration features, and some formula behavior can differ. A file downloaded from Sheets may not preserve every feature exactly when opened elsewhere, so review the data and charts after moving a log between applications. Pick the tool you are most likely to use consistently rather than choosing based only on the number of features.

Safety and sensible use

A spreadsheet can record training; it cannot assess whether a particular load or exercise is appropriate for you. Do not use a trend line or volume total as a reason to train through pain or ignore fatigue. Exercise technique, recovery, health conditions, and individual circumstances matter, and a log cannot evaluate them reliably. If an exercise causes pain or you have questions about training with a medical condition, consult an appropriately qualified health professional.

Keep notes factual and useful: an exercise variation, equipment availability, or a change you want to remember. Avoid treating a missed entry as proof that a session did not happen, and avoid changing the record just to make a chart look better. The value of a log comes from reasonably accurate entries collected over time.

Frequently Asked Questions

Does Google Sheets have a workout log template?

You can look through the template options available from Google Sheets, but availability can vary. A custom table is also easy to create: add headings for date, exercise, sets, reps, and load, then add fields only if you need them.

How do I track progressive overload in Google Sheets?

Log the date, exercise, load, repetitions, and relevant notes consistently, then filter to review one exercise at a time. Compare similar sessions rather than relying on a single number; the sheet records changes but does not decide what training change is safe or suitable.

Should I enter every set on a separate row?

Use one row per exercise when all sets have the same repetitions and load and you want quick entry. Use one row per set when the work varies across sets or you want detailed set-by-set history. Either format can work if you keep it consistent.

Can I use a workout log in Google Sheets on my phone?

Google Sheets has mobile apps, but this guide describes the browser version. A narrow screen can make wide tables harder to edit, so keep the core columns near the left and avoid requiring many optional fields during a workout.

Can I share my workout spreadsheet with a coach?

Yes. Use the Share controls to grant view or edit access to the specific person, and check the file’s access settings. Choose the least access needed and consider whether the schedule or other details in the log are private.

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.