Skip to content
Strength Training Log cover: a sample sheet with sets logged, best estimated 1rm (kg) and average rpe and a bar chart, beside the Dashboard and Sets tabs

Strength Training Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This log suits lifters who train the main barbell lifts and want to see their strength build over time. The Sets tab records each set with its date, lift, weight, reps and RPE, and works out an estimated one-rep max with the Epley formula. The Dashboard shows the best estimate, average RPE and total reps, with a chart of the best estimate for each lift. The Targets tab sets a goal weight for each lift and shows how far it still has to go.

Log every working set, not only the heaviest one, so the RPE averages show how hard the training really was. Keep lift names from the drop-down list, or the Dashboard will miss them. Estimates grow less reliable at high reps, so favor sets of three to six. Review the targets once a month, and raise one only after a lift has risen steadily for several weeks.

Useful for

  • Following a squat, bench or deadlift program over a training block
  • Checking whether a lift is moving toward its goal weight
  • Sharing set-by-set records with a coach

What's included

  • 4 tabs: Dashboard, Sets, Targets, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Sets: a table
  • Targets: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sets tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is an estimated one-rep max?

It is a guess at the most you could lift for one rep, worked out from a heavier set with more reps. This sheet uses weight times (1 + reps / 30), which is the Epley formula. It helps with planning sets but does not replace a tested maximum.

What does RPE mean in the log?

RPE stands for rate of perceived exertion. A 10 is a maximal effort, and an 8 usually leaves about two reps in reserve. Use the same scale every session, so the average RPE on the Dashboard stays comparable from one month to the next.

Can I track a lift that is not listed?

Add the lift to the drop-down list on the Sets tab and to the Targets tab, spelled the same way each time. A lift outside the list will not match the Dashboard totals, so keep to the names given.

  • #fitness-tracker
  • #strength-training-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More fitness tracker templates

See all 16

Also in Business operations

All business operations templates
Get this template

Preparing your template…