Habit Tracker Spreadsheet: Build a Clear Weekly Record

Define small actions, record planned days and review habits without relying on a perfect streak.

Training Dashboard with fictional example data from the September 2026 workbook
Actual September 2026 workbook · fictional UK example data

Updated

From Sort & Keep, the maker of the linked workbook.

Define what counts first

A habit tracker is easier to use when each row describes an observable action. Read is vague; read ten pages gives you a clear completion rule. Choose a small number of actions you actually want to record. Write the rule once so you do not change its meaning depending on how a day went.

Show the planned days

In a DIY weekly grid, put actions down the left and dates across the top. Decide whether each action is planned daily or only on particular days. Use a clear legend such as done, missed and not planned. Keep future days blank. Otherwise a twice-weekly activity can appear to have failed on five days when it was never scheduled.

Keep the daily entry small

Record what happened while you can remember it. Add a brief note only when it helps explain a change: away from home, materials missing or action too large. Avoid building a complex points system before you know whether you enjoy using a basic grid. The record is information for your next decision, not a judgement about the person completing it.

Read a week accurately

Fictional example: someone plans to sort paperwork on Monday, Wednesday and Friday. They complete Monday and Friday and miss Wednesday. That is two completions from three planned opportunities. It is not two from seven. A note says Wednesday’s folder was at work. Next week they can make the folder accessible or choose a more practical day, rather than adding more tracking rules.

Review the action as well as the marks

At the end of the week, ask whether the activity still matters, whether the planned days fit and whether the completion rule was clear. If you change the rule, date the change so comparisons remain meaningful. Keep old weeks instead of resetting missed marks. A simple record cannot promise a habit will form within a particular number of days. Its useful job is to show what you planned, what you did and what might make the next attempt easier.

A workbook to start with

Level Up Life Planner includes a quest board, habit and streak records, a daily log and a weekly review. Its points and progress views are an option if you enjoy a more structured record. See Level Up Life Planner.

The suggested DIY fields above describe the workflow, not a promise that every field is built into the supplied template. Keep an untouched copy, read the included instructions and work in Excel or import the file into Google Sheets.

Next read: Habit Tracker or Gamified Planner: Choose the Record You Will Use.

UK, US and EU editions are included. Open the matching regional folder in your download.

Read more