Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Habit | Category | Goal (days) | Days done | Completion so far | Progress to goal | Status | Current streak | Longest streak |
|---|---|---|---|---|---|---|---|---|
| Walk 30 minutes | Health | 24 | 12 | 80.0% | 50.0% | On track | 4 | 5 |
| Drink 2 litres of water | Health | 28 | 14 | 93.3% | 50.0% | On track | 7 | 7 |
| Read 20 pages | Mind | 20 | 9 | 60.0% | 45.0% | Behind | 1 | 2 |
| Meditate 10 minutes | Mind | 20 | 10 | 66.7% | 50.0% | On track | 3 | 3 |
| Inbox zero by 5 pm | Work | 22 | 11 | 73.3% | 50.0% | On track | 1 | 5 |
| Tidy the kitchen | Home | 25 | 14 | 93.3% | 56.0% | On track | 2 | 12 |
| Call family or a friend | Social | 8 | 3 | 20.0% | 37.5% | Behind | 1 | 1 |
| Review spending | Money | 12 | 3 | 20.0% | 25.0% | Behind | 0 | 1 |
Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: Overall completion, habits tracked, check-ins so far, goals met and habits behind pace, the best and weakest habit and the longest streak with the habit that holds it. A table of every habit with goal, days done, completion, progress to goal, status and streaks, then weekly completion, check-ins by category and check-ins per day, with four charts.
- Tracker: One row per habit and one box per day. Type x in a box to mark a day. The grey columns on the right show days done, completion so far, progress to goal, status, current streak and longest streak. Days after the end of the month are shaded and ignored.
- Settings: Your name, the first day of the month, the as-of date (normally today), and the list of up to 15 habits with a monthly goal and a category for each.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
A grid of boxes shows you what you did; it does not tell you whether you are keeping up. This tracker compares each habit with the pace needed to hit its goal by today and says Goal met, On track or Behind. The streak counts back from yesterday if today is not marked yet, so your streak does not drop to zero before the day is over. The sample is eight habits over the first 15 days of November 2026, so every column and chart is filled before you replace it with your own.
How do I make a habit tracker in Excel?
The simplest layout is habits down the side and the days of the month across the top, with a box for each day. You mark a box when the habit is done and use COUNTIF on each row to count the marks. That is the part most free templates stop at.
The two things people then ask for are a completion percentage and a streak. Completion is days done divided by days passed so far, not by the whole month, otherwise every habit looks bad on the 10th. A streak needs a helper cell for each day that adds one to yesterday's run when the box is marked and resets to zero when it is not. This template has both, with the helper cells in hidden columns so the sheet stays clean.
How do I track a streak in a habit tracker spreadsheet?
The current streak is the number of marked days in a row ending at the as-of date; the longest streak is the best run anywhere in the month. In the sample, Tidy the kitchen has the longest streak, 12 days in a row, while Drink 2 litres of water has the longest streak still running, 7 days.
If today is not marked yet, the current streak counts back from yesterday. That matches how people actually use a tracker: you tick things off in the evening, and the number should not read zero all day.
What counts as on track for a monthly goal?
Each habit has a goal, the number of days you aim to do it this month. Status is Goal met once days done reaches the goal. Before that it is On track if you are at or above the pace needed by this date (goal x days passed / days in the month), and Behind otherwise.
In the sample, 76 check-ins out of 120 possible give an overall completion of 63.3%. No habit has reached its goal yet, five are on track and three are behind: Read 20 pages, Call family or a friend and Review spending. Those low-frequency habits also need a realistic goal, so set 8 calls for the month, not 30.
How to use it
- On Settings type your name, the first day of the month you are tracking, and an "as of" date (normally today). List up to 15 habits, with a goal (days you aim to do it this month) and a category for each.
- On Tracker, type x in the box of every day you did a habit. Days after the end of the month are shaded and ignored.
- The grey columns on the right show days done, completion so far, progress to goal, a status, your current streak and your longest streak.
- Open Dashboard for the overall completion rate, the best and weakest habit, weekly rates, check-ins by category and charts.
- Each day, move the "as of" date on Settings forward. At the start of a new month, save a copy of the file and change the month start date.
Before you start:
- Completion so far = days done / days passed this month (up to the "as of" date). Progress to goal = days done / your monthly goal.
- Status: Goal met when days done reaches the goal; On track when you are at or above the pace needed for the goal by this date; otherwise Behind.
- Current streak = consecutive marked days ending on the "as of" date. If today is not marked yet, the streak counts back from yesterday, so it does not drop to zero before the day is over.
- Only a lowercase or capital x counts. Any other character in a day box is ignored.
- Capacity: 15 habits and up to 31 days. The columns AO to BS on Tracker are hidden helper columns for the streaks; do not delete them.
- Habit tracking is a personal organiser, not medical or mental-health advice.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Is there a free monthly habit tracker for Excel?
Yes, this one is free. You mark each day with an x and the sheet calculates completion, progress to your goal, streaks and a status for every habit.
How do I mark a habit as done?
Type a lowercase or capital x in the day box. Any other character is ignored. The box turns green when it counts.
How do I start a new month?
Save a copy of the file for the old month, then change the first day of the month on Settings, clear the x marks on Tracker and move the as-of date forward each day.
Does it count days that have not happened yet?
No. Completion so far divides by days passed up to the as-of date, so the future part of the month does not drag the percentage down.
Does it work in Google Sheets?
Yes. It uses ordinary formulas that Excel, LibreOffice and Google Sheets all calculate. Upload the file to Google Drive and open it with Google Sheets.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Personal finance
More free templates
- Expense Tracker Template for Excel
- Monthly Household Budget Template for Excel
- Rotating Savings Club Tracker for Excel (Susu, Tanda, ROSCA)
- General Journal and Trial Balance Template for Excel
- Delivery Tracking Spreadsheet for Excel (Dispatch Tracker)
- Real Estate Lead Tracking Spreadsheet (Excel)
- Production Tracking Spreadsheet for Excel
- Piece Rate Payroll Calculator for Excel
- Garment Costing Sheet for Excel
- Poultry Flock Tracker for Excel: Eggs, Feed, Mortality and Profit
- Dental Practice Treatment Plan Tracker for Excel