Home › Productivity & Goals › Habit Tracker Spreadsheet for Excel & Google Sheets

The Habit Tracker spreadsheet for Excel and Google Sheets, with flexible weekly targets and streaks. A preview shows the dashboard with habits done today, habits on target this week, month and year completion and charts.

Habit Tracker Spreadsheet for Excel & Google Sheets

Name: Habit Tracker Spreadsheet for Excel & Google Sheets
Brand: Else Court

Not every habit has to happen every day. Going to the gym three times a week, reading five times a week and drinking water daily are all different targets, and the Habit Tracker lets you set a weekly target from 1 to 7 for each one.

You type an x on the days you do a habit. Every week ends with a result row that shows done against target, in green when you met it and red when you did not. The Dashboard adds your streaks, your most consistent habits and a month and year overview.

It is a digital download for Excel and Google Sheets, made for anyone who wants a simple view of their routines.

View on Etsy

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Up to 30 habits, each with a category and a weekly target from 1 to 7
One row per day of the year and one column per habit
A weekly result row: done and target, green when met, red when below
Current streak and best streak, counted in weeks on target
Completion percent by habit and by month
A dashboard with 8 tiles and 4 charts

Who it's for

Anyone building or keeping routines, daily or a few times a week
People who like to see streaks and weekly results
Anyone who prefers a spreadsheet to a habit app

How it works

Choose the year on Start Here.
List your habits and set a weekly target for each.
Type x on the Tracker on the days you do a habit.
Open the Dashboard and the Summary to see weeks on target, streaks and completion.

See inside

Habit dashboard with 8 summary tiles (active habits, done today, on target this week, this month, this year, best streak, weeks on target and data warnings), charts by month, habit, weekday and streak, and two ranked tables.

Tracker tab with one row per day and one column per habit, where you type x on the days you do a habit. Each week ends with a result row showing done and target for every habit.

Habits tab with up to 30 habits, each with a category and a weekly target from 1 to 7, plus days done, weeks on target, current streak, best streak and year completion.

Weekly result rows on the Tracker: green when the week reaches the weekly target, red when the week ended below the target, and no color while the week is still running.

Summary tab with completion percent for every habit and every month, color coded, plus year completion, days done, weeks on target, weeks counted and best streak.

Dashboard section with days done by weekday, the longest current streaks in weeks, a table of the most consistent habits and a table of the habits with the lowest completion.

List of the 5 tabs included in The Habit Tracker and three steps: download, add your habits with a weekly target, then tick your days. Habit tracking helper, no macros, no subscription, digital download.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You get an Excel workbook and a PDF guide with a link to make your own copy in Google Sheets. The two versions are separate files and do not sync.

Can I pause a habit?

Yes. Set a habit to Paused and it is left out of the results.

Do weeks start on Monday?

Yes. Weeks run Monday to Sunday.

Is there an example file?

Yes. A second Excel file is filled with example data for a year of habits, so you can see how everything works before using your own numbers.

More in Productivity & Goals

The Goal Tracker spreadsheet for Excel and Google Sheets, with steps, automatic progress and deadlines. A preview shows the dashboard with active, completed and overdue goals, average progress, charts and the next deadlines.

Goal Tracker Spreadsheet with Automatic ProgressBreak big goals into steps and watch progress update as you go.