Free template · Excel · Sheets · Numbers

Free habit tracker template for Excel, Google Sheets & Apple Numbers.

Grab a free habit tracker template for Excel, Google Sheets, or Apple Numbers: dates down the rows, habits across the columns, with green for done, red for missed, and gray for a skip. It tracks yes/no habits in grouped sections, plus numbers (weight, calories, sleep) and times of day (wake-up, bedtime) on a separate sheet. It is the actual spreadsheet I tracked in for months before turning it into the Habit Pocket app.

Download for Excel (.xlsx)Copy in Google Sheets Download for Numbers

Free. No email. v3 — updated August 2026.

Preview of the habit tracker template's Habits sheet: dates down the rows, habits across the columns in three sections, with green done, red missed, and gray skip cells.
	Essentials			Learning		Moving Forward
Date	Wake-up at 7:00	Morning walk	10k steps	Anki	Read a book	Focused work	No distractions
Mon, Aug 3	done	done	done	done	missed	done	done
Tue, Aug 4	done	missed	done	done	done	done	missed
Wed, Aug 5	done	done	missed	done	done	done	done
Thu, Aug 6	missed	done	done	done	done	missed	done
Fri, Aug 7	done	done	done	missed	done	done	done
Sat, Aug 8	skipped	done	done	done	skipped	done	done
Sun, Aug 9	done	done	not filled in yet	done	done	not filled in yet	not filled in yet

About this templateHealth StatsHabits

A week in the template's Habits sheet — real habit names and sections from the file.

Last updated August 2026 · I tracked in this exact file for months before it became Habit Pocket · By Bohdan Stefaniuk

Why this exists

I tracked in this exact spreadsheet for months.

Most habit apps need a phone, and I was trying to use my phone less. So I opened Apple Numbers and built my own: green for done, red for missed, gray for a day I chose to skip. Numbers like calories and weight got their own columns; so did my wake-up and bed times.

It stuck where apps hadn't, for two reasons. It was fast to bulk-edit, open the file and fill the day in seconds, and it was endlessly customizable. It was a canvas. After a few months I realized I just wasn't missing days anymore.

What it couldn't do was add up streaks, draw a chart on my phone, or sync between devices. So I turned the spreadsheet into Habit Pocket. This is the file it started as, free to take.

The habit tracker spreadsheet's health sheet: dates down the rows; weight, calories, sleep score, wake and bed times in columns; done days green, missed days red, skips gray.

The same spreadsheet's habits sheet, with yes/no habits grouped into sections and color-coded green, red, and gray per day.

What's inside

A whole tracking system, not a blank grid.

The same setup you can see in the preview and screenshots, ready to copy and make your own.

Green / red / gray cells

Every yes/no habit is green on a day you did it, red on a day you missed, and gray on a day you chose to skip. The distinction matters: a skip is a decision, a miss is a slip, and the month reads honestly at a glance because the two look different. The coloring is conditional formatting, so typing a mark is all it takes.

Dates down, habits across

One row per day, one column per habit. Filling in a whole day means typing a few characters across one row, which takes seconds — that speed is the trick that makes the habit of tracking itself stick. Dates are pre-filled months ahead; drag the column down for more.

Grouped into sections

Yes/no habits sit under headings like Essentials, Learning, and Moving Forward, so a dozen columns still read cleanly. The groups also make weekly reviews easier: a red cluster inside one section tells you which part of your routine slipped, not just that something did.

Numbers and times too

A second sheet, Health Stats, tracks the things a checkbox can’t: weight, calories, steps, sleep score, and your wake-up and bed times. Type the day’s number next to the date and it accumulates into a record you can chart or scan later.

It’s a canvas

Rename habits, add columns, recolor, regroup, add a notes column if you like. It is a plain spreadsheet, so it bends to whatever you want to track without asking an app’s permission. This is the template’s honest advantage over every habit app, including mine.

Versioned and documented

An "About this template" sheet inside the file records the version (v3, August 2026) and links back to this page, so you can always check whether your copy is current. The changelog at the bottom of this page lists what changed and when.

Sheet	What it tracks	Example
Habits	Yes/no habits in three sections, marked done / missed / skip	Morning walk ✔︎ · Anki ✘ · 10k steps (gray = skipped)
Health Stats	Numbers and times of day, one column each	Weight 139.4 · Steps 8,764 · Wake up 07:15 · Bed 23:40

