2027 Habit Tracker Spreadsheet, Daily, Weekly, Monthly Goals, Year Heatmap (Excel & Google Sheets)

Mark the day with an x. Your streaks, monthly scores and your whole year fill in by themselves. A habit tracker spreadsheet for Excel and Google Sheets with daily, weekly and monthly goals, a year heatmap and quarterly scores.

Works in Excel 2016 and newer (Windows and Mac) and Google Sheets. Instant download, no macros, no app or subscription.

━━━━━━━━━━━━━━━━━━
WHY THIS ONE IS DIFFERENT
━━━━━━━━━━━━━━━━━━
We read the reviews of best-selling habit tracker spreadsheets and fixed what buyers complained about:

✔ The bars don't move, features don't work. Classic formulas, tested in Excel and Google Sheets against a separate model.
✔ The file was corrupted, or never arrived. A real .xlsx you download instantly. No access links, no copies to request.
✔ No yearly or quarterly view. A full YEAR page: every day as a heatmap, then each habit by month, quarter and year.
✔ Every habit has to be daily. Daily, X times a week or X times a month. Each habit is scored against its own goal.
✔ Locked to one year. Any year: leave it blank for this year, or type next year and plan ahead.
✔ No streaks. Current and best streak for every daily habit, worked out for you.

━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE
━━━━━━━━━━━━━━━━━━
• DASHBOARD: this month and year so far for each habit, current and best streak, perfect days, habits done today and a month-by-month chart.
• 12 MONTH PAGES: up to 20 habits, one row each. Type x on the days you did it. Done, goal so far and % fill in. Today's column is highlighted, weekends are shaded, and a day score shows how much of your list you did.
• MOOD: rate each day 1 to 5 if you like. The month average sits at the end of the page.
• YEAR: every day of the year as a heatmap, then each habit by month, by quarter (Q1 to Q4) and for the whole year.
• SETUP: your name, the year, 4 color themes and your habits with their goals.

━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━
1. On SETUP, type your habits and pick a goal for each: Daily, Times a week or Times a month.
2. Open this month's page and type x on the days you did it.
3. That's it. The dashboard and the year view fill in by themselves.

Scores are fair for every kind of goal: % = done ÷ what the goal asks for so far. A 3-times-a-week workout done 3 times this week is 100%.

━━━━━━━━━━━━━━━━━━
WHAT YOU GET
━━━━━━━━━━━━━━━━━━
• Habit_Tracker_BLANK.xlsx: ready for your habits
• Habit_Tracker_SAMPLE.xlsx: a year of habits (fictional), so you can see how everything works
• Start page with a short guide inside the file

━━━━━━━━━━━━━━━━━━
GOOD TO KNOW
━━━━━━━━━━━━━━━━━━
• Google Sheets: upload the .xlsx file to Google Drive and open it with Google Sheets.
• Month pages and SETUP are not locked. The dashboard and year pages are protected without a password, only so formulas are not deleted by accident.
• This is a digital file. Nothing will be shipped.
• Personal use. Please do not share or resell the file.

Questions? Send us a message on Etsy, we reply quickly.