Build habits that stick in 2027.
Tick off up to 10 habits every day and watch the grid turn green. Streaks carry on from month to month, and a dashboard shows how your year is going. No macros.
✓ One-off payment ✓ Instant download ✓ Excel for Windows & Mac
| Habit | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | % |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Drink water | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | 97% |
| Walk 10k steps | ✗ | ✓ | ✗ | ✓ | ✓ | ✓ | ✗ | ✓ | ✗ | ✗ | 74% |
| Read 20 mins | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✗ | ✓ | ✓ | 77% |
| Stretch | ✗ | ✗ | ✗ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | 65% |
| Journal | ✗ | ✓ | ✗ | ✗ | ✓ | ✓ | ✓ | ✓ | ✗ | ✓ | 39% |
| Bed by 11pm | ✗ | ✓ | ✓ | ✓ | ✓ | ✓ | ✗ | ✓ | ✓ | ✓ | 81% |
Most New Year’s goals are gone by February
Losing momentum
Without seeing your progress, it’s easy to skip a day, then a week.
Streaks that reset
Most trackers start again every month, so your 40-day streak disappears on the 1st.
Paper gets lost
Printed trackers end up in a drawer by March.
Tick the box. Watch the streak grow.
Choose your habits
Up to 10 habits, each with a target like 80% of days.
Tick them off
Pick ✓ each day you do a habit. The grid fills with green.
Watch your streaks
Current and best streaks for every habit, carried on from month to month.
Streaks that don’t reset on the 1st
Every habit gets a current streak and a best streak. They carry on across months, so a streak from January keeps going into February. Today doesn’t break your streak until the day’s over.
- Streak now and best streak
- Carries across all 12 months
- Data bars to see them at a glance
| Habit | This month | Best streak | Streak now |
|---|---|---|---|
| Drink water | 97% | 30 days | 1 day |
| No sugary snacks | 87% | 22 days | 3 days |
| Bed by 11pm | 81% | 15 days | 15 days |
| Journal | 39% | 4 days | 1 day |
Set a target for each habit
Not every habit needs to be every day. Give each one a target, like 70% of days, and it turns green when you hit it, amber when you’re close, and red when you’re behind.
- Target per habit
- Monthly % for every habit
- Day score for each day
| Habit | Target | Days done | Year so far |
|---|---|---|---|
| Drink 8 glasses of water | 90% | 40 | 93% |
| Walk 10,000 steps | 80% | 33 | 77% |
| Read for 20 minutes | 80% | 35 | 81% |
| Journal | 60% | 19 | 44% |
Your whole year in squares
Every day of the year as one square, darker the more habits you did. See your good weeks, your slumps and your comebacks at a glance, for all your habits or just one.
- Year heatmap that fills itself in
- Pick one habit to see just that one
- Perfect days and your average day
For anyone with goals for 2027
Health & fitness
Water, steps, workouts, sleep and stretching, all in one grid.
Personal growth
Reading, journaling, learning a language or practising an instrument.
Breaking bad habits
No sugar, no phone after 10pm, no takeaways: track the days you manage it.
Everything you get
- 12 monthly grids for 2027
- Up to 10 habits with your own targets
- ✓ and ✗ drop-downs with colours
- Monthly % and day scores
- Streak now and best streak for every habit
- Streaks that carry across months
- Year heatmap: every day as a colored square
- Dashboard: year so far, ticks, streaks and a monthly chart
- Works for any year: change it on the Settings tab
- Start Here guide and example month
One-off payment. Yours to keep.
Get instant access $7.99Secure checkout by Payhip · Card or PayPal
Download link emailed straight away
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.
This tracker uses the COUNTIF and conditional formatting tricks from my tutorials, plus a streak counter that carries on across months.
Questions
Can I use it for another year?
Yes. Change the year on the Settings tab and all the dates update.
Do I have to mark missed days?
No. An empty day just doesn’t count. ✗ is there if you like to see misses.
How do streaks work across months?
Each month picks up where the last one left off, so a streak from 20 January carries on into February.
Can I change my habits partway through?
Yes, but the ticks stay in the same rows, so it’s best to add new habits in empty rows.
Does it use macros?
No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.
Is this a subscription?
No. You pay once and the file is yours to keep.
Make 2027 the year it sticks.
A tick grid, targets and streaks that carry on all year.
Get the tracker $7.99Not ready yet? Try the free Monthly Habit Tracker.