New Year habit tracker: how to pick a few habits for 2027 and track them in a spreadsheet

Last updated: 26 October 2026 · By Quicksloth

A new year is a good moment to start a habit, and a bad moment to start ten. A tracker helps when it answers three questions without effort: did I do it today, how am I doing against what I planned, and am I getting closer to the goal behind it. Here is how to set one up, with real numbers from a filled-in example tracker covering January to March.

Short version: pick 3 to 5 habits, write each one so that "done" is obvious, and give each a target in days per week rather than "every day" by default. Tick one cell per habit per day. Measure each habit against its own target, watch the current and the longest streak, and tie each habit to a yearly goal with dated milestones.

Pick 3 to 5 habits, and write them so "done" is obvious

Every habit on your list costs a moment every day, even on the days you skip it. A short list is easier to keep up when January turns into February, and you can always add a habit later. Our example tracks 8 habits, to show every part of the file in use; when you start out, fewer is easier.

Write each habit as something you either did or didn't do today. "Read more" can't be ticked; "Read 20 pages" can.

Those are five of the eight habits in the example. A habit you start later in the year gets its own start date, so the weeks before it don't count against it: in the example, "Plan tomorrow" was added on 1 February.

Give each habit a target in days per week

Not every habit is a daily one. A Spanish lesson on weekdays is 5 days a week; calling a friend might be 3. If every habit is measured against "every day", a habit you planned for 3 days a week looks like a failure at 43%, even when you did exactly what you meant to.

One grid for the whole year

Some habit trackers have one tab per month, so you copy the tab and rewrite your habits twelve times. A simpler layout is one row per day for the whole year (365 rows, 366 in a leap year) and one column per habit. You tick a cell with ✓, and every view (this week, this month, the year) is calculated from that one grid.

• Count only the ✓. A formula like COUNTIF(range, "✓") counts ticks and nothing else, so an "x" or a stray space doesn't count as done. A drop-down with ✓ as the only choice (Data validation in Excel and Google Sheets) keeps the grid clean.
• Count up to your last tick, not up to today. If you open the file after a week away, the days you haven't filled in yet shouldn't drag your numbers down. In the example, the last day with a ✓ is 31 March, so every number below counts 90 days: 1 January to 31 March 2027.

Success rate: done against your own target

For each habit: Success = days done ÷ days your target asks for, where the days your target asks for are the days counted × target ÷ 7, rounded to a whole day, and success is capped at 100%. Here are four habits from the example:

The Spanish lesson was done 65 times against a target of 64: that's the target met, so it shows 100%, not 102%. The journal is the one to look at: 74% against every day. Either the habit needs a nudge, or the honest target is 5 days a week. Changing the target is allowed; the tracker is there to tell you the truth, not to grade you.

Across all eight habits, the example averages 91%, and the month-by-month average goes from 88% in January to 90% in February and 93% in March.

Streaks: current and longest

A streak is the number of days in a row with a ✓. Two numbers are worth keeping for each habit:

• Current streak: the days in a row up to your last tick. "Read 20 pages" in the example: 38 days, from 22 February to 31 March.
• Longest streak: the best run so far this year. "Tidy up for 10 minutes" has a current streak of 9 days, but its longest is 15: a reminder that a broken streak is a restart, not a reset of everything you did.

One rule makes streaks fair: today isn't over until it's over. If you haven't ticked a habit yet today, its streak still counts up to yesterday; tomorrow, an empty yesterday breaks it. Without this rule, every streak drops to 0 each morning.

Streaks suit daily habits. For a habit you planned for 3 or 4 days a week, a short current streak means nothing: in the example, "Practice guitar" (4 a week) and "Call or text a friend" (3 a week) both have a current streak of 0 on 31 March and a success rate of 92% and 100%. For those, the success rate and the weekly check say more.

The weekly check

Once a week, look at each habit against its target and see what's left. This is the last full week of the example, 22 to 28 March, with weeks starting on Monday:

Looked at on a Thursday instead of a Sunday, the same table tells you what you can still catch up on before the week ends.

Yearly goals with milestones

A habit is what you do each day; a goal is where it should take you by a date. Give each goal a deadline, a few milestones with their own due dates, and the habit that feeds it. Then the tracker can show, side by side, how far the goal has come and how the habit behind it is going.

The next milestone is the open one with the nearest due date. Spread milestones through the year, so that in March you already know whether a December goal is on its way. The example has 5 goals with 18 milestones; the other three are a Spanish conversation, a $3,000 emergency fund and three songs on the guitar.

Spreadsheet or app?

Both work. They're good at different things.

If you need a nudge on your phone, an app does that and a spreadsheet doesn't. If you'd rather open one file once a day, see the whole year and keep your data to yourself, a spreadsheet does the job.

Start your own

Any spreadsheet with one row per day and one column per habit can do what this page describes. Our Habit & Goal Tracker has it ready: up to 20 habits with a days-per-week target and an optional start date, one grid for the year with a ✓ drop-down, Weekly and Monthly views, a Dashboard with success rates and current and longest streaks, and up to 10 goals with 50 milestones. You type the year in one cell, so it works for 2027 and the years after. It works in Excel and Google Sheets, in a light and a dark theme, and is coming soon to our Etsy shop.

Planning your money for 2027 as well? See How to set up a yearly budget spreadsheet for 2027.

The habits, the goals and every number on this page come from the example file of our Habit & Goal Tracker (a made-up person, Jordan). This page is about keeping track of habits, not health or medical advice. We used AI tools to help write this article and the calculations; the names and numbers in the example are made up.