How to Make a Habit Tracker (DIY Paper, Sheets & Notion)

I've made habit trackers in just about every tool there is — ruled paper, graph paper, three different spreadsheets, Notion, and eventually an actual app (that part got out of hand). Here's the thing I wish someone had told me before all of that: a habit tracker is just a grid. Habits down the side, days across the top, a box you fill in. The tool barely matters. What matters is whether you'll still be filling it in next week.

So below are the exact steps for paper, spreadsheets, and Notion — pick whichever has the least friction for you, and don't spend your motivation on the building.

Make a habit tracker by hand (paper)

1. Turn a page sideways (landscape) for more day columns.
2. List habits down the left — one per row, two or three to start (not the ten I always tried).
3. Number the days across the top — 1 to 28/30/31.
4. Draw the grid with a ruler so each habit/day has a box.
5. Add a key — filled = done, half = partial, blank = missed.
6. Add a totals column on the right to count completions.

Don't want to draw it? Print a ready-made grid: the free printable habit tracker PDFs or a bullet journal layout.

Make a habit tracker in a spreadsheet

1. Column A: your habits, one per row.
2. Row 1: the days, numbered across.
3. Mark each completed day with 1 or x.
4. Total each habit with =COUNTIF(B2:AF2,"x") or =SUM(B2:AF2).
5. Add a percentage by dividing the total by the number of days.
6. Use Conditional Formatting to colour completed cells.

Full walkthroughs: Google Sheets habit tracker and Excel habit tracker.

Make a habit tracker in Notion

1. Add a database (/table).
2. Make the title column a Date property — one row per day.
3. Add a Checkbox property for each habit.
4. Add a Formula to total your checkboxes for a daily score.
5. Filter a view to Date is Today.

Step-by-step: Notion habit tracker guide.

Design tips for a tracker you'll keep

Learned the hard way:

• Start small — 3 habits beat 15.
• Keep marking simple — a tick you'll actually make beats an elaborate system you won't.
• Leave room for a "partial" mark so a smaller effort still counts.
• Make it visible — fridge, desk, or home screen. The sight of it is the reminder.

For more layouts, see habit tracker ideas, and to fill it sensibly, habits to track.

The one feature you can't draw

Here's the honest limit of every homemade tracker — and I say this as someone who loves a hand-drawn grid. It can record what you did, but it can't adapt. Every box is the same size whether you're rested or wrecked, and a missed day just leaves a blank. That blank is the exact moment most people stop. It was always my moment.

SelfSpark adds the part you can't draw with a ruler: it's an adaptive habit tracker that suggests a smaller version of a habit on low-energy days and keeps progress visible after a miss, so one bad week doesn't quietly erase a month of effort. Take the habit fit quiz to try it alongside your DIY tracker — they get along fine.

FAQ

How do I make a simple habit tracker?

Draw a grid with habits as rows and days as columns, decide on a marking key, and tick a box each time you complete a habit. A page, a ruler, and a pen are enough.

What's the easiest way to make a digital habit tracker?

Copy a ready-made Google Sheets template — it already has the grid and formulas. Building from scratch in Sheets, Excel, or Notion takes only a few minutes.

What formula totals habits in a spreadsheet?

Use =COUNTIF(range,"x") to count cells marked with an x, or =SUM(range) if you record completions as 1s, then divide by the number of days for a completion rate.

How many habits should my homemade tracker have?

Start with three or fewer. A focused tracker is much easier to keep up than a crowded one, and you can add habits as the first ones become automatic.

Bottom line

Making a habit tracker is just a grid — habits down the side, days across the top — on paper, in a spreadsheet, or in Notion. Don't overbuild it. And for the one thing you can't draw, an adaptive recovery step, try SelfSpark.