Yes—you can make a free habit tracker spreadsheet template in Excel using a monthly grid, simple completion totals, and color formatting. You do not need a paid template, though using the Excel desktop app may require a license; Excel for the web is generally available free with a Microsoft account, subject to Microsoft’s current terms.
What a habit tracker spreadsheet includes
A habit tracker is a record of whether you completed selected routines on particular days. A basic spreadsheet has one row per habit and one column per date. You enter a mark when you complete a habit, then review the grid for patterns. Unlike a calendar reminder, the tracker records what happened; it does not by itself prompt you to act.
A monthly format is easy to scan and gives a clear reset point. For example, rows might be “walk,” “read for 20 minutes,” and “take medication,” while columns represent the days of the month. A separate total or percentage can summarize each row. The template can be as simple as text and numbers; formulas and colors are optional aids, not requirements.
This is a practical choice if you want to customize your habits, keep the file on your own device, or see several routines at once. It is less useful if you need reminders, automatic syncing with a wearable, or a detailed record of time and circumstances. A spreadsheet tracks the information you enter, so it cannot confirm that a task happened.
Make a free monthly tracker in Excel
In Excel for Microsoft 365 on Windows, create a blank workbook and lay it out as follows. The same basic cells and formulas work in Excel for the web. On Mac, the workbook structure is the same, though ribbon labels and shortcuts can differ slightly.
- Put the year in B1 and the month number in B2. For February 2026, enter 2026 and 2.
- Use B3:AF3 for the dates of the month. Enter the date formula below in B3, then fill it right through AF3. Format the row as dates using Home > Number Format.
- Put habit names in A5:A10, one per row. Leave room for more rows if you expect to add habits.
- Use B5:AF10 as the tracking grid. Enter 1 on a day you complete the habit and leave the cell blank if you do not. Add a short key, such as “1 = completed,” near the grid.
- Put a completion percentage beside each habit, for example in AG5, then fill that formula down for the other habits.
With the year in B1 and month number in B2, the following formula in B3 generates the first date and, when filled right through AF3, leaves cells beyond that month blank. For 2026 and 2, B3 returns February 1, 2026.
=IF(COLUMN()-COLUMN($B$3)+1<=DAY(EOMONTH(DATE($B$1,$B$2,1),0)),DATE($B$1,$B$2,COLUMN()-COLUMN($B$3)+1),"")
If you prefer not to use a formula for the calendar, type the dates yourself and leave unused columns blank. That can be easier when you only need one month, while the formula is useful when you reuse the workbook for different months.
Choose a marking method and make the grid readable
Using the number 1 for completion keeps formulas straightforward. You could instead type a checkmark or “Done,” but then the summary formula must count that exact entry. Pick one marking method and use it consistently. Blank cells should have one clear meaning, such as “not completed”; avoid mixing blanks, zeros, and notes unless you have a reason to distinguish them.
To highlight completed cells, select B5:AF10 and choose Home > Conditional Formatting > Highlight Cells Rules > Equal To. Enter 1 and choose a fill style. This makes completed days easier to spot without changing the underlying values. If you color cells manually, summaries will not automatically count the colors; formulas count cell contents, not visual formatting.
- Use short habit names so the row labels remain easy to read.
- Keep the date row visible while scrolling. In Excel, select the row below the dates and choose View > Freeze Panes > Freeze Panes.
- Give the workbook a clear name, such as “Habit tracker 2026,” and duplicate the sheet for a new month if you want to preserve past records.
- Use a notes column only if you will actually record useful context, such as why a planned workout was shortened.
On Windows, Ctrl+C and Ctrl+V copy and paste cells; on Mac, use Command+C and Command+V. These shortcuts are useful for copying a formatted month sheet, but check the year and month inputs afterward so the new sheet does not repeat the old dates.
Calculate completion totals and percentages
A percentage is more informative than a raw count when months have different numbers of days. With habit entries in B5:AF5 and valid dates in B3:AF3, put this formula in AG5 and copy it down. If the row contains 12 entries of 1 and February 2026 has 28 dates, the result is 12 divided by 28, or about 42.9%; format AG5 as a percentage to display approximately 43%.
=IFERROR(COUNTIF(B5:AF5,1)/COUNT($B$3:$AF$3),0)
The denominator counts actual date values, not all 31 possible columns, so the percentage is not unfairly lowered in shorter months. The formula treats every calendar day as an opportunity. If a habit is only planned for weekdays, this percentage will not represent the share of planned sessions unless you adjust the denominator to count only those planned days.
A total can also be easier to understand than a percentage. With the same B5:AF5 layout, use =COUNTIF(B5:AF5,1) in a summary cell. If 12 cells contain 1, it returns 12. Make sure the range includes only the day cells, not a total or note column, or the result may count something unintended.
Choose habits that make the tracker useful
Start with a small set of specific behaviors. “Exercise” can mean many things, while “walk for 20 minutes” has a clearer completion rule. “Eat better” is difficult to mark consistently; “pack lunch” is a more observable action. A useful habit should have a definition you can apply the same way on a busy day and a relaxed day.
Decide what counts before the month begins. If your goal is to read, does listening to an audiobook count? If your goal is movement, does a short stretch count, or only a planned walk? There is no universal rule: the point is to match the mark to your intention and keep the rule stable enough for comparisons to mean something.
Tracking too many behaviors can make daily entry feel like another chore. Begin with a few habits that matter to you, then add or remove rows after reviewing whether the tracker is helping. A missed day is information, not proof that the whole plan has failed. A spreadsheet can reveal patterns, but it cannot explain them without context you choose to record.
Common problems and how to interpret results
A blank cell is ambiguous if you have not defined it. It could mean “not done,” “not planned,” or “not entered yet.” For a daily habit, decide whether blanks count as missed days; for a habit scheduled only on certain days, mark planned days separately or calculate against the planned schedule. Otherwise, a percentage may look precise while answering the wrong question.
Another common mistake is treating a streak as the only measure of progress. A long streak can be motivating, but it can also make one missed day feel disproportionately important. Monthly completion rates, number of completed planned sessions, or simply noticing which routines fit your schedule may be more useful. Avoid comparing habits with different frequencies as though their percentages meant exactly the same thing.
Check formulas when you change the layout. If you insert a notes column inside the date range, a copied formula might count notes or miss days. If entries are typed as text such as “yes” while the formula looks for 1, the count will be zero. Select a few cells and verify that entries, date headers, and formula ranges match the stated layout.
Spreadsheet versus apps and printable trackers
A spreadsheet offers control over labels, layout, and calculations. It can be a good fit for someone comfortable editing cells who wants a record that is easy to adapt. It usually requires manual entry and does not necessarily provide phone notifications or integrations. A dedicated habit app may offer those features, but its exact options, price, data handling, and export capabilities vary by product.
A printable tracker is simpler if you prefer writing by hand or want a page visible near your desk. It has no formulas and can be harder to summarize across several months. A spreadsheet can preserve past records and calculate totals, but it depends on access to a compatible program and a file you maintain. You can also build the same kind of grid in Google Sheets; menu names and sharing behavior differ from Excel, so follow Google Sheets instructions for that version.
Cost, access, and privacy
The template described here does not require a paid download or special add-in. The software is a separate question: Excel desktop access may be part of a Microsoft 365 subscription or another license, while Excel for the web is generally offered at no cost with a Microsoft account. Availability and terms can change, so check Microsoft’s current product information rather than assuming every Excel feature is free.
A habit log can contain personal information, especially if it tracks health-related routines. Store it somewhere you consider appropriate, use a device account protected by a strong password, and be cautious about sharing links or placing a file in a shared folder. If you use cloud storage, review the service’s sharing settings and who has access. Do not include sensitive details that are unnecessary for the purpose of the tracker.
Frequently Asked Questions
Is there a free habit tracker spreadsheet template?
You can create one from the layout above without buying a template. Excel for the web is generally free with a Microsoft account, while desktop Excel may require a license. A template’s price and software access are separate issues.
Can I use this habit tracker in Google Sheets?
Yes. The grid idea and basic COUNTIF calculation also work in Google Sheets, but its menus and sharing settings are different. Use the Google Sheets interface when formatting or changing sharing permissions.
How many habits should I track at once?
There is no fixed ideal number. Start with a few behaviors you can define clearly and enter consistently. Add more only if the daily upkeep remains manageable and the extra rows provide information you will use.
How do I track a habit that happens three times a week?
Decide which days are planned, then count completions against those planned sessions rather than all calendar days. You can note the schedule above the grid or mark planned days separately; otherwise, a daily denominator will misstate your completion rate.
Can the spreadsheet send reminders?
A basic tracker grid does not send reminders by itself. Use a calendar, alarm, or app with reminder features if prompts are important, and enter the result in the spreadsheet when you want to keep a record.
Related
- How to Open XML Files in Excel and Import Their Data
- How to Open a ZIP File in Excel: Extract and Import Data
- How to Open Version History in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Percentage of a Number in Excel: How to Calculate ItTo find a percentage of a number in Excel, multiply the number by the percentage. For example, with…
- Excel Number Format: Display Zero Values as DashesTo display numeric zeros as dashes in Excel for Microsoft 365 on Windows, apply a custom number format…
- Excel Not Letting Me Insert a Row? Fixes That WorkIf Excel won’t let you insert a row, select the row number where it should go, then choose…
- How to Find a Circular Reference in Excel Step by StepTo find a circular reference in Excel for Microsoft 365 on Windows, open Formulas > Error Checking >…
- How to Auto Wrap Text in Google Sheets: A Quick GuideTo automatically show long text on multiple lines in Google Sheets, select the cells, then choose Format >…
- Insert a Check Box in Word 2016: Clickable or PrintableTo add a box that readers can click in Word 2016, open the Developer tab and choose Developer…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.