FREE · EXCEL · GOOGLE SHEETS · NUMBERS
Free habit tracker spreadsheet 2027.
Twelve months, a setup sheet and your whole year in squares. Type x on a day and it counts your percentages by itself. No sign-up, no email.
habitkit-habit-tracker-2027.xlsx · 14 sheets · no sign-up
The file could not be made in this browser. Try again, or in another browser.
SHEET 1
One setup sheet
The only place you type your habits. Change one there and all twelve months follow.
SHEETS 2 TO 13
A sheet for every month
Type x on a day you did it. Each habit's month and every day get their percentage.
SHEET 14
Your year in squares
Every day of the year as one square that darkens as you go, like in the HabitKit app.
Make it yours.
Optional. Type your habits here and the file comes out ready. You can still change everything on the Setup sheet later.
Open it where you like.
One file for all three. It keeps working without this website and without an account.
Excel
Open the file. Start on the Setup sheet, then type x on the days you did it.
Google Sheets
In Google Drive choose New, then File upload, and open the file with Google Sheets.
Apple Numbers
Open the file on your Mac, iPhone or iPad. Numbers keeps the formulas.
Questions.
Is the habit tracker spreadsheet really free?
Yes. No sign-up, no email and no trial. The file is made in your browser, it is yours to keep, and nothing you type reaches us.
Does it work in Google Sheets?
Yes. In Google Drive choose New, then File upload, and open the file with Google Sheets. The percentages, the colours and the year view keep working.
How do I mark a day as done?
Type x in the day's cell on the month's sheet. Any mark counts. The habit's percentage for the month, the day's square and the Year sheet update by themselves.
What if a habit is only for some days of the week?
Put an x under those days on the Setup sheet, or leave them all empty for every day. The other days turn grey and never count as missed.
How is the percentage worked out?
Days you did it, divided by the days it was due so far. Days still to come and days before a habit starts are left out, so a new month starts empty rather than at 0%.
Can I add or change habits later?
Yes. The Setup sheet has room for ten habits. Type a new one into an empty row, or rename one, and every month and the Year sheet follow.
Want It On Your Phone, With Reminders?
HabitKit fills one square for every day you show up, reminds you when it's time and works offline. Free on iOS and Android.
Point your phone camera at the code to open HabitKit in the store.