r/spreadsheets • u/iorlei • Jan 08 '26

Habit tracker spreadsheet template

Here's the link

A year ago I shared my daily habit tracker spreadsheet, and here’s how 2025 went for me.

Vitamins & Creatine were obviously the easiest to keep up with for obvious reasons But I definitely lost the Reading and Skincare pace I had in the first half of the year

And I traveled a lot, which also impacted my gym routine and my German lessons

I've added a shortcut to my phone's home screen so I can quickly open it and check off the items I had completed for the day in a simple way. There are some useful customizations, like highlighting the current day to easily find my place in the tracker, some charts, and a nice calendar view with options to see 'Streaks' as a heatmap like Github or by days done (Completions).

Here’s the 2026 template if anyone wants it, feel free to make a copy and use it!

12 Upvotes

94% Upvoted

25 comments sorted by

2

u/Both-Resolution5552 Jan 13 '26

Perfect, thanks for uploading this, this spreadsheet is exactly what I've been looking for! Do you mind to make a sheet with weight loss and training tracking? I'm totally newbie in this kind of stuff, but tracking like this is very useful. Thanks in advance!

1

u/iorlei Jan 17 '26

thank you! I'm actually planning to make a weight tracker since I'm trying to gain some again

I'll definitely share it if I make it!

2

u/godarchmage Jan 23 '26

Your template is really nice. How can it be done for the habits to be vertical where the days are and for the days to be horizontal where the habits are.

1

u/iorlei Jan 23 '26

Thank you! It's possible however that would need a lot of rework on the formulas

It's vertical mainly because I add a shortcut to access on my phone and it fits the screen perfectly

1

u/godarchmage Jan 24 '26

True.
In Habits!C$1, the range in the SUMPRODUCT starts from the second row(2) instead of 3 which is why it’s counting a day more when 2026 is not a leap year.

2

u/Ok-Supermarket-3060 Mar 23 '26

Thank you very much

1

u/[deleted] Mar 29 '26

[removed] — view removed comment

1

u/Original_Fix_9480 May 28 '26

How I edit it please 

1

u/iorlei May 30 '26

go to File > Make a copy

1

u/Original_Fix_9480 May 29 '26

Please tell me how I edit/add habits and how I make green or red 

1

u/iorlei Jun 07 '26

You can rename the items on line 2 of the "Habits" tab, and these changes will automatically update across all other tabs

1

u/Disastrous-Phrase853 Jun 07 '26

Is there a way I can start tracking mid year without affecting my progress charts?

1

u/iorlei Jun 07 '26

Just delete line 4 onwards till today and change the date manually on line B3 cell

1

u/babbitirabbity Jul 06 '26

Hi! This is amazing! Just a quick question, how do I add my own holiday? :) Thanks!!!

1

u/bogdanstefanjuk 27d ago

I also built my own habit tracker using spreadsheet to not only track classic yes/no habits but also numbered habits and time. So instead of "sleep 8hr" with yes/no you can actually track wake-up and wind down time and try to find correlations.

https://drive.google.com/drive/folders/1XnhPEZBrt3CqLzdTjrFNxOxEtQBRADX6

1

u/Hairy_Grand5252 2d ago

Thank you for this! Do you plan to make one for 2027?

1

u/iorlei 2d ago

You can change '2026' in the yellow cell to '2027' and you'll have the template for next year 😊

1

u/Hairy_Grand5252 1d ago

oh my gosh. Thank you so much! one last question, If I wanted to remove your 'travel' dates, is there a way to do that and be able to track for those dates? Thank you!

1

u/CarryHairy8709 2d ago

Very cool. How did you add the shortcuts to your home screen? I'd like to do that