What's in the templates
- Dates that fill themselves in. Type the first day of the month (or the year, in the 12-month workbook) in the yellow cell. Every date and weekday letter updates, weekends are shaded, and days past the end of a short month grey out.
- Boxes that colour themselves. Type x, 1, a tick or anything else in a box and it turns green. Delete it and it clears.
- Done and % of goal. Each habit counts its marked days. Leave "Goal" empty to aim for every day, or type a number like 12 for "three times a week".
- Daily score. A row under the grid shows how many habits you did each day, which makes good and bad weeks easy to spot.
- A year summary (12-month workbook). Your habits are typed once on the January tab and copied to every month; the summary tab shows each habit's total per month, shaded so the strongest months stand out.
How to use it in Google Sheets
- Download the .xlsx file you want.
- Open a new Google Sheet, then choose File → Import → Upload and select the file.
- Choose Replace spreadsheet and click Import data.
- Change the yellow date cell and type your habits. That's it.
The formulas and colours come across. The bars in the "% of goal" column are an Excel feature, so Google Sheets shows plain percentages there instead.
Prefer checkboxes? Select the grid, choose Insert → Checkbox, then change the Done formula from COUNTA(…) to COUNTIF(…,TRUE). An unticked checkbox counts as a filled cell, so without that change every day would count as done.
How to use it in Excel or Numbers
Open the file and start typing: there are no macros to enable and nothing to install. In Excel the "% of goal" column shows a progress bar. In Apple Numbers on a Mac, iPad or iPhone the dates and totals work the same way, though a few colours may look slightly different. Each sheet is set to print on one page, so you can also print it and fill it in by hand.
Tips for a spreadsheet habit tracker
- Keep it to five habits to start. The template has room for fifteen, but a short list you actually fill in beats a long one you abandon. Not sure which five? See 100 habit tracker ideas, by goal.
- Pin it where you'll see it. A spreadsheet only works if you open it. Bookmark it on your phone's home screen or keep it as a pinned browser tab.
- Use the goal column for habits that aren't daily so the percentage reflects what you actually planned.
- Review on Sundays. Look at the daily score row: the days with the lowest scores usually explain more than the habits do.
Spreadsheet, paper or app?
A spreadsheet is the best of the three for totals and history: it never forgets a month and does the maths for you. Its weakness is friction, especially on a phone, where tapping tiny cells is fiddly. If you like paper, our free printable habit tracker makes a print-ready monthly, weekly or 30-day sheet from your own habits. To track in the browser, use the free online habit tracker.
If you'd rather tap once on your iPhone: Tend is our habit tracker app. Each habit has a daily target shown as a ring, keeps its streak and full history, and can be ticked off from a Home Screen widget. It also counts things without a goal, like coffees or pages read, and is free to start with an optional one-time Lifetime unlock.
Frequently asked questions
Does the habit tracker template work in Google Sheets?
Yes. In Google Sheets choose File, Import, Upload, pick the downloaded .xlsx file and select Replace spreadsheet. The formulas and colours carry over. The progress bars in the % of goal column are an Excel feature and show as plain percentages in Google Sheets.
Can I use checkboxes instead of typing an x?
Yes, but change the Done formula. An unticked checkbox counts as filled, so replace COUNTA(range) with COUNTIF(range,TRUE) in the Done column after inserting checkboxes.
How do I add more habits?
Each template has 15 habit rows (12 on the weekly). To add more, insert a row inside the habit block, not below it, then copy a filled row down so the formulas and colours come with it.
Does it work in Apple Numbers?
Yes. Open the .xlsx in Numbers on a Mac, iPad or iPhone. Dates, totals and percentages work; some conditional colours may look slightly different.
Are the templates free?
Yes, for personal, family, classroom or team use. There is no sign-up and no macros, just formulas.