Habit tracker in Excel or on paper: streaks and goals

A habit tracker is a grid: habits down the side, days across the top, and a mark for each day you did it. It looks too simple to need a guide. But how you set it up decides whether you are still using it in March. This guide covers the design choices, what research says about how habits form, and what a tracker cannot do.

Pick a habit you can describe

A habit that you can see is easier to track than one you can only feel. "Be healthier" cannot be ticked. "Read for 10 minutes" can. Write each habit as an action with a small size, and decide in advance what counts as done. A minimum, such as one page, keeps the habit alive on bad days.

Start with a few. A tracker with twenty rows looks impressive and is exhausting. We suggest three to five habits and a clear reason for each. You can add more in a new month.

Tie it to a cue

Gollwitzer and Sheeran (2006) pooled the results of many studies of "implementation intentions", plans of the form "when situation X arises, I will do Y". They found that making such a plan helped people reach their goals. Those studies cover many kinds of goals, so the result is not specific to habit tracking, but the idea fits the case well.

In practice, give each habit a cue: "after I brush my teeth at night, I read for 10 minutes". The cue does the remembering, and the tracker records it. A habit without a cue relies on remembering, and on willpower.

How long does it take?

You may have heard that a habit takes 21 days. The best-known study of everyday habits does not support that. Lally and colleagues (2010) asked 96 volunteers to choose an eating, drinking or activity behaviour and repeat it daily in the same situation for 12 weeks. For the participants whose data the model fitted, the time to reach a plateau of automaticity ranged from 18 to 254 days. The authors point out that it can take a very long time and that people vary a great deal.

Two details are useful. Doing the behaviour more consistently went with a better fit to the model. And missing one opportunity to perform the behaviour did not materially affect the habit-formation process. Keep two cautions in mind. The volunteers chose simple behaviours, so complex ones may take longer. And a study of 96 people tells you about a range, not about you.

Streaks and percent of goal

A streak counts days in a row. It is motivating, and it has a trap: one missed day takes it back to zero, and then the whole effort can feel wasted. Pair it with a second number, the percent of your goal, which does not collapse.

A worked example with invented numbers. You decide to read for 10 minutes on at least 25 days in a 30-day month. You do it on 22 days. Your percent of goal is 22 / 25 = 88 per cent. Your best streak was 9 days in a row, and your last streak, the one running at month end, was 4. The 88 per cent says you mostly kept to the plan, and the best streak says what you can do at your best. A streak of 4 on its own would hide both.

Note that a tracker may count streaks inside each month, because each month is a separate sheet. Check how yours handles a run that crosses the month end, and read the streak as a guide, not as a score.

From habits to goals

Habits are what you do repeatedly. Goals are what you want to have by a date. They connect: a goal such as "finish a 300-page book by 31 March" turns into a habit of reading a set amount each day. The numbers show whether it is realistic. 300 pages in 90 days is about 3.3 pages a day, which is little, and 10 pages a day would finish in 30 days.

A useful goal is specific, measurable, has a date, and has milestones. If you write the goal as "read more", you cannot tell in March whether you succeeded. If you write "finish 3 books by 31 March, one at the end of each month", you can. List the milestones and their due dates, and tick them off as you go.

Mood and energy

Some trackers include a daily mood and energy rating on a 1 to 5 scale, with a monthly average. It can be interesting to see how your rating moves around your habits, for example on days you slept badly. Treat it as a note to yourself, not as a measurement and not as a health tool. Five points on a scale is a rough impression, and a small number of days shows no pattern. If your mood worries you, talk to a professional.

Paper or spreadsheet

Both work. A printed page is quick, always visible on the fridge or desk, and a tick on paper is satisfying. A spreadsheet adds up the days for you, shows the percentage and the streaks, and draws a chart for the year. The costs are opposite: the spreadsheet is on a screen you may not open, and the paper needs adding up by hand. Some people use both: paper for the daily tick and the spreadsheet once a week to enter the days.

A weekly review

Once a week, spend five minutes on three questions. Which habit went best, and why? Which went worst, and what got in the way? Is the cue still right, or should it move? Change one thing, not five. A habit that keeps failing is usually too big or has the wrong cue, and the fix is to make it smaller or to move it.

Starting again after a gap

Sooner or later you will miss a week. The research gives no reason to treat that as the end. Lally and colleagues found that missing a single opportunity did not materially affect habit formation, and the logical step after a longer gap is the same: do the habit today, at the smaller size. Do not try to make up for lost days. Mark the gap on the tracker without judgement, and read the percent of goal at the end of the month, not only the streak.

Tool that fits

The Habit Tracker & Goal Planner (Excel plus printable pages, EUR 9, paid once) tracks up to 20 habits across 12 monthly sheets, with a tick drop-down in each day. For each habit it works out the days done, the goal, the percent of goal, the last streak and the best streak, with streaks counted within each month. A year dashboard shows each habit's completion by month with a chart. A goals sheet has SMART fields, milestones, due dates and progress, and a mood and energy log on a 1 to 5 scale gives monthly averages and a chart. There are printable pages in A4 and US Letter: a monthly tracker, a weekly goal page and a goal worksheet. You get a blank workbook and an example with six months of data. It works in Excel 2016 and later, Google Sheets and LibreOffice, with no macros. It is a personal tracking tool, not medical, financial or professional advice.

Questions people ask

Sources

1. Lally, van Jaarsveld, Potts and Wardle (2010), How are habits formed: modelling habit formation in the real world, European Journal of Social Psychology 40(6), 998-1009
2. Gollwitzer and Sheeran (2006), Implementation intentions and goal achievement: a meta-analysis of effects and processes, Advances in Experimental Social Psychology 38, 69-119
3. HiddenWay worked example: our own arithmetic, assumptions listed in the text

We checked each source on 17 October 2026. If a fact here is out of date, tell us at hello@hiddenway.info.

Keep reading

• 2027 digital planner for GoodNotes: how to choose and use it
• Student study planner: a weekly system and an exam countdown
• Excel Gantt chart with dependencies: how dates follow tasks
• More in Planning