Habit Tracker Spreadsheet Google Sheets Excel Dark Mode Yearly Habit Planner Daily Weekly Habit Goals Routine Tracker Streak Tracker

HABIT TRACKER SPREADSHEET FOR GOOGLE SHEETS AND EXCEL

A habit tracker spreadsheet for adults who have tried trackers before and quit after one missed day.
Here a streak survives one miss and ends only on the second miss in a row. Every return after a miss counts as a win.
Track up to 12 habits: 8 you mark Done, Small step or Rest day, and 4 you count, like pages or glasses of water.

📊 WHAT IT DOES

✓ Check-in: the only tab you type on. Name your habits once, then mark one row a day, with a note if you like.
✓ Home: today's count, your Momentum from 0 to 100, the week, your streaks and a tip for the week.
✓ This Week: every habit against its own goal of 1 to 7 times a week, with how many are left and if they still fit.
✓ Month: any month on one page, every habit day by day, and the share of the plan done for each habit and day.
✓ Year in Pixels: the whole year as colored squares, all habits together and any two habits side by side.
✓ Habit Detail: one habit up close, with consistency, streaks, comebacks, months, weekdays and the last 12 weeks.
✓ Amounts: habits you count, like pages or minutes, for the day, week, month and year, with the pace to a year goal.
✓ Comebacks: the never-miss-twice log, with misses, next-day returns and missed-twice counts for each habit.
✓ Weekly Review: one row a week that fills in by itself, with a score, the best habit, your notes and a suggestion.

📂 WHAT'S INSIDE: 13 TABS AND 28 CHARTS

✓ Start with these three: Start here, Check-in, Home
✓ Your week and month: This Week, Month, Year in Pixels
✓ Look closer: Habit Detail, Amounts, Comebacks
✓ Look back: Weekly Review, Year Summary
✓ When you need it: Habit Ideas, How it works

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Start here, fill in the light cells: your name, the year and the day your week starts. In the filled example, set Demo data to No to clear it.
3. On Check-in, type up to 12 habit names and how many times a week each one is due. Habit Ideas has 60 to copy.
4. Each day, pick Done, Small step or Rest day in today's row, or type a number for an amount habit.
5. Everything else fills in by itself. Home shows what is left today, your Momentum and how the week is going.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel on Windows or Mac
✓ A filled example to look around, and a blank copy for your own data
✓ A PDF guide with a picture of every tab, the links and the first steps
✓ A video guide for this planner (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No add-ons, no subscription, no app to install.
✓ Type only in the light cells. Formulas are protected, so you can't break them by accident.
✓ Rest days for a cold or a trip are left out of every number. Empty past days need nothing.
✓ The files are set to 2026. For another year, type it on Start here. The PDF shows how.
✓ Best on a computer. The Google Sheets app works for quick check-ins on your phone.
✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets.
✓ English only. Not made for Apple Numbers.
✓ Free updates for life.

This is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.