Free template · Excel · Sheets · Numbers
Free Excel habit tracker template.
Grab a free habit tracker template for Excel, Google Sheets, or Apple Numbers: dates down the rows, habits across the columns, with green for done, red for missed, and gray for a skip. It tracks yes/no habits in grouped sections, plus numbers (weight, calories, sleep) and times of day (wake-up, bedtime) on a separate sheet. It is the actual spreadsheet I tracked in for months before turning it into the Habit Pocket app.
Free, no email. Opens in Excel, Google Sheets, and Apple Numbers.
Why this exists
I tracked in this exact spreadsheet for months.
Most habit apps need a phone, and I was trying to use my phone less. So I opened Apple Numbers and built my own: green for done, red for missed, gray for a day I chose to skip. Numbers like calories and weight got their own columns; so did my wake-up and bed times.
It stuck where apps hadn't, for two reasons. It was fast to bulk-edit, open the file and fill the day in seconds, and it was endlessly customizable. It was a canvas. After a few months I realized I just wasn't missing days anymore.
What it couldn't do was add up streaks, draw a chart on my phone, or sync between devices. So I turned the spreadsheet into Habit Pocket. This is the file it started as, free to take.
What's inside
A whole tracking system, not a blank grid.
The same setup you can see in the screenshots, ready to copy and make your own.
Green / red / gray cells
Every yes/no habit is green on a day you did it, red on a day you missed, and gray on a day you chose to skip. The whole month reads at a glance.
Dates down, habits across
One row per day, one column per habit. Fill a day in seconds, which is the trick that makes it stick.
Grouped into sections
Yes/no habits sit under headings like Essentials, Learning, and Moving Forward, so a long list still reads cleanly.
Numbers and times too
A separate sheet tracks the things a checkbox can’t: weight, calories, sleep score and hours, and your wake and bed times.
It’s a canvas
Rename habits, add columns, recolor, regroup. It is a plain spreadsheet, so it bends to whatever you want to track.
Numbers and Excel
The original is an Apple Numbers file, with an Excel (.xlsx) copy in the same folder. Open it wherever you work.
How to
How to make a habit tracker in Excel.
The shape of the spreadsheet, if you would rather build it from scratch.
- 1
Put dates down column A.
One row per day. Type your first date, then drag the fill handle (or use =A2+1) to fill the month.
- 2
Put habits across the top.
One column per habit. Group related ones under a merged section header like Essentials or Health.
- 3
Mark each day done, missed, or skip.
Type a check, an X, or a dash. Keep it to one or two characters so a day takes seconds.
- 4
Color the cells automatically.
Conditional Formatting: done turns the cell green, missed red, skip gray. This is the part that makes it feel alive.
- 5
Add numbers and times.
Give weight, calories, sleep, and wake/bed times their own columns, on their own sheet if it gets busy.
Or skip the setup: grab my spreadsheet with all of this already done.
When the file starts fighting you
The same grid, with the tedious parts automated.
A spreadsheet is a great place to start. The day you want streaks counted for you, a chart on your phone, or your edits synced between laptop and pocket, that is what Habit Pocket is: this template turned into an app, with four habit types and nothing to maintain.
FAQ
Excel habit tracker — common questions
Yes, completely free with no email or sign-up. It is shared from Google Drive, so you can open it, make your own copy, or download it in whatever format you like.
Yes. It started as an Apple Numbers file, and the same folder has an Excel (.xlsx) copy. Open the .xlsx in Excel, import it into Google Sheets with File then Import, or open the Numbers file on a Mac.
Each yes/no habit is green on a day you did it, red on a day you missed, and gray on a day you chose to skip. Numbers and times you just type into their own columns.
Same grid and the same four habit types, but streaks, charts, and correlation overlays are automatic, and it syncs across your phone and the web. The template is great until juggling the file, with no streaks or charts on your phone, gets old.
Five habits. Thirty days.
See what shows up.
No credit card. Pick five habits. Come back in a month.