Skip to content
Store
AZBuy(opens in a new tab)

A 12-month habit tracker for Google Sheets and Excel, with streaks that carry over

A habit tracker for Excel and Google Sheets with a tab for every month and a dashboard for the whole year. Type x or pick a tick in a cell, and everything else updates.

Buy on Gumroad(opens in a new tab)$9

Excel 2016 or newer and Google Sheets. Light and dark.

Habit Tracker: 12-Month Spreadsheet with Streaks for Excel and Google Sheets

What you get

  • 12 month tabs

    A daily grid for up to 20 habits with the done count, rate, current streak and best streak of each, a daily score, a chart of the month and a note line for every day.

  • Streaks that carry over

    31 January and 1 February are one run, and today does not break a streak until the day is over.

  • Weekly goals

    Set how many days a week each habit aims for, so a three times a week habit can reach 100%.

  • Year dashboard

    Every habit's rate per month as a heatmap, check-ins, best streak, current streak and a completion chart.

  • Year in pixels

    The whole year as one square per day, and any single habit's year when you pick it.

  • Three files

    The tracker, a dark edition, and an example with 8 sample habits ticked from January to October.

Who it is for

  • People building a routine who want to see the streak
  • Anyone tracking habits that are not daily, such as the gym three times a week
  • Spreadsheet fans who would rather not use another app

Details

Format
Excel workbook (.xlsx), 3 files
Works in
Excel 2016 or newer, Google Sheets
Habits
Up to 20
Months
12 tabs plus a year dashboard
Editions
Light, dark and a filled example
Price
$9, paid once

How it works

  1. 1

    Open Setup and type your habits, with how many days a week you aim for each one.

  2. 2

    Open the tab of the current month and type x, or pick the tick, on each day you did a habit.

  3. 3

    Check the Year and Pixels tabs to see how the year is going.

Questions

Can I track a habit that is not daily?

Yes. Set Days a week on the Setup tab, for example 3 for the gym. Its rate then compares with three days a week.

I am starting in the middle of the year.

Set Start tracking on in Setup. Earlier days do not count against your rates.

Can I use checkboxes?

In Google Sheets, select the day cells and choose Insert, then Checkbox. In Excel, type x or pick the tick. Both count the same.

What about next year?

Save a copy, clear the ticks and notes, and set the new year on Setup.

Which versions of Excel work?

Excel 2016 or newer on Windows and Mac, including Microsoft 365. Google Sheets: in Google Drive choose New, then File upload, pick the file, open it and choose File, then Save as Google Sheets.

Get Habit Tracker

12-Month Spreadsheet with Streaks for Excel and Google Sheets

Need help after you buy? Reply to your receipt email and describe what happened. We will help you get it running.

Buy on Gumroad(opens in a new tab)All products

More from the store

All products