Free Google Sheets Habit Tracker
Tick each habit off as you do it. The sheet counts the days you hit and turns it into a weekly completion rate.
What it looks like
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Habit | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Done | Rate |
| 2 | Drink 2L water | ☑ | ☑ | ☐ | ☑ | ☑ | ☑ | ☐ | 5 | 71% |
| 3 | Read 20 minutes | ☑ | ☐ | ☑ | ☑ | ☐ | ☑ | ☑ | 5 | 71% |
| 4 | Workout | ☑ | ☐ | ☑ | ☐ | ☑ | ☐ | ☐ | 3 | 43% |
| 5 | No phone after 10pm | ☐ | ☑ | ☑ | ☑ | ☑ | ☑ | ☑ | 6 | 86% |
| 6 | Journal | ☑ | ☑ | ☑ | ☑ | ☑ | ☑ | ☑ | 7 | 100% |
What's included
- Real checkboxes (TRUE/FALSE) for every day
- Days completed and weekly rate per habit
- Add as many habits as you like
How to set up the habit tracker
- 1.Download the CSV and import it into Google Sheets.
- 2.Select B2:H6 and choose Insert → Checkbox. The TRUE/FALSE values become ticked and unticked boxes.
- 3.Replace the sample habits with your own.
- 4.Add a colour scale to the Done column (Format → Conditional formatting → Colour scale) to see streaks at a glance.
Questions
- How do I track a whole month?
- Add columns for each day of the month, change the COUNTIF range to cover them, and divide by the number of days instead of 7.
More templates
Weekly Schedule Template
An hour-by-hour weekly schedule for Google Sheets that counts how many hours you've booked each day.
Get the templateCalendar Template 2026
A Monday-first monthly calendar for Google Sheets that rebuilds itself when you change the month.
Get the templateBudget Template
A free monthly budget for Google Sheets that compares what you planned with what you actually spent.
Get the template