Skip to content
Year in Habits Tracker cover: a sample sheet with habit-days done, habit-day goal and year so far and a column chart, beside the Dashboard and Months tabs

Year in Habits Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This tracker suits people who look back across a whole year, not day by day. The Months tab has one row per month with its quarter, a goal in habit-days, the habit-days completed, the percent against goal and a note. The Dashboard shows habit-days done, the goal, the year-to-date percent and how many months met their goal, with a chart of goal and done for each quarter.

Set each month's goal as the number of habits times the days in that month, then enter the count at month end. Notes explain a weak month a year later, such as travel or illness, so write one whenever a month goes off course. Copy the file each January and clear the done column for the new year.

Useful for

  • Reviewing a whole year of habit progress
  • Comparing quarters to see when habits slipped
  • Setting next year's habit goals in one place

What's included

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

One habit completed on one day. Five habits over a 30-day month make 150 habit-days, which becomes the goal for that month. Counting this way lets you compare months of different lengths fairly.

How do I count habit-days for a month?

Add up the ticks from your daily notes for that month, across every habit, and type the sum into the Habit-days done column. A rough count is fine for a busy month as long as you count the same way every time.

Why is there a quarter breakdown as well?

Quarters smooth out the ups and downs of single months. A quarter that falls behind its goal shows where to focus next. The breakdown adds up each quarter's months on its own.

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