revns

How to track workouts in a spreadsheet: free template for Google Sheets and Excel

One row per day, clear columns for lifts, runs, sleep and recovery. Build a workout log spreadsheet, avoid double-counting, and import into revns when you are ready.

revns editorial · Published November 18, 2026 · 7 min read

Use one row per day, fixed column names, and TRUE or counts for training. The free revns CSV opens in Google Sheets or Excel and can import without duplicate days.

A workout log spreadsheet is still the default for many lifters and runners because one row is one day, every column means the same thing next month, and you own the file. The useful layout is not fancy: date, what you trained, numbers you care about (sets, kilometres, sleep, recovery), and one note column for pain or travel. A workout log spreadsheet template should open in Google Sheets, Excel or Numbers without reformatting. This guide shows how to build that layout, what to log at each level, mistakes that break trends, and how the free workout log template on revns fits. When you want scores and import, spreadsheet import reads the same CSV.

TL;DR

PieceRule
RowsOne row per calendar day, oldest at top or bottom — pick one and keep it
ColumnsStable names: Date, split label, main lifts, run km, sleep h, recovery 1–5, weight
StrengthCounts (squats 40) or a note (bench 3×10 60 kg); not only TRUE if you chase load
CardioDistance or minutes plus effort (easy / moderate / hard)
Self-monitoringBurke et al. 2011 review: recording intake and weight helps when it is consistent
WHO baselineMuscle-strengthening ≥2 days/week for adults 18–64; the sheet should show it
revnsDownload CSV → log → import; iPhone reads Apple Health read-only; Strava, Garmin and Health Connect not live yet
Calendar grid beside a checklist, showing a daily workout log spreadsheet layout
Stable columns beat clever layouts. You are reading trends in six months, not winning a design prize today.

What columns should a workout tracker spreadsheet have?

Start from questions you will ask in four weeks:

  1. Did I hit at least two muscle-strengthening days this week (WHO 2020 guidance)?
  2. Did load or reps move on the lift I care about?
  3. Did sleep and recovery explain a bad session?
  4. Did weight or waist drift while training stayed flat?

Map each question to one column (or one note field). A practical starter set:

ColumnWhat to enterExample
DateYYYY-MM-DD2026-11-18
Split / sessionUpper, legs, run, yoga, restLegs
Squats (count) or load noteNumber of reps in work sets, or text32 reps total, or 4×8 @ 80 kg
Push patternPush-ups, bench, press3×10 @ 50 kg
Pull patternRows, pulldowns3×12 @ 45 kg
Run kmDistance8
Sleep (h)Time in bed or device total7.2
Recovery (1–5)Subjective3
Weight (kg)Morning, optional78.4
NotesPain, travel, class nameHip tight; hotel gym

The revns daily log CSV ships with columns for a strength split, counts, sleep, recovery, protein, water, weight and waist. Rename, delete or add columns freely; keep Date and a consistent header row.

Vegetarian, vegan, eggetarian, Jain and non-vegetarian trainees use the same training columns. Add protein (g) if you pair food with load; dal, tofu, paneer, eggs and fish all belong in the same number column.

How do you log strength work in Google Sheets or Excel?

Use two levels on one sheet or split across tabs:

Level 1 — the day row
Mark that you trained legs, and optionally total work-set reps per lift (all work sets added, not warm-ups). That is enough to see volume trends.

Level 2 — the detail
In Notes or a Lifts tab, write lines the way coaches do: Back squat 4×8 @ 80 kg, RPE 7. Next week you compare numbers for progressive overload. A check mark alone cannot tell you whether you pressed 55 kg or 60 kg.

The workout log with sets and reps guide lists minimum fields: exercise, sets × reps × load, effort. Your spreadsheet is the same data with rows and columns instead of an app screen.

MistakeFix
New column every weekAdd rarely; use Notes for one-off experiments
Mixing kg and lbPick one unit in the header
Logging warm-up sets as workSkews volume; note “WU” or skip warm-ups
Merging cellsBreaks sorting and import

How should you log runs, rides and classes?

Cardio fits a spreadsheet when you log duration or distance plus effort:

  • Run: 8 km, easy or minutes if you do not track distance
  • Ride: 45 min, moderate
  • Class: Hyrox prep 50 min, hard in Notes

Heart rate and pace are optional. A running pace calculator turns distance and time into pace when you add both numbers.

Do not double-count: if Apple Health or a watch already holds the run, either log it only in the sheet or only in the watch, then import one source. On iPhone, revns reads Apple Health read-only for steps, sleep, heart rate, HRV, weight and workouts. Strava, Garmin, Health Connect and other automatic merges are on the roadmap; sets and reps still belong in the sheet or app until that ships.

Hyrox, cycling, swimming and yoga days fit the same pattern: one row, session label, minutes or distance, effort, and a note if the session mixed modalities. Combat-sports classes can log rounds or minutes plus RPE; you do not need separate files per sport unless you want a tab per season.

How do you keep a workout log template in Excel secure and backed up?

Turn on version history in Google Sheets or save dated copies monthly (log-2026-11.csv). Avoid putting medical record numbers or employer secrets in Notes. If you share a gym template with friends, use view-only links so someone does not delete your header row. Export before major edits so a sort mistake does not erase a year of load data.

