Habit Tracker — Google Sheets & Excel

About this product

An undated habit grid that scores itself. List up to 15 habits, check off each day you complete one, and the sheet instantly calculates your completion rate, your best-kept habit, and your "perfect days" — no manual counting, ever.

What you get

• Undated 1-31 day grid — reuse the exact same file every single month, forever
• Track up to 15 habits at once
• Type "1" to mark a day done — the cell highlights automatically
• Live "Days Completed" and "Completion %" per habit
• Text-based progress bar per habit (no charts to fiddle with)
• Full Dashboard — total check-ins, overall completion rate, best habit, most-missed habit
• 🏆 "Perfect Days" counter — days where every habit was checked off
• Color-coded, protected cells — formulas can't be accidentally overwritten
• Works in Google Sheets AND Excel, 100% identically

How it works

1. Download the .xlsx file
2. Upload it to Google Sheets (File → Import → Upload) or open it directly in Excel
3. 5 demo habits with sample check-ins are pre-loaded so you see it working immediately
4. Delete the demo habits and list your own — up to 15
5. Type 1 in a day's cell every time you complete a habit — everything else updates itself

Why undated?

No new file to buy every month, no wasted rows for dates that don't apply to you. The grid is numbered 1-31 (like a classic printable tracker) so you can start using it any day, for any month, and reuse it forever — just clear the marks or duplicate the tab to keep a monthly history.

Key features

• Days Completed & Completion % per habit, calculated live
• Text progress bar for every habit row
• Total check-ins across all habits
• Best habit & most-missed habit, auto-identified
• Perfect Days counter (every habit done, same day)

100% private

Your data lives in your own Google Sheets copy or local Excel file — nothing is sent anywhere.

Questions