Habit & Energy Tracker 2027 (Google Sheets + Excel)
Track your habits and your energy side by side, and see which habits hold up on hard days.
Pick your 10 habits, then mark each day with a check, or R for a planned rest day. A rest day keeps your streak going, so a day off on purpose doesn't wipe out weeks of work. Rate your energy 1 to 5 each day, and the Dashboard shows how your habits change on high and low energy days.
WHAT'S INSIDE
- Start Here: how to use it, in plain words
- Setup: your 10 habits, why each one matters to you, your energy scale and your target done rate
- Dashboard: days tracked, habits done, done rate, average energy, streak now and best streak for every habit, high vs low energy done rates, monthly charts and a short "what your year says" summary, all automatic
- January to December: one tab per month with a check / R grid, an energy row, done rates, streaks and a notes box (wins, what got in the way, next month)
WHAT YOU GET
- The blank tracker (.xlsx file)
- A filled-in sample year, so you can see how everything works
Instant digital download. Nothing ships.
WORKS IN
- Google Sheets (free): upload the file to Google Drive, open it, then choose File > Save as Google Sheets.
- Microsoft Excel
Easiest to fill in on a computer or tablet.
GOOD TO KNOW
- Change the year on Setup and the month tabs re-date, so you can use it again next year.
- No app, no subscription, no account. Your data stays in your own file.
- For personal use. Please don't resell or share the file.
ABOUT THE MAKER
I'm Kevin, a bookkeeper at Scholarly Smith Bookkeeping. I live with MS, so my energy isn't the same two days in a row, and most habit trackers treat a rest day like a failure. I built this one to count rest days as part of the plan and to show which habits are worth protecting on low days. It was built with help from AI tools and tested against a full sample year.
Questions? Send me a message any time.