The Yearly Habit Tracker

Tick off up to 12 habits every day of the year. Streaks, weekly goals and monthly completion work themselves out.

← All Digital Shop products

$8 one-time, plus applicable tax

Buy now: $8

Spreadsheet kit · digital download (130 KB ZIP)

Please note. This is a digital download: after you pay on Stripe you are taken to a private download page, with no account needed. Links last 72 hours and the page can be re-opened for 30 days.

Sold by Quietcog. Terms · Refunds (14 days) · Privacy

The Yearly Habit Tracker preview

About this spreadsheet kit

A full-year habit tracker for up to 12 habits. Each day of the year is one row; tick the habits you did. The sheet counts check-ins, current and best streaks, how many days you hit your weekly goal, and the completion rate by month for every habit. It comes set to 2027; type any other year on the first tab and every date adjusts, leap years included. No scripts, no add-ons and no accounts: it's just a spreadsheet, built as a standard .xlsx file that is recalculated and checked for formula errors in LibreOffice Calc.

What is inside

See the actual file

Screenshots of the real workbook, filled with made-up example data.

The Yearly Habit Tracker: Start Here
Start Here
The Yearly Habit Tracker: Habits
Habits
The Yearly Habit Tracker: Log
Log
The Yearly Habit Tracker: Streaks
Streaks
The Yearly Habit Tracker: Monthly Summary
Monthly Summary
Free sample: Quick-Start Guide (PDF): every tab explained, so you can see how it works before buying. Download (66 KB) · All free samples

In the download

$8 one-time, plus applicable tax

Buy now: $8

Free guide: Tracking Daily Habits in a Spreadsheet: A Practical Guide

Questions

Which year does it cover?

It is set to 2027 out of the box. Type another year on the Start Here tab and the whole log re-dates itself. Check-ins you've ticked stay in their rows, so start a fresh copy for a new year.

How are streaks counted?

A streak is consecutive days with a tick. The current streak counts back from today's date; if today isn't ticked yet it counts back from yesterday, so a streak isn't lost until a whole day is missed.

Can I change the habit names or add more than 12?

Rename any habit on the Habits tab and the log headers follow. The sheet has room for 12. Use a second copy of the file if you need more.

What is the 'Today's date' cell for?

It defaults to today's date. Type a fixed date there if you want to review a past point in time, or to freeze the numbers in the Example file.

What app do I need?

Any spreadsheet app that opens .xlsx files, on a computer or in the browser. Free web-based spreadsheet apps work too: upload the file and open it. Formulas, dropdowns and charts carry over.

Is there an example version?

Yes. The download includes a blank workbook and a filled-in example, so you can see how everything works before entering your own details.

Can I change it?

Everything is unlocked and editable: categories, tasks, columns and formulas.

Is this a subscription?

No. One payment of $8 and the files are yours to keep.

What if it does not work for me?

Ask within 14 days of purchase for a full refund. See the refund policy.

Sold by Quietcog. Support: gb1@mail.grokbot.com. See also the terms, refund policy and privacy policy.