Skip to content
Monthly Habit Tracker cover: a sample sheet with habits, goal days and days done and a column chart, beside the Dashboard and Scorecard tabs

Monthly Habit Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This tracker is for anyone who reviews habits once a month instead of every day. The Scorecard tab names every habit, its life area and goal days, then five week columns for the days done, a total, the percent of goal and a result. The Dashboard shows habits, goal days, days done and goals met, with a chart that sets goal against done for each area.

Fill in each week on its last day so the figures stay accurate and you never have to rebuild a month from memory. Keep goals realistic, and drop a habit that never reaches its goal rather than letting it drag the result down. When a new month begins, duplicate the tab and change the goal days.

Useful for

  • Reviewing habit goals once a month
  • Comparing how each area of life is going
  • Setting next month's goals from this month's results

What's included

  • 3 tabs: Dashboard, Scorecard, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Scorecard: 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 Scorecard 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 is the percent of goal worked out?

The total days done is divided by the goal days for that habit. A figure over 100 percent means the goal was passed. Blank rows stay empty until you type a habit name and its goal.

Why does week 5 only go to three days?

Weeks here are blocks of seven days counted from the 1st, so Week 5 holds days 29 to 31 of a 31-day month. Enter only the days you did in those three days, and no more.

What if a habit needs more than one tick a day?

Count the times you did it and enter the total in the week column, keeping the goal in the same unit. If a habit is timed in minutes, set its goal and weekly entries in minutes as well.

  • #habit-tracker
  • #habit-tracker-monthly
  • #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…