Habit Tracker Google Sheets & Excel Template

Build better routines one checkbox at a time. This habit tracker template gives you a monthly checkbox grid for up to 15 habits, a goal for each habit and a yearly dashboard that shows which habits really stick. Use it as a ready-made habit tracker google sheets in Excel or Google Sheets.

Who this template is for

• Anyone building new routines
• People who like visual progress and heat maps
• Coaches sharing a tracker with clients

Features

• 12 monthly trackers (Jan–Dec) with a checkbox for every habit and every day. Days, weekday letters and weekends adjust to the year you pick.
• Monthly goals: set how many days per month you want to do each habit — daily, a few times a week or weekly.
• Days done, % of goal and a progress bar for every habit, plus a “day complete” heat-map row.
• Yearly dashboard: % of goal for every habit and month in a color-coded table, a yearly average and a progress chart.
• Best habit of the month shown at the top of each tracker.
• Native checkboxes, print-ready monthly pages, no macros.

How to use it

1. Download the file and open it in Excel or upload it to Google Sheets.
2. Type your habits and a monthly goal for each on the Dashboard, and pick the year.
3. Open the month tab and tick each habit when you do it.
4. Check the Dashboard to see your progress across the year.

What’s included

• 1 .xlsx file with a Start Here guide, a Dashboard and 12 monthly tracker tabs.
• Example habits and three months of sample ticks (clear them to start fresh).

Compatibility

Works in Microsoft Excel (desktop, Mac and Excel online) and Google Sheets. No add-ons or macros required.

FAQ

Can I track weekly habits?

Yes. Set the monthly goal to 4 (once a week) or 8 (twice a week) and tick the days you do it.

Can I use it again next year?

Yes. Clear the ticks and pick the new year — every month updates automatically.

How many habits can I track?

Up to 15 habits at once.

Does it work in the free version of Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. A free Google account is all you need.

Can I use it on a Mac, iPad or phone?

Yes. It works in Excel for Mac and Windows, Excel online and the Google Sheets app. For editing, a computer or tablet is the most comfortable.

How do I get the file?

Right after checkout you get a download link on the confirmation page and by email.

More templates like this: Habit & Goal Trackers.

This is a digital product. No physical item will be shipped.