Free template
Habit tracker spreadsheet
Type your habits, pick a month, download it. Opens in Google Sheets, Excel or Numbers, and counts your ticks for you.
Opens in Google Sheets, Excel, Numbers or LibreOffice. Put an x in a day to mark it done.
Preview, first seven days
| Habit | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Done |
|---|---|---|---|---|---|---|---|---|
| Drink water | 0 | |||||||
| Read 10 pages | 0 | |||||||
| Move for 20 min | 0 | |||||||
| Make the bed | 0 | |||||||
| No phone in bed | 0 |
The download has all 30 days of September, not seven.
What you get
One row per habit and one column per day of the month you pick, so February is 29 columns and March is 31 rather than everything being a generic 31 and you remembering which ones to ignore.
Two columns at the end do the counting. Done runs a COUNTIF across the row for every x you have entered. Rate divides that by the number of days and formats it as a percentage. Both are real formulas in the file, not values baked in at download, so they keep working as you fill the month in.
Mark a day with an x
The counting formulas look for the letter x, lowercase or uppercase. Anything else in the cell is ignored, so you can leave notes in a day without inflating the count. If you would rather tick boxes, both Sheets and Excel can add real checkboxes to the day range, though you will need to swap the COUNTIF to count TRUE instead.
Why a spreadsheet at all
Because it answers the question paper cannot: how often, over how long. A grid on the fridge tells you about this month. A sheet tells you that you have done the thing 62 percent of the days since March, which is the number that changes behaviour once you see it.
The cost is friction. Logging in a spreadsheet means opening a laptop to record nine seconds of effort, and that is exactly the gap where tracking dies. Which is the argument for paper on the wall, or for something that lives on your phone.
Spreadsheet template questions
Is this habit tracker spreadsheet free?
Yes. No account, no email, no watermark. Type your habits, download the file, and use it however you like.
How do I open it in Google Sheets?
Download the CSV, then in Google Sheets pick File, Import, Upload, and choose Replace spreadsheet. Importing rather than double-clicking is what keeps the two formula columns live. Opening it from Drive works too, and Sheets will convert it.
Does it work in Excel or Numbers?
Both. CSV is the one spreadsheet format everything opens, and the file carries a byte order mark so Excel reads it as UTF-8 rather than mangling anything accented. Save it as .xlsx or .numbers afterwards if you want to keep the formatting.
What do the Done and Rate columns do?
Done counts every day you put an x in, using COUNTIF across that habit's row. Rate divides it by the number of days in the month and shows a percentage. Both update as you fill the row in, so you never count squares.
Should I use a spreadsheet or paper?
Paper if you want the tracker in front of you without opening anything, which is most of the reason tracking works at all. A spreadsheet if you want the arithmetic done and a year you can look back over. Plenty of people run both, one on the fridge and one for the monthly review.
Related
- Printable habit trackerSix paper layouts, from a monthly grid to a 100 day challenge. Print it or save a PDF.
- 117 habits worth trackingA categorised list, if you are staring at an empty first column wondering what goes in it.
- Streak RepairWhat Fuego does with a missed day, which a spreadsheet has no opinion about.
- All templatesEvery format, and an honest note on which one survives.
Prefer it on your phone?
A spreadsheet does the maths. Fuego does the reminding.
Join 
people building streaks in 13 countries.