Habit Tracker for Google Sheets and Excel With Daily Goals

Our habit tracker Google Sheets template sits on every weekly page of the Weekly Planner Spreadsheet, and the same tracker comes as an Excel file. You tick yes-or-no habits each day, tick weekly habits once, and type the real number for measurable habits such as glasses of water or pages read. It suits anyone who wants habits tracked on the same page as the week’s schedule, tasks and meals, rather than in a separate app.

What the Habit Tracker Spreadsheet Tracks

The tracker handles three kinds of habits, and choosing the right kind for each habit is most of the setup.

• Daily habits. Yes-or-no habits for every day, such as making the bed or a short walk. You name them once on the setup tab and tick them day by day on each weekly page.
• Weekly habits. Things that only need to happen once a week, such as a long run or a budget check-in. You tick each one once.
• Measurable habits. Habits where the amount matters. On the setup tab you give each one a daily goal (8 glasses of water, 20 pages, 15 minutes of practice), and each day you enter the number you actually reached.

Because the habits share the weekly page with the main task of the day, the hourly schedule, tasks and the meal plan, a missed habit rarely needs explaining: the skipped walk sits next to a day of meetings from 9 to 5. The planner lays out six consecutive weeks from your start date, one tab each, so you can compare weeks side by side.

Example: One Week of Habits, Filled In

Here is a realistic week with four daily habits and three measurable ones. We worked out the Week column to show how to read a finished week; the formulas further down produce the same numbers.

Habit	Goal	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Week
Make the bed	Tick	✓	✓	✓	✓	✓	✗	✓	6 of 7 (86%)
10-minute walk after lunch	Tick	✓	✗	✓	✓	✗	✓	✓	5 of 7 (71%)
Stretch for 5 minutes	Tick	✓	✓	✓	✗	✓	✓	✓	6 of 7 (86%)
No phone after 10 pm	Tick	✓	✓	✗	✓	✓	✗	✗	4 of 7 (57%)
Glasses of water	8	8	6	8	9	7	5	8	51 of 56 (91%), goal met 4 days
Pages read	20	25	20	0	30	10	45	20	150 of 140 (107%), goal met 5 days
Minutes of guitar	15	15	0	20	15	0	30	10	90 of 105 (86%), goal met 4 days

The weekly habits that week were a long run (done), a budget check-in (done) and a call to Grandma (moved to next week).

What the week says:

• The daily habits earned 21 of 28 possible ticks, or 75%. “No phone after 10 pm” is the weak one: it slipped on Wednesday, Saturday and Sunday. Two of those are the weekend, so a weekend rule (phone on the charger by 11) beats more willpower.
• Pages read beat its weekly target at 107%, despite a zero on Wednesday, because Saturday’s 45 pages made up for it. Yet the daily goal was met on only 5 days. Decide in advance which number matters to you: the total, or the daily routine.
• Water came close every day but reached 8 glasses only 4 times. The goal is realistic; the habit needs a cue, such as a full glass with each meal.

How to Set Up the Habit Tracker

1. Open the Excel file in the Excel desktop app, or use the link in your download to make your own copy in Google Sheets.
2. On the setup tab, enter your start date. The planner builds six consecutive weekly tabs from it.
3. List your daily habits on the setup tab. Keep the list short; you can add habits once the first ones stick.
4. Add your measurable habits with a daily goal for each. Pick a unit you can count without effort: glasses, pages, minutes or steps.
5. Open the first week’s tab and fill in the weekly habits you want for that week.
6. Each evening, tick the daily habits you did and type the numbers for measurable habits. Type 0 on a missed day instead of leaving it blank, so an empty cell always means “not filled in yet”.
7. Read the finished week before you plan the next one. When the six weeks are up, set a new start date or start a fresh copy; a fresh copy keeps the finished weeks as a record.

The Method: Few Habits, Clear Goals, a Weekly Read