Formats

Which format should you pick?

All three hold the same template. The right one depends on where you'll actually fill it in.

Pick Google Sheets if you will log from your phone or more than one computer: the copy lives in your Drive, auto-saves, and the Sheets app handles a quick checkmark fine. Pick Excel if you want the fastest fully-offline file, or it will live on a work laptop where Excel is already open all day. Pick Apple Numbers if you are on a Mac — it is the original file, it is the prettiest of the three, and iCloud carries it to your iPhone and iPad for free. The Numbers version has its own page with the Mac/iPhone/iPad setup.

Format	Best when	Saving	Phone entry
Google Sheets	You log from your phone or several machines	Auto-saves to Drive	Good — free Sheets app
Excel (.xlsx)	You want offline speed, or Excel is already your day	Local file, you manage it	Workable with OneDrive + the Excel app
Apple Numbers	You are on a Mac (it’s the original)	iCloud, automatic	Good — Numbers on iPhone/iPad

Day one

How to use it — the first week.

This is the routine that made the file stick for me, not a feature tour.

1
Get your copy.
Download the Excel or Numbers file, or make a Google Sheets copy, with the buttons above. There is nothing to install or sign up for.
2
Make the habits yours.
Rename the column headers to your own habits and delete the ones you won’t track. Start with five to eight — the file holds more, but the first week is about proving to yourself you’ll fill it in, not about coverage.
3
Fill in today.
The template colors cells that contain its ✔︎ and ✘ marks — copy them from a filled cell the first time; after that, autocomplete offers them as you type. For a day you deliberately sit out (rest day, travel), fill the cell gray — a skip is a decision, and it shouldn’t read like a failure.
4
Put numbers on the Health Stats sheet.
Weight, steps, calories, wake-up and bed times — one column each, typed next to the date. Two of these are enough to start seeing patterns against your yes/no habits.
5
Do a ten-minute review each Sunday.
Scan the week for red clusters. A habit that’s red three days running is usually sized wrong — shrink it or drop it, honestly. This ritual, more than the daily marks, is where the template pays for itself.

How to

How to make a habit tracker in Excel, Sheets, or Numbers.

The shape of the spreadsheet, if you would rather build it from scratch.

1
Put dates down column A.
One row per day. Type your first date, then drag the fill handle (or use =A2+1) to fill the month.
2
Put habits across the top.
One column per habit. Group related ones under a merged section header like Essentials or Health.
3
Mark each day done, missed, or skip.
Type a check, an X, or a dash. Keep it to one or two characters so a day takes seconds.
4
Color the cells automatically.
Conditional formatting: done turns the cell green, missed red, skip gray. The exact recipes are below — this is the part that makes the grid feel alive.
5
Add numbers and times.
Give weight, calories, sleep, and wake/bed times their own columns, on their own sheet if it gets busy.

The conditional-formatting recipes

Three rules per app: green for a check, red for an x, gray for a plain typed dash. (In my own file I fill skip cells gray by hand; a dash rule does the same thing automatically.)

Google Sheets

Select the habit columns → Format → Conditional formatting
Rule 1: Format cells if… → Text is exactly → ✔︎ → green fill
Rule 2: Format cells if… → Text is exactly → ✘ → red fill
Rule 3: Format cells if… → Text is exactly → - → gray fill

Excel

Select the habit columns → Home → Conditional Formatting
  → Highlight Cells Rules → Equal To…
Rule 1: ✔︎ → "Green Fill with Dark Green Text"
Rule 2: ✘ → "Light Red Fill with Dark Red Text"
Rule 3: - → Custom Format… → gray Fill

Apple Numbers

Select the habit cells → Format sidebar → Cell
  → Conditional Highlighting → Add a Rule
Rule 1: Text → is → ✔︎ → green fill
Rule 2: Text → is → ✘ → red fill
Rule 3: Text → is → - → gray fill (or fill skips by hand, like I do)

Or skip the setup: grab the spreadsheet with all of this already done.

When the file starts fighting you

Template vs the app — when a spreadsheet stops being fun.