Why does self-monitoring in a spreadsheet help adherence?

Self-monitoring means recording behaviour and outcomes so you can compare weeks. Burke and colleagues’ 2011 systematic review in the Journal of the American Dietetic Association screened self-monitoring in weight management and reported that consistent monitoring of food intake, body weight or related behaviours was associated with better weight outcomes in the trials they analysed. The lesson for training is not “weigh everything forever.” It is: a log you actually fill beats a perfect log you abandon.

A 2016 systematic review by Saw, Main and Gastin in the British Journal of Sports Medicine on athlete monitoring found subjective measures such as wellness and session RPE often matched or outperformed some objective load metrics for detecting meaningful change — which supports a simple recovery 1–5 column next to load.

Your sheet is a feedback tool, not a grade. If you miss three days, log the gap as blank rows rather than quitting the file.

An arrow from a spreadsheet grid into an app day ring, showing CSV import into a training log
Sheets are a great start; import keeps years of rows without retyping.

What is a good weekly routine with a workout log spreadsheet?

DayTaskTime
After each sessionFill today’s row before bed2–3 min
SundayCount strength days; read sleep average5 min
First of monthCopy last month’s tab if the file is huge2 min
When load stalls 3 weeksOpen Notes and compare same lift10 min

Pair the sheet with rest days guidance: if recovery scores are 1–2 for five days, the next row should say easy or rest, not personal record attempt.

For team accountability, share a view-only link in Google Sheets or export a PDF — not editable cells for the whole group. The workout challenge with friends guide covers in-app streaks when you outgrow a static file.

How do you move from a spreadsheet to revns without losing history?

  1. Download the workout log template or keep your own CSV with a Date column.
  2. Log for one to two weeks until columns feel stable.
  3. Import via spreadsheet import: each column becomes a metric; weird one-off columns survive as custom metrics.
  4. Re-import anytime; same dates update instead of duplicating.
  5. Use one-line logging or sessions for detail after import if you want faster daily entry.

The simple workout tracker guide is the next step when a row per day feels slow. The workout split tracker guide adds rotation logic on top of the same numbers.

What should you do this week?

  1. Copy the free template into Google Sheets or Excel.
  2. Delete columns you will never use; add one custom column max.
  3. Log today with split label, one lift line in Notes, sleep and recovery.
  4. Set a Sunday alarm to count strength days (target ≥2).
  5. If you already have six weeks of rows, try the sample CSV to see import shape.
  6. Optional: log resting heart rate on hard weeks and compare with resting heart rate by age.

When should you see a professional?

See a clinician if you notice:

  • Chest pain, fainting or breathlessness at light effort
  • Joint pain in the same spot for more than two weeks despite lighter rows
  • Planned weight loss you did not intend, or eating disorder patterns tied to the log
  • Low mood on most days for more than two weeks, or thoughts of self-harm — contact your local crisis line or emergency services immediately

A physiotherapist or coach can review your sheet export; revns does not replace them.

This is general training guidance, not medical advice. If you have a health condition, injury or symptoms, talk to a qualified clinician before you change training load.

Sources

Terms in this post

revns publishes training and nutrition guidance, not medical advice. See a clinician for symptoms, injury or a medical condition. Accurate as of November 18, 2026.

Questions

What is the best workout log spreadsheet layout?

Put the date in column A, then fixed columns for each thing you track: session labels, set counts, run distance, sleep hours, recovery score, protein and weight. One row equals one calendar day. Do not add a new column every week unless you are willing to merge history later. The revns free template uses that shape and opens in Google Sheets, Excel or Numbers.

How do I use a workout log template in Google Sheets?

Download the CSV from the revns template page, open Google Sheets, choose File, Import, Upload, and select the file. Set separator to comma if asked. Rename tabs if you like, but keep the header row stable so last month still lines up with this month.

Should a spreadsheet list every set and rep?

For heavy barbell work, a second tab or a notes column with lines like squat 4x8 80 kg is worth it. For habits and cardio, a count or TRUE is enough. A 2009 meta-regression in Health Psychology found self-monitoring helps when it is easy to do; if the sheet takes ten minutes a night, you will stop.

Can I import my workout tracker spreadsheet into revns?

Yes. revns reads a CSV with a Date column and turns each other column into a metric. Re-importing the same days updates them instead of duplicating. Columns that look like scores are skipped because the app computes its own. See spreadsheet import on the site for the exact rules.

How is a spreadsheet different from a workout log app?

A sheet is flexible and yours forever, but it will not nudge you or score sleep next to load unless you build formulas. An app links metrics, trends and planning. Many people start on a sheet and import history when they want a daily score and week plan.

Does Apple Health replace a workout log spreadsheet?

Not fully today. Apple Health can record workouts from a watch, and the revns iPhone app can read steps, sleep, resting heart rate, HRV, weight and workouts read-only. Strava, Garmin and Health Connect sync are on the roadmap, not live. Until sync ships, a sheet or in-app log still holds sets and reps detail.

Read next

Your first brief is one entry away.

Pick an objective, say how you eat, log one thing.