A tracker only helps if each tick means something. Three rules do most of the work.

Match the habit type to the question. “Did I do it?” is a daily habit. “How much did I do?” is a measurable habit. “Does once a week cover it?” is a weekly habit. A vague habit like “exercise” usually hides two or three trackable ones, such as “10-minute walk after lunch” and “long run on Saturday”.

Set goals from a normal day. If you meet a measurable goal every day for two straight weeks, raise it a little. If you miss it more days than you hit it, lower it until the habit runs again.

Read the week, then plan the next. Look for the pattern, not the score: which day broke the streak, and what else was on it. Our guide on how to track habits covers daily versus weekly habits, measurable targets and streak rules in more depth, and the weekly review guide has questions for that end-of-week read. If you are choosing what to track, habit tracker ideas lists habits by area, and how to break down goals shows how to turn a bigger goal into a daily number.

A habit with a fixed slot in your day is easier to keep. The time blocking template shows how to give it one on the same weekly page.

Build Your Own Habit Tracker in Google Sheets or Excel

A basic stand-alone version needs one row per habit and a handful of formulas.

Minimum columns

• A: Habit
• B: Goal (leave blank for yes-or-no habits)
• C to I: Monday to Sunday
• J: Days done, or days the goal was met
• K: Percentage for the week

Put yes-or-no habits in rows 2 to 6 and measurable habits in rows 8 to 10, so each block has its own formulas.

Checkboxes

• Google Sheets: select C2:I6, then choose Insert > Checkbox. A ticked box holds TRUE and an empty one holds FALSE.
• Excel for Microsoft 365: select C2:I6, then choose Insert > Checkbox. The cells store TRUE and FALSE the same way. In older Excel versions without in-cell checkboxes, type an x in each done cell instead.

Formulas for yes-or-no habits

In J2, days done:

• Google Sheets and Excel for Microsoft 365: =COUNTIF(C2:I2,TRUE)
• Older Excel with x marks: =COUNTIF(C2:I2,"x")

In K2, the week’s completion: =J2/7, formatted as a percentage. It is the same in both apps.

For the whole block, the share of all possible ticks you earned: =COUNTIF(C2:I6,TRUE)/(COUNTA(A2:A6)*7). COUNTA counts only rows with a habit name, so empty rows don’t drag the score down. For the example week, it returns 75%.

Formulas for measurable habits

With the daily goal in B8:

• Days the goal was met, in J8: =COUNTIF(C8:I8,">="&B8)
• Share of the weekly target, in K8: =SUM(C8:I8)/(B8*7)

Both work unchanged in Google Sheets and Excel. For the pages-read row in the example, they return 5 and 107%.

Conditional formatting

Color each day that met its goal:

• Google Sheets: select C8:I10, open Format > Conditional formatting, choose “Custom formula is” and enter =C8>=$B8.
• Excel: select C8:I10 with C8 as the active cell, then open Home > Conditional Formatting > New Rule > “Use a formula to determine which cells to format” and enter the same formula.

The dollar sign keeps every cell pointed at its own row’s goal. Add a second rule, =AND(C8<>"",C8<$B8), in a softer color to mark days that fell short without coloring days you haven’t reached yet.

Who This Daily Habit Tracker Template Suits

It suits you if:

• You plan your week and want habits beside your schedule, tasks and meals instead of in another app.
• You track numbers (water, pages, practice minutes, steps) against a daily goal.
• You prefer a Google Sheets or Excel file you own over an app account.

It suits you less if:

• You want a year of streaks in one view. The planner works in six-week runs, so long-term history means keeping each finished copy.
• You rely on reminders. The file will not nudge you, so tie each habit to something you already do, like the walk straight after lunch.
• You want only a habit tracker. The build-your-own sheet above may be enough.

One last tip: write each habit as the smallest version that still counts, such as “10-minute walk” rather than “exercise”, so a tick means the same thing on a busy Tuesday as on a free Saturday.