Efficiency Sheets
Simple Sheets
Habit Tracker for Google Sheets
A Google Sheets habit tracker is a grid with your habits down the side and the days of the month across the top; you tick a box each day you do one. The sheet turns the ticks into percentages and charts, so you can see which habits are sticking.
Example
Halfway through a month, 15 days in
| Habit | Days done |
|---|---|
| Drink 2L of water | 14 |
| Walk 8,000 steps | 12 |
| Read 20 minutes | 11 |
| No phone after 10pm | 9 |
| Stretch in the morning | 8 |
| Journal | 6 |
Water is at 93% and journaling at 40%. Seeing that halfway through the month is the moment to make journaling easier, like 2 lines instead of a page.
How to set it up
- Write down 3 to 8 habits. Fewer is easier to keep.
- Make each one small and clear enough to tick: “read 20 minutes”, not “read more”.
- Tick the box each day you do it.
- Look at the percentages once a week and change any habit that's below half.
- Start a new month with the habits that stuck, and add one new one.
Questions
How many habits should I track?
Start with 3 to 5. Tracking 15 habits at once usually means ticking none of them by week 3.
Can I use it on my phone?
Yes. Checkboxes work in the Google Sheets app, so you can tick habits off from your phone.
What if I miss a day?
The month still counts. A habit you do 20 days out of 30 is a habit you're building.
