Habit Tracker Excel Spreadsheet 2027, Yearly Habit and Goal Tracker, Streaks, Dashboard

Habit tracker Excel spreadsheet for 2027, also for Google Sheets: a yearly habit and goal tracker for up to 12 habits day by day and up to 6 goals in one file. Type x on the days you did a habit and the sheet works out your month %, whether you hit your weekly target, your streaks and how each goal is doing against its deadline.

WHAT IT DOES
- Setup tab: the year (2027 to start, change it and every date follows), up to 12 habits with a category and a target of 1 to 7 days a week, and up to 6 goals with a unit, start value, target value and deadline
- 12 month tabs: your habits down the side and every day of the month across, with the weekday under each date. Type x (or pick it from the drop-down) and the day turns green. Weekends are lightly shaded and days that are not in the month are greyed out
- For each habit, every month: days done, month % (days done out of the days so far), your target for the month, target met (Yes, No or Not yet) and your best streak
- Dashboard: habits tracked, days done this year, overall completion, your best habit and your longest streak of the year (streaks carry over from one month to the next)
- A habit by month completion table, coloured from red to green, plus the year so far for each habit
- A chart of completion by month for all habits together
- Goals tab: log progress with a date, the goal and the amount. The dashboard shows each goal's current value, % done, the share of time used up to the deadline and a status: On track, Behind, Done or Missed
- The tabs are protected without a password, so formulas don't get typed over by accident (you can unprotect them any time)

WHAT YOU GET
- Habit-Tracker-2027.xlsx (blank)
- Habit-Tracker-2027-with-Sample-Data.xlsx (a filled-in example: 8 habits logged from January to March and 3 goals)
- Quick-start guide (PDF)

HOW YOU GET IT
Digital download. Your files are available right after purchase from your Etsy Purchases page. Nothing is shipped.

COMPATIBILITY
- Microsoft Excel 2016 or newer (Windows or Mac) and Excel for the web
- LibreOffice Calc
- Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
- Not tested in Apple Numbers, so we can't promise it works there
- Needs a computer or tablet with a spreadsheet app. This is not an app or a printable planner, and it does not send reminders

GOOD FOR
Anyone setting habits and goals for 2027 who wants to see, month by month, what they actually kept up and which goals are on track.

PLEASE NOTE
A planning and tracking tool. It does not give health, fitness or financial advice. For your own personal use; please don't resell or share the files.

DISCLAIMER
This template is a planning tool and does not replace advice from a qualified or licensed professional. Check the results before you rely on them. Sold as is: because this is an instant digital download, all sales are final, with no returns, exchanges or refunds. If a file is damaged or won't open, message us and we'll send you a working copy.

HOW IT WAS MADE
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.

QUESTIONS
Message us through Etsy and we'll help you get set up.