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
| Habit | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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.