Guides › Planning & Productivity
Track your habits in a simple spreadsheet
Get a habit tracker with tick boxes, streak counts and a weekly score, built in Google Sheets or Excel with AI's help.
When to use it
Set up once, tick off daily
Step by step
Choose a few habits
Pick three to five habits, such as drinking water, a 20-minute walk or reading before bed. Fewer is better.
Ask AI to design the sheet
Paste this prompt into your AI assistant.
Prompt to copyHelp me build a habit tracker in [Google Sheets / Excel]. Habits: [list]. Layout: dates down column A for [month], one column per habit with checkboxes. Give me step-by-step instructions, including: how to insert checkboxes, a formula for a weekly completion percentage per habit, a formula for the current streak for each habit, and conditional formatting to colour completed days green. Explain each formula in one plain sentence and tell me exactly which cell to put it in.Build it step by step
Follow the instructions, copying each formula into the cell it names. If something shows an error, paste the error back to your AI assistant and ask what to fix.
Keep it handy
Add the sheet to your phone's home screen through the Sheets or Excel app and set a daily reminder to tick it off.
What you get
Columns: Date | Water | Walk | Read | Bed by 11. Row 10 Nov: ticked, ticked, unticked, ticked. Weekly score: Water 86%, Walk 71%, Read 43%, Bed by 11 57%. Current streak: Water 6 days.
Tips
- Missing a day is normal; aim for 'never twice in a row' rather than a perfect streak.