Free Excel Habit Tracker Template (Spreadsheet Download)

An Excel habit tracker is a spreadsheet where each row is a habit and each column is a day, with formulas that total your completions and show streaks and percentages automatically. It works offline, is fully customisable, and you probably already have Excel. Here's how to get one free and how to build your own in two minutes.

Get the Excel habit tracker

The fastest way to a working .xlsx is to copy our ready-made spreadsheet and export it:

1. Open the Google Sheets habit tracker template and click "Make a copy".
2. In your copy, choose File → Download → Microsoft Excel (.xlsx).
3. Open the downloaded file in Excel — your habits and the counting formulas come with it.

This gives you a tested Excel habit tracker spreadsheet without writing a single formula. Prefer paper? Use the free printable habit tracker PDFs instead.

Build your own Excel habit tracker in 2 minutes

If you'd rather start from a blank workbook:

1. Column A: type your habits, one per row (rows 2 onward).
2. Row 1, columns B onward: type the days 1, 2, 3 … across the top.
3. Mark completions with a 1 (or x) in the day cell when you do the habit.
4. Add a total column. In the cell after your last day, use =COUNTIF(B2:AF2,"x") (or =SUM(B2:AF2) if you use 1s) to count completions per habit.
5. Add a percentage. Use =COUNTIF(B2:AF2,"x")/31 and format as a percent.
6. Highlight done days with Conditional Formatting so completed cells fill with colour.

Tip: turn on Freeze Panes (View → Freeze Panes) so your habit names stay visible as you scroll across the month.

Why track habits in Excel?

• Works offline — no account or internet needed.
• Fully customisable — add columns for notes, mood, target, or time of day.
• Automatic maths — COUNTIF and SUM handle streaks and rates.
• You already own it — no new app to learn.

For what to put in your spreadsheet, see habits to track and habit tracker ideas.

The limit of any spreadsheet

Excel records what happened, but it can't help you recover. Every day's cell is identical, there's no nudge to do a smaller version when you're exhausted, and an empty stretch of cells is usually where the spreadsheet gets abandoned.

SelfSpark is an adaptive habit tracker that suggests a smaller next step on low-energy days, keeps progress visible after a miss, and uses short notes to explain why a habit slipped. If you've let more than one spreadsheet go stale, take the habit fit quiz to see if an adaptive system suits you better.

FAQ

Is there a free Excel habit tracker template?

Yes. Copy our Google Sheets template and use File → Download → Microsoft Excel (.xlsx) to get a free, working .xlsx with the formulas included.

How do I create a habit tracker in Excel?

Put habits in column A, days across row 1, mark each completed day with an x or 1, then use =COUNTIF() or =SUM() to total completions and Conditional Formatting to highlight done days.

What formula counts habit completions in Excel?

Use =COUNTIF(B2:AF2,"x") to count cells marked with an x, or =SUM(B2:AF2) if you record completions as 1s. Divide by the number of days for a completion percentage.

Can I use the habit tracker on Excel mobile?

Yes. Save the .xlsx to OneDrive and open it in the Excel mobile app to tick habits on the go, the same way you would on desktop.

Bottom line

An Excel habit tracker is free, offline, and endlessly customisable — copy the template and export to .xlsx, or build one with two formulas. When you want a tracker that adapts to real life instead of leaving blank cells, try SelfSpark.