Tracking Habits with Google Sheets
There’s a popular productivity tip I’ve seen attributed to Jerry Seinfeld.
- Grab a calendar.
- Each day you keep up a habit (eg. writing your book or practicing French), cross out that day with a big X.
Most importantly, don’t break the chain. It’s immensely satisfying to see a string of X’s that represent your persistence.
To make your own, create a copy of this template. (“Make a copy” is inside the“File” menu).
You can also download this as an Excel file if you prefer to use another spreadsheet tool or don’t have a Google account.
That’s it! Customize it with your own goals and habits and bonne chance!
Some quick tips
- Boxes will automatically turn green if you mark it with an x. This is thanks to some simple conditional formatting. The same feature is responsible for magically highlighting the current date. Neat! Those settings are in: Format > Conditional formatting…
- You could use the Habit Tracker as a mini-journal. If you’re making good progress on some habits, or need to explain why you haven’t been keeping up, add a comment.
- Once you’ve used Habit Tracker for a couple weeks, you’ll run into the problem of having to scroll horizontally to get to the current date. No worries! Just collapse a few columns and keep them out of sight.
- It’s even better if you use the habit tracker in conjunction with a reminders app. I personally use Inbox by Gmail, though iOS Reminders and Due App are great options I’ve tried in the past.
Enjoy! Keep the streak alive. :o)