2026 Habit Tracker for Google Sheets and Excel: Monthly Grid, Streaks, Year Dashboard
A simple habit tracker that does the math for you. Type up to 10 habits once. Each month you click a day and pick a check or a cross. That's it. The sheet works out your completion %, your best streak and your current streak. A year dashboard shows every month side by side with a chart, so you can see if you're actually getting better. It's built for Google Sheets first, and it also opens fine in Excel and LibreOffice. No macros, no add-ons, no weird scripts. The colors are soft and calm, so it's nice to open every day. You get the .xlsx file and a one page guide that shows how to copy it into Google Sheets in about a minute.
- 12 month tabs plus a Setup tab and a year Dashboard with a monthly chart
- Dropdown check or cross for each day. Works on the Google Sheets phone app too
- Auto completion %, best streak and current streak for every habit
- Set a goal % per habit. The cell turns green when you hit it
- Change the year in one cell and every month re-dates itself