A Google Sheets habit tracker is a spreadsheet template you use to log daily habits and see your streaks and consistency at a glance. You can build one in about ten minutes using checkboxes, conditional formatting, and a simple formula, and it works on any device with the Google Sheets app.
Why Use Google Sheets Instead of an App
Dedicated habit apps often have subscription fees, limited free tiers, or sync issues. A Google Sheets tracker gives you full control: you decide the habits, the layout, and the data you keep. You can also export your history, share it with an accountability partner, or combine it with other planning sheets you already use. Because it lives in the cloud, there is nothing to install, and it updates automatically across your phone and computer.
How a Basic Habit Tracker Works
The core structure is simple: rows are habits, columns are dates, and each cell is a checkbox. You mark a habit done for the day by ticking the box. A formula counts the ticks per row to show your monthly total, and conditional formatting highlights a cell green when the box is checked, so you can spot gaps in your routine immediately.
Here is a typical layout:
- Column A: habit name
- Column B: goal (e.g., daily, 3x/week)
- Columns C through AG: days 1–31 of the month
- Column AH: total times completed this month
- Column AI: current streak (optional)
Step-by-Step Setup (No Formulas Required)
- Open a new Google Sheet and title it “Habit Tracker.”
- In row 1, enter the days of the month (1, 2, 3…31) across columns C to AG.
- In column A, list your habits (e.g., Drink water, Read 10 pages, Exercise).
- Select the range of cells where you want checkboxes (e.g., C2:AG10).
- Click Insert → Checkbox. Each cell now shows a clickable box.
- For the total column, use =COUNTIF(C2:AG2, TRUE) in the first habit row, then drag the formula down.
- Apply conditional formatting: select the checkbox range, go to Format → Conditional formatting, and set “Cell is not empty” to green fill. Or use a custom formula like =C2=TRUE to color the cell.
That is enough for a functional tracker. If you want a streak count, add this formula in the streak column: =IF(COUNTIF(C2:AG2,TRUE)=0,0,COUNTA(C2:AG2)-MATCH(TRUE,INDEX(C2:AG2=TRUE,0),0)+1) — but it only works if you never leave a gap after starting.
How to Choose the Right Template for You
Not all habit trackers are the same. Think about what you actually need before copying a template.
- Daily habits (drink water, meditate) work with a simple checkbox grid.
- Weekly habits (grocery shopping, laundry) need a column for week numbers instead of days.
- Quantifiable habits (read 20 pages, run 3 km) require a column for the amount, not just a check.
- Multiple people or family tracking needs separate sheets or tabs for each person.
If you want to track mood, sleep, or symptoms, add a notes column or a separate sheet with a dropdown for values like “good,” “okay,” “poor.” Avoid cramming too many data types into one grid.
Common Problems and Fixes
The most frequent issue is a formula that stops working after you copy a row. Always check that the range in COUNTIF matches the row you are in. Another problem is accidentally deleting checkboxes when you clear a month; instead of deleting cells, right-click and choose “Clear contents” or use Edit → Delete values.
If your conditional formatting does not apply to new rows, extend the range in the conditional formatting rule. If you want to see weekly progress, add a SUM row under each week or use a pivot table. For long-term tracking, create a new tab for each month and keep a summary tab with yearly totals using =SUM across tabs.
Comparing Sheets to Other Free Options
Google Sheets is not the only free tracker. Notion offers databases with more visual views but has a steeper learning curve. A paper bullet journal is zero-tech but has no automatic totals. Excel works offline but lacks the real-time collaboration of Sheets. For most people, Sheets is the best balance of simplicity, flexibility, and zero cost. It also integrates with Google Forms if you want to log habits from your phone quickly.
Costs and Privacy
Google Sheets is free with a Google account. There is no paid tier for personal use. Your data is stored in Google Drive, which is encrypted in transit and at rest. If you share the sheet, anyone with the link can view or edit depending on the permission you set. Be careful not to share sensitive health or habit data broadly; use “Anyone with the link – Viewer” if you need to share a read-only version.
Template
| Habit | Goal | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Total |
|---|---|---|---|---|---|---|---|
| Drink water | 8 glasses | =COUNTIF(C2:G2,TRUE) | |||||
| Read | 10 pages | =COUNTIF(C3:G3,TRUE) | |||||
| Exercise | 30 min | =COUNTIF(C4:G4,TRUE) |
Sample (fictional): For the week of March 3, 2025, “Drink water” is checked on Days 1, 2, 4, and 5, so the total shows 4. “Read” is checked on Days 1, 2, 3, and 5, total 4. “Exercise” is checked on Days 1, 3, and 5, total 3.
Frequently Asked Questions
Can I use a habit tracker on my phone?
Yes. The Google Sheets app is free on Android and iOS. You can open the same file and check boxes on the go. The app works offline if you enable offline access in settings, and changes sync when you reconnect.
How do I reset the tracker for a new month?
Copy the entire sheet to a new tab, then select the checkbox range and press Delete on your keyboard (or use Edit → Clear → Clear values). Do not delete the cells themselves, or you will lose the formatting. Adjust the day headers if the month has fewer than 31 days.
Can I track multiple habits at once?
Absolutely. Each row is a habit, so you can have as many rows as you need. Just make sure your formulas and conditional formatting cover all rows. For readability, group related habits with a blank row or a colored header.
What if I miss a day?
Leave the checkbox blank. Your total formula will simply not count that day. If you want to track streaks, a blank day will break the streak, which is often the motivation you need. Some people prefer to mark a missed day with a different color using conditional formatting, but that requires extra setup.
Is there a way to see my progress over a year?
Yes. Create a summary tab and use formulas like =SUM(‘January’!AH2, ‘February’!AH2, …) to add up monthly totals. Or use =COUNTIF across all month tabs, but that is more complex. A simpler method is to copy each month’s total into a single column and make a line chart from that data.
Can I share my tracker with a friend for accountability?
Yes. Click the Share button in the top right, enter their email, and choose “Editor” so they can check boxes too. This is a great way to keep each other honest. Just remember that they can also edit or delete your data, so only share with someone you trust.