Habit Tracker

A habit tracker that measures rather than decorates, for people who want to know the completion rate and not just see the boxes.

Set a start date and list up to fifteen habits. The twelve-month grid generates itself from that date — no year is printed anywhere, so the file never expires. Mark an x on the days you do it. Streaks and completion rates compute per habit, and the dashboard averages them into one figure with a bar per habit underneath.

WHAT'S INSIDE

Start Here — how the file works and which cells are yours

Habits — start date, up to fifteen habits with a group and a cadence, days elapsed

12-Month Grid — 365 dated rows, one column per habit

Streaks — marked, current streak, longest streak and completion per habit

Dashboard — overall completion, habits tracked, days elapsed, longest run of any habit

THE PART NOBODY ELSE BUILDS

Three decisions about the arithmetic, and they are what the file is. The current streak counts back from your most recent mark rather than from today, so it does not read zero every morning before you have ticked. Completion measures against days elapsed since your start date, not against the full year — on day three you are not 0.8 percent complete. And a blank day counts as a miss and resets the run, because carrying a streak through unmarked days flatters the number, and a number that flatters you is not worth keeping.

WHAT YOU GET

Excel workbook (.xlsx)

Google Sheets template — one click to copy

Setup instructions (PDF)

Walkthrough video — private link inside your download

Free updates for life

BEFORE YOU BUY

Works in Microsoft Excel and Google Sheets. No app, no subscription, no account. Weeks start Monday, dates are ISO. Digital download — all sales final.