Habit tracker template for Excel, Google Sheets and Notion

Type your habits and download a ready-made spreadsheet. It opens in Excel, Google Sheets, Numbers and LibreOffice. Type an x in a cell on each day you do the habit, and the Done and % columns update themselves.

Prefer your phone? Tend is a free, private habit tracker for iPhone with streaks, reminders and Home Screen widgets. Get it on the App Store.

Make your spreadsheet

Habit tracker

Habit12345678910111213141516171819202122232425262728293031
Drink 2 litres of water
Workout
Read 10 pages
Meditate
In bed by 11 pm

Fill a square each day you complete the habit. Made with Tend · ponythat.com/tend

Open it in Google Sheets

In Google Sheets choose File → Import → Upload and select the downloaded file. Pick 'Replace spreadsheet'. The formulas work straight away.

Open it in Excel

Double-click the file, or in Excel choose File → Open. To keep your progress, save it as an .xlsx workbook. Add conditional formatting (Home → Conditional Formatting → 'Text that contains' x) to fill the ticked cells with colour.

Use it in Notion

In Notion, choose Import → CSV and select the file. Notion makes a database with one row per habit. For a daily check-off in Notion, many people instead make a database with one row per day and a checkbox property for each habit.

Questions

Does Google Sheets have a habit tracker template?

Not a built-in one, but you can import the free template on this page in a few seconds. It counts completions and percentages for you.

How do I make a habit tracker in Excel?

Put habits in column A and days across row 1, type x for each completed day, and use =COUNTIF(B2:AF2,"x") to count. The download on this page does it for you.

More from Tend