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

ABCDEFGHIJ
1HabitMonTueWedThuFriSatSunDoneRate
2Drink 2L water☑☑☐☑☑☑☐571%
3Read 20 minutes☑☐☑☑☐☑☑571%
4Workout☑☐☑☐☑☐☐343%
5No phone after 10pm☐☑☑☑☑☑☑686%
6Journal☑☑☑☑☑☑☑7100%
Tab: Habits. Teal cells are live formulas; hover one to see it.

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. 1.Download the CSV and import it into Google Sheets.
  2. 2.Select B2:H6 and choose Insert → Checkbox. The TRUE/FALSE values become ticked and unticked boxes.
  3. 3.Replace the sample habits with your own.
  4. 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