A free habit tracker spreadsheet for Excel and Google Sheets. Type an x under each day you keep a habit and the totals, misses and percentages work themselves out. No sign-up, no email, no watermark.
Written & reviewed by Ahmad Hussain · September 2026
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | AH | AI | AJ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Habit | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | Done | Miss | % |
| Drink water | x | x | x | x | x | x | x | x | x | x | x | 26 | 5 | 84% | |||
| Read 10 pages | x | x | x | x | x | x | x | x | x | x | 19 | 12 | 61% | ||||
| Walk 20 min | x | x | x | x | x | x | x | x | x | x | 24 | 7 | 77% | ||||
| No sugar | x | x | x | x | x | x | x | x | x | x | x | 12 | 19 | 39% | |||
| Lights out 11 | x | x | x | x | x | x | x | x | x | x | x | 22 | 9 | 71% |
One file, three tabs, ready to use. Works in Excel, Google Sheets, LibreOffice Calc and Numbers.
What calculates itself:
Days done, days missed, completion percentage per habit, a daily total across every habit, and an overall score for the month. Anything at 80% or above turns green; anything below 50% turns amber.
Monthly Tracker. Ten habit rows across 31 day columns. Type the month in C2 and the number of days in H2 — 28, 29, 30 or 31 — and every percentage recalculates against the right denominator. This is the tab most people use and ignore the other two.
Weekly Tracker. Seven habit rows across Monday to Sunday. Worth using for the first month if you've never kept a tracker before; a week of boxes is a far smaller commitment than a month of them, and you can print four copies of it.
Read me. The instructions, the colour key, and the one rule that matters: start with three habits, not ten.
Between them the two grids cover almost every way people use a habit tracking spreadsheet: a month at a glance, or a week you can actually finish.
Every cell you're meant to type in is shaded yellow. Everything else is a formula. If a number looks wrong, check H2 first — a 30-day month left at 31 will drag every percentage down slightly.
The file is .xlsx, but Google Sheets opens it without losing anything — formulas, colour rules and the x-only dropdown all survive the conversion.
Six steps to set the excel habit tracker up for your own month. Nothing here needs a recent version — the whole habit tracking spreadsheet runs on COUNTA and division.
If you'd rather build your own than use mine, there are only three formulas in the whole thing. Here they are.
=COUNTA(C6:AG6)Counts how many days you marked. COUNTA counts any cell that isn't empty, which is why an x, a tick, a 1 or the word yes all work the same way. Use COUNTIF instead if you want to count only one specific mark.
=IF($B6="","",$H$2-AH6)Days missed: the month length minus the days done. The IF wrapper leaves the cell blank when there's no habit in that row, so empty rows don't show a misleading number.
=IF($B6="","",IFERROR(AH6/$H$2,""))Completion percentage. IFERROR catches the divide-by-zero you'd otherwise get before H2 is filled in. Format the cell as a percentage rather than multiplying by 100.
Conditional formatting → Cell value → greater than or equal to → 0.8The green and amber shading. Two rules on the percentage column: one for 0.8 and above, one for below 0.5. Note the thresholds are decimals, not 80 and 50 — percentage formatting is display only.
Building it from scratch takes about twenty minutes, and you'll understand it better afterwards. Building it badly takes an afternoon, which is the reason this page exists.
A spreadsheet habit tracker wins on arithmetic. It totals, it averages, it colours itself in, and you can chart a year without touching a calculator. If you already have Excel or Sheets open all day, this is the lower-friction option by a distance.
It loses on visibility, and that matters more than people expect. A sheet on the fridge gets filled in because you walk past it. A spreadsheet gets filled in when you remember to open the file, which is a different and much weaker trigger. Most people who abandon a digital tracker abandon it because they stopped opening it, not because they stopped caring.
My honest advice: if you've never kept a tracker at all, start on paper with a printable habit tracker template and move to a spreadsheet once the habit of tracking is itself a habit. If you're already a spreadsheet person, ignore that and download the file.
Yes. Download it, use it, change it, share it. No email address, no account, no trial. The only thing I'd ask is that you don't resell it as your own product.
Yes. Upload the file to Google Drive and open it with Google Sheets — every formula and colour rule carries across. There's a step-by-step further up this page.
Yes — it's an .xlsx file, so it is a habit tracker Excel template. I've called it a spreadsheet throughout because it works just as well in Google Sheets, and calling it an Excel file makes people think it won't.
Anything from Excel 2010 onwards, plus Excel for Mac, Excel Online, LibreOffice Calc and Numbers. It uses only COUNTA and basic arithmetic, so there's nothing version-specific in it.
You can, but I'd argue against it. Ten habits across a month is 310 boxes. If you want more rows, insert them above row 15 and the formulas will copy down; the totals row will adjust on its own.
The formulas use COUNTA, which counts anything that isn't empty. So an x, a tick, a 1 or the word yes all work identically. An x is just the fastest thing to type.
Probably not, and I wouldn't use both. The spreadsheet is for people who live in Excel or Sheets anyway. If you'd rather have something on the fridge, the printable templates are the better tool.
Yes. Share the Google Sheets copy and each person can duplicate their own tab. Nothing in the file is licensed per-seat.
What to put on the rows, which interval to use, and what to do when it stops working.
126 free printable habit trackers, or build your own in about a minute.
Browse the templates →A free habit tracker printable maker. Design it, print it, tick it — no account, no cost.
TrackTheHabit uses cookies for basic site function, analytics and advertising. By continuing you agree to our Terms and Privacy Policy.
Save it for one-tap access to your habit tracker — no app store, no download.
📱 Tap the Share button in your browser bar, scroll down, then choose “Add to Home Screen”.