The file is made on this device. No email, no sign-up.
Habits and routines, in your pocket
The habits app is in development. Leave your email and we'll tell you when it's out.
What's in the template
In the blank template, column A is for the habit, columns B to AF are days 1 to 31, and column AG is Total. There are 10 rows for habits. Type an x in a day's cell when you do the habit. The filled version uses only this month's days, so in a month shorter than 31 days its Total column comes earlier; it puts an x on every day you ticked in the online tracker.
Open it in Google Sheets
In Google Sheets, open a spreadsheet, choose File, then Import, and pick the CSV file. Select an import option, then click Import.
Open it in Excel
In Excel, choose File, then Open, choose Text Files in the file type list and pick the CSV file: Excel opens it and shows the data in a new workbook. To choose the delimiter yourself, use Data, then From Text/CSV, and pick it under Delimiter.
When you save a workbook in CSV format, Excel may warn that some features might be lost.
Let the sheet count the days
The Total column is empty, so you choose how it counts. In the blank template, to count the marked days in the first habit row, type =COUNTA(B2:AF2) in its Total cell (AG2), then copy the cell down to the other rows. The filled file ends on this month's last day, so use the formula shown under its download button instead.
In Google Sheets, COUNTA returns the number of values in a range. In Excel, it counts the cells in a range that are not empty.
Other ways to track
On paper
The printable habit tracker prints a month, 30 days or a week on one page, blank or filled from the online tracker.
In the browser
The online habit tracker keeps up to 3 habits on this device and counts total days done, which never resets after a missed day. Its “Export CSV” gives the full history, one row per day done.
If you need help now
These tools are for everyday habits. They are not a crisis service. If you are struggling or don't feel safe, you can contact:
988 Suicide & Crisis Lifeline
988 Suicide & Crisis Lifeline (US): call or text 988, or chat online. Free and confidential, 24/7.
Emergency services (911)
US: call 911 if you or someone you know is in immediate harm or danger.
Samaritans
Samaritans (UK and Ireland): call 116 123, free, 24 hours a day, 365 days a year.
Emergency services (999 or A&E) · NHS 111, mental health option
UK: call 999 or go to A&E if someone's life is at risk or you can't keep yourself or someone else safe. For urgent help that isn't an emergency, call 111 and choose the mental health option (NHS).
Elsewhere, call your local emergency number.
Sources
- Import data sets & spreadsheets. Google Docs Editors Help. support.google.com
- Import or export text (.txt or .csv) files. Microsoft Support. support.microsoft.com
- COUNTA. Google Docs Editors Help. support.google.com
- COUNTA function. Microsoft Support. support.microsoft.com
- 988 Suicide & Crisis Lifeline. 988 Suicide & Crisis Lifeline. 988lifeline.org
- Contact Us. 988 Suicide & Crisis Lifeline. 988lifeline.org
- Contact a Samaritan. Samaritans. samaritans.org
- Where to get urgent help for mental health. NHS. nhs.uk