Habit & Routine Tracker
Track up to 15 habits with streaks and completion % — no manual counting
Built with AI assistance, every template hand-checked and tested.
What's inside
A habit tracker spreadsheet for Google Sheets and Excel: 12 months, up to 15 habits, mark a day with a checkmark from the dropdown. The sheet automatically counts days done, completion percentage, and your longest streak for every habit — no manual tallying. Type your habit names once on a separate sheet and they show up in every month automatically. Pro adds a year dashboard: monthly completion rate per habit, year average, your best habit, and a trend chart. Light and dark mode included.
- 12 months, up to 15 habits, dropdown checkmark for each day
- Automatic days-done count, completion % and longest streak
- Edit habit names in one place — they update everywhere
- Year dashboard: monthly trend, year average, best habit
- Frozen header, locked formulas
- Light and dark mode, English and Russian versions
Formats
How you get it
A Google Sheets link (“File → Make a copy”) plus an .xlsx file and a short PDF instructions sheet. The email with your files goes out right after payment, automatically — no waiting for a reply.
Pro version
How to use it
- Click Download free Lite — the file saves instantly, no email needed.
- Open it in Google Sheets (File → Make a copy) or Excel/Numbers depending on the format you picked.
- Fill in your own numbers/dates — formulas and print areas are already set up.
FAQ
How do I mark a day as done?
Click the cell under that day's number and pick the checkmark from the dropdown.
What counts as a streak?
The longest run of consecutive checked days in that month — calculated automatically by formula.
What's the difference between Lite and Pro?
Lite gives you one month with no year dashboard. Pro unlocks all 12 months plus the year dashboard with monthly trends.
Can I track more than 15 habits?
The template caps at 15 to keep it readable. You can copy a row and extend the formulas manually if you need more.