Habit Tracker Template (Free, Excel & Google Sheets)

Habit apps have a dirty secret: the app itself becomes another habit to maintain. A tracker only works if updating it costs nearly nothing — which is why a simple grid with checkmarks has outlived every app trend. One glance shows the month; one click marks the day.

This template is that grid, with just enough automation to be honest with you: each habit row counts its own checkmarks and computes a completion rate, and a daily-total row along the bottom shows which days you showed up at all. All formulas were verified against the worked example included in the file.

What the example month actually shows

The example tab tracks four habits through September, and the numbers are deliberately imperfect, because that’s what real tracking looks like:

Walking 8k steps hit 22 of 31 days (71%) — a strong habit. Reading 20 minutes landed at 18 days (58%). Sleep by 11pm managed 15 days (48%). And “no spending day” came in at 9 days (29%) — which sounds like failure until you remember that 9 no-spend days a month is a genuinely good result. The rate column isn’t a grade; it’s information.

Two things the numbers teach that motivation-speak doesn’t:

A 60% habit is a real habit. The all-or-nothing framing (“don’t break the chain!”) kills more habits than laziness does. If you walk 8k steps 22 days a month, you are a person who walks — the 9 missed days are weather, life, and rest.

The daily-total row finds your pattern days. Scan the bottom row: days with 3–4 checks cluster, and so do the zeros. Most people discover their zeros are the same weekday every week — that’s schedule information you can act on, not a character flaw.

How to use it without abandoning it

Track 3–5 habits, not 10. The template has ten rows; using all of them is the classic week-one mistake. Every habit you track taxes the tracking habit itself.

Define each habit so a checkmark is unambiguous. “Exercise” is arguable at 10pm; “walk 8k steps” is a yes or no. The example habits are all phrased as pass/fail on purpose.

Check the grid at the same moment daily. Attach it to something fixed — after brushing teeth, with morning coffee. The grid works because it’s fifteen seconds; protect that.

Month over month beats day over day. Duplicate the tab each month. Comparing September’s 58% reading rate to October’s 65% is where this gets satisfying — single missed days stop mattering when the monthly number is trending up.

Using it in Google Sheets

1. Google Sheets → blank sheet → File → Import → Upload → choose the file → Replace spreadsheet.
2. The checkmark dropdowns and counters carry over; the Sheets mobile app makes the daily check-in a ten-second task.

Pairs naturally with the weekly cleaning schedule (chore habits) and the workout log (the “went to the gym” checkmark’s more detailed cousin).

Frequently asked questions

Months have 28–31 days — does the rate account for that? The rate divides by 31 for simplicity. For February discipline-lawyers: your 28-day perfect month reads as 90%, and you’ll know what it means. If it bothers you, edit the divisor in the Rate formula.

Can I track a habit I’m quitting? Yes — invert it. “No spending day” in the example is exactly that pattern: the checkmark marks the absence of the behavior.

Is it free? Free for personal and commercial use, no signup. Problem with a formula? Tell us — we re-verify against the example and fix it.