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.

Use My Own Habits

habitkit-habit-tracker-2027.xlsx · 14 sheets · no sign-up

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.

3 of 10
Preview · Tap A Day
Month
Done That Day

Name a habit and it shows up here.

Grey days are off and never count as missed. Days still to come don't count either.

Rather have paper? Printable Habit Tracker

Open it where you like.

One file for all three. It keeps working without this website and without an account.

  1. Excel

    Open the file. Start on the Setup sheet, then type x on the days you did it.

  2. Google Sheets

    In Google Drive choose New, then File upload, and open the file with Google Sheets.

  3. 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.