๐Ÿ—‚๏ธ Smart Planner Hub / Habit Planner
๐Ÿ”ฅ Smart Planner Hub

Habit Tracker Spreadsheet (Monthly & Yearly)

An editable, Excel-style habit tracker โ€” a 12-month grid with habits as rows and days 1โ€“31 as columns, plus an annual summary. Check off each day, download the whole workbook, or print a blank page to fill in by hand.

๐Ÿ“… Year Sets which real dates and weekdays this year's grid uses โ€” leap years get a Feb 29 column automatically.

Related Planners & Tools

Pair your habit tracker with a goal-focused view of what you're building toward.

What Is This Habit Tracker Spreadsheet?

This free habit tracker spreadsheet has a sheet for every month: list your habits in rows and tick each day you complete one. Completed counts and daily totals update automatically, and the annual summary shows your completion rate for the year with charts. It saves in your browser and downloads as Excel, PDF or images.

What's Included

How to Use It

This is a genuine editable spreadsheet, not a fixed template. Pick a month tab, type each habit's name into its own row, then check off the box for every day you complete it โ€” the Completed column and the daily totals along the bottom update automatically as you go. Add extra habit rows any time, or add a whole new column at the end if you want to track something beyond a daily checkbox. Use the Monthly Notes section below the grid for a longer reflection on the month as a whole.

Once you've filled in a few months, open the Annual Summary tab to see your completion rate for the year at a glance. When you're ready, download the entire 12-month workbook plus the annual summary as a single Excel (.xlsx) file that opens in Excel, Google Sheets or Numbers โ€” or print any page blank and fill it in by hand.

For stricter daily targets, try the discipline tracker. Plan each day in the daily planner, and connect habits to bigger aims in the goal planner. See every free planner in the planner hub.

๐Ÿ“š Recommended Productivity Books

Books we've found genuinely useful for building better habits. Some links below are affiliate links, if you buy through them, we may earn a small commission at no extra cost to you.

How the Habit Planner Works

Each month has its own grid with a column for every day. Ticking a box adds to that habit's done count, the daily total and the month's completion rate, and a day where every habit is ticked counts as a perfect day. The ring and bar charts update with every tick. Everything you type is saved automatically in your browser (local storage) on this device, so the sheet is still there when you come back, with nothing sent to a server and no account needed. Totals, completion rates and charts recalculate the moment a cell changes. When you want a copy, the export buttons build an Excel .xlsx file, a PNG or JPG image, or a PDF of the full planner, and the print buttons print one sheet or all of them. Because the data lives in one browser, use the Excel download if you want a backup or plan to switch devices.

Who Uses the Habit Planner?

How the Habit Planner Saves You Time

Habit apps take setup and nudge you to subscribe; a home-made spreadsheet needs formulas for every row. Here a month is ready in seconds and each check-in is one tap.

Frequently Asked Questions

Can I change the habit names?

Yes. Click directly into the Habit cell on any row and type a new name โ€” there's no fixed list, add as many habits as you want with the "Add Habit" button.

What does the Completed column show?

It's an automatic count of how many days you checked off that habit out of the days in the grid โ€” for example "18/31" โ€” so you can see your consistency for each habit at a glance.

What's the Monthly Notes section for?

It's a free-form space below the grid for a longer reflection โ€” what worked, what didn't, what to adjust next month. Add as many note boxes as you need with the "Add Note Box" button.

Can I print a blank copy to write on by hand?

Yes. Any sheet with empty cells prints as a blank grid ready for handwriting. Use "Print Full Planner" to print all 12 months plus the annual summary in one go.

Is this a daily habit tracker or a monthly one?

Both. Each month tab has a column for every day of that month, so you're checking off habits daily. Switch tabs to move between the 12 months, and the Annual Summary tab rolls the whole year up into one completion rate.

Can I download this as an Excel habit tracker spreadsheet?

Yes. The "Excel (.xlsx)" button exports all 12 months plus the annual summary as one workbook that opens in Excel, Google Sheets or Numbers, so you're not limited to using it only in the browser.

How is this different from a habit tracking app?

There are no push notifications, streak badges, or accounts here. It's closer to a paper habit tracker printable: you check boxes by hand (or click), it saves in your browser, and you can export or print it whenever you want.

Last updated: September 2026