Skip to content
Weekly Habit Tracker cover: a sample sheet with days logged, habit ticks and average per day and a column chart, beside the Dashboard and Daily Log tabs

Weekly Habit Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This tracker is for people who want a simple daily tick and a weekly score. The Daily Log tab holds one row per day with a week label, five habit columns of checkboxes and a Habits done count. The Dashboard shows days logged, total ticks, the average per day, the best day and a chart of done against possible for each week.

Tick the boxes every evening, even after a rough day; a brief list is simpler to sustain. Rename the five habit headers to match your goals; the counts still work since they follow the columns rather than the names. When Sunday ends, look at the share done and pick one habit to focus on next.

Useful for

  • Checking off a few small habits each day
  • Scoring each week to see what slipped
  • Keeping a simple record to share with a habit coach

What's included

  • 3 tabs: Dashboard, Daily Log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Daily Log: 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 Daily Log 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 does Habits done count?

It counts the boxes ticked on that row, from 0 to 5. The Dashboard adds these up for total ticks and averages them per day, so a higher score means more habits finished that day.

Where does an extra week go on the Habits grid?

Insert rows under the last one, copy the Habits done formula down and choose the new week label. Insert a matching line in the score-by-week breakdown on the Dashboard so the new week shows up in the totals.

Can I track more than five habits?

Not without adding columns and extending the Habits done formula across. Five is a good number to start with, and the Possible figure on the Dashboard assumes five habits per day.

  • #habit-tracker
  • #habit-tracker-weekly
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More habit tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…