A spreadsheet is a great place to start, and for some people it is the whole answer: free forever, endlessly customizable, yours. The day you want streaks counted for you, a chart on your phone, or your edits synced between laptop and pocket — that is what Habit Pocket is: this template turned into an app.

The template's habits sheet open in Numbers: dates down the rows, habits grouped into Essentials, Learning and Moving Forward across the columns, each day a green check, a red x, or a gray skip. — Drag the handle: the same month of habits, in the template and in the app. Same grid, same sections — the app just counts the streaks, keeps the numbers, and comes with you.

The same grid in Habit Pocket: dates down the rows, habits grouped into Health & Fitness, Mind & Focus and Evening & Lifestyle, done days filled with color that deepens as the streak grows, steps, wake times, weight, mood and screen time kept as values rather than checkmarks, and a streak counted at the foot of every column. — Drag the handle: the same month of habits, in the template and in the app. Same grid, same sections — the app just counts the streaks, keeps the numbers, and comes with you.

	This template	Habit Pocket
Streak counting	Count by eye	Automatic; a skip pauses the streak
Charts	Build your own	One auto chart per habit, custom builder on Pro
Phone entry	Sheets or Numbers app, sideways scrolling	One tap per cell
Sync	iCloud or Google Drive	Real-time across iOS and web, free
Backfilling a messy week	Fast — it is a spreadsheet	Tap through days, or tell your AI assistant (Pro)
Customizing	Endless — it is a canvas	Four habit types, sections, colors
Price	Free forever	Free for 5 habits; Pro $3.99/mo, $29.99/yr, or $49.99 once

Try the app, free Spreadsheet vs the app, in depth

FAQ

Template questions

Yes — completely free, no email, no sign-up. The Excel and Apple Numbers files download directly from this page, and the Google Sheets version is a one-click "make a copy" link. You get the whole file, not a locked preview.

Yes. Use the "Copy in Google Sheets" button and Google puts your own copy in your Drive (you need to be signed in to a Google account — that is where your copy lives). Sheets is the best pick if you want to fill the tracker in from your phone, because edits auto-save.

Yes — the Numbers file is the original. The template started life as an Apple Numbers spreadsheet, so the .numbers download opens natively on Mac, iPhone, and iPad, and syncs between them through iCloud.

Each yes/no habit is green on a day you did it, red on a day you missed, and gray on a day you chose to skip. Numbers and times you just type into their own columns.

Insert a column next to an existing habit inside the same section, type the new habit’s name in the header row, and copy the formatting from the neighbouring column (Paint format in Sheets, Format Painter in Excel) so it colors itself. Rows work the same way: drag the date column down and the next days fill in.

Not yet — the template is built for on-screen use. Any of the three formats can print a month with File then Print, but the columns are sized for a screen, not paper. A proper printable set is on my list; until then, printing straight from Sheets or Excel works in a pinch.

The template is versioned rather than re-released each year — the current file is v3, updated August 2026 (see the changelog on this page and the "About this template" sheet inside the file). Dates are just rows, so any year works: type the first date and drag it down.

Use the Health Stats sheet, the second tab. It has columns for weight, calories, steps, sleep score, and wake-up and bed times — type the day’s number and you are done. Add or rename columns for anything else you measure. This is where a spreadsheet quietly beats most habit apps: it does not force everything to be a checkbox.

Yes, with caveats. The Google Sheets copy works in the Sheets app on any phone, and the Numbers file opens in Numbers on iPhone. Both are fine for typing a checkmark; neither is fun to scroll sideways. If phone-first logging is what you want, that is the exact reason the template became the Habit Pocket app.

Same grid and the same four habit types, but streaks, charts, and correlation overlays are automatic, and it syncs across your phone and the web. The template is great until juggling the file, with no streaks or charts on your phone, gets old.

Changelog

v3 — August 2026: Files now download directly from this page (no more Google Drive folder), with a one-click Google Sheets copy. Added an "About this template" sheet inside the file.
v2 — June 2026: Excel (.xlsx) version added alongside the original Numbers file; template shared publicly for the first time.
v1 — the original: The private Apple Numbers file I tracked in daily — green/red/gray marks, Habits and Health Stats sheets — that later became Habit Pocket.

Keep reading

Five habits. Thirty days.
See what shows up.

No credit card. Pick five habits. Come back in a month.

Get Started for Free