Free Google Sheets Habit Tracker Template (1-Click Copy)

A Google Sheets habit tracker is a spreadsheet where each row is a habit and each column is a day, with formulas that count your completions, streaks, and percentage done automatically. It is free, syncs across your phone and laptop, and you can customise every column. Copy the template below and start tracking in under a minute.

Get the template (1-click copy)

→ Copy the Google Sheets habit tracker template

Clicking the link opens Google's "Make a copy" screen. Confirm, and a private copy lands in your own Google Drive — edit it freely, the original is never changed. You need a free Google account.

Prefer paper? Grab the free printable habit tracker PDFs instead. Want it in Excel? See the section below.

How to use the Google Sheets habit tracker

1. Make your copy using the link above.
2. Type your habits into the first column, one per row.
3. Mark each day with a 1 or an x when you complete the habit.
4. Watch the totals update. The template counts completions and progress automatically.
5. Duplicate the tab each month to keep a clean history.

Because it lives in Google Drive, your tracker is available on the Google Sheets mobile app, so you can tick habits from your phone and review them on a laptop.

Why use a spreadsheet to track habits?

• It's free and you already have it if you use Gmail.
• It's fully customisable — add columns for notes, mood, time of day, or a weekly goal.
• It does the maths for you — streaks and completion rates without manual counting.
• It syncs everywhere and backs up automatically.

A spreadsheet is a great middle ground between paper and a dedicated app. For ideas on what to put in it, see habits to track and habit tracker ideas.

Can I use this habit tracker in Excel?

Yes. Open your copied Google Sheet, then choose File → Download → Microsoft Excel (.xlsx). The formulas convert automatically, so you get a working Excel habit tracker you can use offline.

Spreadsheet vs. an adaptive app

A spreadsheet records what happened, but it cannot help you recover. Every day looks the same, and a missed day is just an empty cell — which is exactly when most people abandon the sheet.

SelfSpark is an adaptive habit tracker that suggests a smaller version of a habit when your energy is low, keeps progress visible after a miss, and uses short journal notes to explain why a habit slipped. If you have abandoned more than one spreadsheet, take the habit fit quiz to see whether an adaptive system fits you better.

FAQ

Is the Google Sheets habit tracker free?

Yes. The template is free to copy and use. You only need a free Google account to save your own copy.

How do I copy the template to my own Google account?

Click the copy link above and confirm "Make a copy". Google places a private, editable copy in your Drive without touching the original.

Can I track multiple habits in one sheet?

Yes. Add one row per habit. The template's totals adjust to however many habits you list.

Does the Google Sheets tracker work on mobile?

Yes. Install the free Google Sheets app and your tracker syncs automatically, so you can check off habits from your phone.

How do I convert the Google Sheet to Excel?

Open the sheet and select File → Download → Microsoft Excel (.xlsx). The download keeps your habits and the counting formulas.

Bottom line

A Google Sheets habit tracker is free, flexible, and syncs everywhere — copy the template and start today. When you want a tracker that adapts to real life instead of leaving blank cells, try SelfSpark.