Personal template
Habit Tracker
30-day grid with completion rate and a data bar per habit.
- Live formulas
- 16
- Columns
- 33
- File
- 9 KB
$5
Checkout opening soonOr get it with all 66 paid templates in the complete pack — $45.
Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print landscape on one page wide.
About this Habit Tracker template
Habits stick when you can see the streak. This Excel habit tracker gives each habit a row across a 30-day grid — mark an X on each day you complete it — and counts the days done and the completion rate.
The month summary shows total completions, your best and weakest habits and your average completion rate.
Good for
- →Building daily habits such as exercise, reading or journaling
- →Tracking a 30-day challenge
- →Seeing which habits are slipping
What it works out for you
Month
- →Total completions
- →Best habit
- →Weakest habit
- →Average completion
What you fill in
The table has 33 columns. Calculated columns fill themselves in; the rest are yours to type over.
- →Habit
- →1
- →2
- →3
- →4
- →5
- →6
- →7
- →8
- →9
- →10
- →11
- →12
- →13
- →14
- →15
- →16
- →17
- →18
- →19
- →20
- →21
- →22
- →23
- →24
- →25
- →26
- →27
- →28
- →29
- →30
- →Done
- →% of days
How to use it
Mark an X on each day you complete the habit. The count and completion rate follow.
The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.
Functions it uses
Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.
AVERAGECOUNTIFINDEXMATCHMAXMINSUMQuestions about the Habit Tracker
How do I mark a day?
Type an X in that day's cell. The count and completion rate for the habit update.
How is the completion rate calculated?
The days marked as done as a share of the 30 days in the grid.
Can I track more habits?
Yes. Insert rows inside the habit list and the summary includes them.
