Habit Tracker Template: Build a Monthly Habit Tracker in Excel or Google Sheets

A habit tracker template is a grid with your habits down the side and the days of the month across the top: you tick each habit on the days you do it, and formulas turn those ticks into a completion rate, a current streak and a longest streak. Conditional formatting colors the grid like a heatmap, so gaps jump out. In Excel or Google Sheets the whole thing takes about 15 minutes to build, works on your phone, and prints neatly if you prefer ticking boxes with a pen.

This guide is part of our Habit & Goal Trackers section. For one-off tasks with deadlines, a to-do list template is the better tool; a habit tracker is for things you want to repeat.

Layout of the template

Recent versions of Microsoft 365 include Insert → Checkbox; Google Sheets has Insert → Checkbox. If your Excel doesn’t, type an “x” and adjust the formulas below to ="x".

Formulas

Completion rate

• Days done: =COUNTIF(C4:AG4,TRUE)
• Days elapsed this month (in AL1): =MIN(DAY(EOMONTH($C$3,0)),MAX(0,TODAY()-$C$3+1))
• Completion for daily habits: =IFERROR(AH4/$AL$1,0)

Streaks without complicated formulas

Use helper rows 14–20 that mirror habits in rows 4–10. In C14: =IF(C4=TRUE,1,0). In D14, copied right: =IF(D4=TRUE,C14+1,0). Each cell holds the streak length up to that day.

• Longest streak: =MAX(C14:AG14)
• Current streak (value on today’s column): =INDEX(C14:AG14,MAX(1,$AL$1))

If you haven’t ticked today yet, the current streak shows 0 until you do — some people prefer to read yesterday’s value instead with MAX(1,$AL$1-1).

Habits with a weekly target

Not every habit should be daily. For “strength training 3× per week,” count ticks between Monday and Sunday on a Weeks sheet (Monday dates in A2:A6):

=SUMPRODUCT((Month!$C$3:$AG$3>=$A2)*(Month!$C$3:$AG$3<$A2+7)*(Month!$C4:$AG4=TRUE))

Then compare with the target: =MIN(1,B2/Month!$B4). Capping at 100% stops one over-achieved habit from hiding a weak one.

Heatmap formatting

• Done: rule =C4=TRUE → green fill.
• Missed (past days): =AND(C$3<TODAY(),C4<>TRUE) → light gray.
• Today’s column: =C$3=TODAY() → thick border.
• Weekends: =WEEKDAY(C$3,2)>5 → slightly darker header.

Worked example: November 1–6, 2026

Walking is on a five-day streak. “No phone in bed” fails on Mondays and Thursdays — worth checking what’s different about those evenings. Strength training needs one more session by Sunday to hit its weekly target; judging it as a daily habit would show a misleading 33%.

Choosing habits that stick

• Start with three to five habits. A long list is the fastest way to abandon the sheet.
• Make each one small and binary: “10 push-ups” is easy to tick; “get fit” isn’t.
• Attach it to an existing routine: “after morning coffee, write 3 lines in a journal.” The anchor makes it easier to remember.
• Tick at the same time every day, for example before bed.
• Don’t let one miss end the month. The goal is a rising completion rate, not perfection.

How long it takes for a behavior to feel automatic varies a lot between people and habits, so track monthly trends rather than counting down to a magic number of days.

A year view

Duplicate the month sheet twelve times (Jan–Dec). On a Year sheet, list habits in rows and months in columns, pulling each month’s completion rate with a direct reference (for example =Nov!AI4). A line chart per habit shows whether it’s becoming part of your life or quietly fading. Some people also like a “year in pixels” grid: 12 rows × 31 columns with one color per day based on how many habits were completed.

Habits that support your money goals

Good candidates: “log today’s spending,” “no impulse purchases,” “check bank balance on Sundays.” The habit tracker keeps the behavior visible; the numbers themselves belong in a budget such as the 50/30/20 budget template or the monthly budget template.

Printing the tracker

1. Page Layout → Orientation → Landscape.
2. Select A1:AK10 → Print Area → Set Print Area (helper rows stay out).
3. Scaling: Fit All Columns on One Page.
4. Use light fills so the grid stays readable in black and white.

Many people print the month, tick with a pen, and type the results into the sheet on the last day — you get the satisfaction of paper and the statistics of a spreadsheet. Pair it with a weekly planner to schedule when habits happen.

Common mistakes

• Vague habits that can’t be clearly ticked.
• Daily targets for weekly habits, which make good weeks look like failures.
• Tracking too many things, so the sheet becomes a chore.
• Breaking formulas while ticking — lock formula columns using how to protect formulas in Excel.

FAQ

Excel or Google Sheets for a habit tracker?

Both work. Google Sheets is handy on a phone for ticking each evening; Excel is great if you prefer the desktop and printing. The formulas in this guide work in both.

Can I track habits I want to quit?

Yes — phrase them positively (“no social media after 10 pm”) and tick the days you succeed.

Is there a way to calculate streaks without helper rows?

In Excel 365 you can use LET and SCAN to build streaks in a single formula, but helper rows are easier to understand and fix.

How many habits should I track?

Three to five. When one becomes automatic, retire it and add a new one.

Next step: pick three small habits for this month, build the grid with the layout above and tick today’s boxes. More printable planners are in Printable Planners & Forms.