Taking a daily walk, remembering medication, drinking enough water, calling a friend: small habits add up, and a simple checklist makes them easier to keep. A spreadsheet is a good home for that checklist because the templates are free to download, the layout is simple, and you control every detail.
Table of Contents
This guide shows how to get a simple Excel habit tracker running, either by downloading a free template or by building your own in about ten minutes. It also covers how to use it without paying for anything, since Excel for the web is free with a Microsoft account, and the choices that matter most for older users: large text, high contrast, a small number of habits, and no complicated features.
Download the Free ZenDuel Excel Habit Tracker
Our own printables — free, no sign-up, no email required. A ready-made Excel tracker with automatic totals, plus a large-print PDF (big text, thick lines) if a paper copy is easier to use.
Quick Answer
The easiest option is to download a free habit tracker from a template site, open it in Excel, and replace the sample habits with your own. If you would rather build one, list your habits down the left side, put the days of the month across the top, add checkboxes to the grid, and use conditional formatting to turn ticked boxes green. The templates are free, but the Excel desktop app is not: it comes with a Microsoft 365 subscription or a one-time purchase of an Office version. If you don’t have it, Excel for the web is a free alternative.
What You Need to Open It (Free Options)
Desktop Excel is licensed either through a Microsoft 365 subscription or as a one-time purchase of a version such as Office 2021 or 2024. You may already have it if you have a Microsoft 365 plan or bought Office with your computer.
If you don’t, Excel for the web runs in a browser and is free with a Microsoft account. It has fewer features than the desktop app and does not run macros, but a simple habit tracker doesn’t need them. Free .xlsx trackers also often open in Google Sheets. Whichever you use, test the file with a few entries first, because checkboxes and conditional formatting can look slightly different between programs.
Option 1: Start With a Free Template
Many sites offer free Excel habit trackers, including New Orchards, Excel Guru, xlstemplate.com and 24Billions. Some are plain .xlsx files that work in both Excel and Google Sheets. Check each site’s terms before you download, as some ask for an email address and others do not.
Whichever one you choose, look for these traits. It should have a short list of habits (five or six at most). It should have one clear grid with a row per habit and a column per day. It should have no macros, because a file that asks you to enable macros or content is more complicated than you need and is best avoided. Download only from sites you trust, and let your antivirus scan the file if you have one.
Once it is open, click a habit name and type over it with your own. Then use the tips further down to enlarge the text and clean up the layout.
Option 2: Build Your Own in 10 Minutes
Step 1: Open a blank workbook. In cell A1, type a title such as “My Daily Habits.” In cell A3 and below, type one habit per row, for example “Morning walk,” “Take vitamins,” “Drink water,” and “Call family or a friend.”
Step 2: Across row 3, starting in column B, type the numbers 1 to 31 for the days of the month. For a weekly tracker, type Mon, Tue, Wed and so on instead. A weekly layout is much easier to read on a smaller screen.
Step 3: Select the empty grid where habits and days meet. In Microsoft 365 versions of Excel (and Excel for the web), go to the Insert tab, choose Checkbox in the Controls group, and a checkbox appears in every selected cell. Each box holds a TRUE or FALSE value behind the scenes. One-time-purchase versions such as Excel 2019, 2021 or 2024 don’t offer this button. If yours doesn’t, skip checkboxes and type an X or a 1 in a cell when you finish a habit.
Step 4: Add color feedback. With the grid still selected, go to Home, then Conditional Formatting, then Highlight Cells Rules, then Equal To. Type TRUE and choose a green fill. Now every ticked box turns green, and gaps in the month are easy to spot at a glance. If you typed Xs instead, choose the same rule and type X.
Step 5: Add a simple total. In the column after the last day, type =COUNTIF(B4:AF4,TRUE) beside the first habit, adjusting the range to match your grid, and copy it down. This counts how many days you completed that habit. For an X-based tracker, use =COUNTIF(B4:AF4,”X”) instead. This is the only formula you need.
Make It Easier to Read
Comfort matters more than looks. Select all cells (Ctrl+A), then raise the font size on the Home tab to something you can read without leaning in. Widen the habit column so no name is cut off, and increase row height so the boxes are easy to click. Excel’s zoom slider at the bottom right of the window lets you enlarge the whole sheet.
Use strong contrast: dark text on a white background, and a bold green for completed days rather than a pale tint. Bold the header row and add borders to the grid so the rows and columns stand out.
Finally, save the file to your Desktop or Documents folder with a clear name like “Habit Tracker.xlsx,” and pin it or create a shortcut so it is one click away. If you do not use a computer daily, a printed copy on a fridge or desk can work just as well as a screen.
Tips / Common Mistakes
Start small. Tracking three habits you will actually complete is better than a page of ten you abandon. Add more only after a few weeks of steady use.
Tie each habit to something you already do, such as taking vitamins with breakfast or walking after lunch. Open the tracker at the same moment each day so checking it becomes part of the routine.
Do not aim for perfection. A missed day is just a blank cell, not a failure. Look at the month as a whole and notice which habits are working.
Avoid over-engineering. Charts, dashboards and macros look impressive but add ways for things to break. If a template feels confusing, delete the extras or pick a simpler one.
Save often. Press Ctrl+S after ticking your boxes, and consider keeping a backup copy on a USB drive or in cloud storage.
A habit tracker is not a substitute for medical advice. If you use it to track medications or health routines, follow your doctor’s or pharmacist’s instructions and treat the sheet as a reminder only.
Explore more: More habit-building guides and tools.
Excel habit tracker for seniors FAQs
Is Excel free to use for a habit tracker?
Only Excel for the web is free, and it needs a free Microsoft account. The desktop Excel app requires a Microsoft 365 subscription or a one-time purchase of an Office version. Many free .xlsx habit trackers also open in Google Sheets, so you have free options either way.
Do I need the newest version of Excel to use a habit tracker?
No. Any version of Excel can run a habit tracker if you type an X or a 1 in each cell. The click-to-tick checkboxes built into cells are available in Microsoft 365. Excel 2019, 2021 and 2024 can use Form Control checkboxes from the Developer tab, which are fiddlier to set up, so plain Xs are often simpler.
How many habits should I track?
Three to five is a good range to begin with. A short list keeps the sheet readable and makes it more likely you will keep using it. Add another habit once the current ones feel automatic.
Is a printed tracker better than an Excel one?
It depends on your routine. Excel is good if you already spend time at the computer and like automatic totals. A printed copy is good if you want the tracker in plain sight. You can build it in Excel and print it each month.
Skip the Spreadsheet — Track It in ZenDuel
Habit streaks, mood tracking, and accountability duels in one free app — no template maintenance required. Get ZenDuel.
Want a calmer inbox? Subscribe to the free newsletter.
Photo: Shixart1985 / CC BY 2.0, via Wikimedia Commons.
