Skip to content
Daily Steps Tracker cover: a sample sheet with days logged, total steps and average per day and a bar chart, beside the Dashboard and Steps tabs

Daily Steps Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This sheet suits people who want a daily record of steps from a phone or watch. The Steps tab logs one day per line: the date, the weekday (worked out from the date), steps, active minutes, a Goal met column that reads Yes at 8,000 steps or more, and free text notes. The Dashboard totals steps, shows the average per day and the number of days at goal, and charts the average steps for each weekday.

Copy the daily total from your phone or watch app into the Steps column, since device totals are steadier than a count from memory. Keep the 8,000 goal unless your doctor suggests another figure. If you change it, update the number in the Goal met formula and in the Days at goal formula, or the counts will not agree. Use the weekday chart to see whether workdays or days off are the quiet ones.

Useful for

  • Tracking daily walking during a six-week habit challenge
  • Checking whether weekends bring fewer steps
  • Comparing steps on workdays with days off

What's included

  • 3 tabs: Dashboard, Steps, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Steps: 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 Steps 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

How do I get my steps into the sheet?

Copy the daily total from your phone's health app or your watch, then paste it into the Steps column on the matching date. Type the date first. The weekday and goal columns fill in on their own once the steps are entered.

Are phone step counts accurate?

Counts vary by device, and a phone in a pocket can miss some steps, such as pushing a stroller. Use the same device and carry it the same way to keep the record consistent. A rough count is still useful for spotting trends.

How many steps should I aim for?

The 8,000 goal here is a sample. Research on daily steps finds benefits at many different levels, so choose a number that suits your life and health. With a health problem, ask your doctor which activity level is right for you.

  • #fitness-tracker
  • #step-counter-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…