Skip to main content
BeHabitual

Habit tracker Excel and Google Sheets template

Type your habits, pick a month and download a spreadsheet template with the formulas already in it. It opens in Excel and Google Sheets.

Runs in your browser. Nothing is sent or saved.By Nabeel MustafaUpdated

Each file holds one month. Download one per month, or copy the tab.

Two blank rows with the same formulas are added for later habits.

Pick a month to build the template.

Paper is quick to tick and slow to add up. When you want the totals worked out for you, that is a free habit tracker that shows today, the month and the year.

Track it free

What is in the habit tracker template

The file is one month of habits: your habits down the side, one column for each day with its weekday, and three things counted for you. You type any mark in a day's cell, such as x or 1, and the formulas do the rest:

  • Done: how many days of the month carry a mark, using COUNTA.
  • Rate %: done days as a percentage of the days in that month.
  • Habits done: a row at the bottom that counts how many habits you did each day, so a bad Tuesday shows up.
  • Two spare rows with the same formulas, for habits you add mid-month.

Open it in Excel

Double-click the downloaded file and Excel opens it with the formulas working. To keep it as a normal workbook with your formatting, use File, Save As and choose Excel Workbook (.xlsx). Then add colours or conditional formatting as you like; the formulas do not depend on them.

If everything lands in column A, your Excel expects semicolons rather than commas. Open a blank workbook, go to Data, From Text/CSV, pick the file and choose comma as the delimiter.

Open it in Google Sheets

In Google Sheets, open a blank spreadsheet, then File, Import, Upload, and pick the file. Leave "Convert text to numbers, dates, and formulas" switched on, which is the default, and the Done and Rate columns will calculate. You can also upload the file to Google Drive and open it with Google Sheets.

A spreadsheet or an app?

A spreadsheet is a fine habit tracker if you like building your own tools: it is free, it is yours, and it does exactly what you tell it. The costs show up later. It is awkward to tick on a phone, it does not know that a rest day is not a miss, and a streak formula that survives habits on some days of the week only is hard to write.

That is the gap BeHabitual fills: a tick on your phone, counts and timers as well as yes or no, rest days, and the month grid drawn for you. It is free, and it exports everything as a CSV that opens in the same spreadsheet. The habit tracker vs spreadsheet page compares the two in detail.

Make it your own

A few changes people often make once the file is open:

  • Colour a cell green when it has a mark: Conditional formatting, then "Cell is not empty".
  • Count only one mark: replace COUNTA with COUNTIF, such as =COUNTIF(B2:AF2,"x"), if you use x for done and something else for a rest day.
  • Add a tab per month: download a file for each month and copy each sheet into one workbook.

Make a habit tracker in Excel or Google Sheets

  1. List your habits

    Type one habit per line. Up to 30 fit in the file, plus two spare rows.

  2. Pick the month

    The template gets one column for each day of that month, with weekday letters.

  3. Download the template

    It saves as a CSV file with the formulas already in it.

  4. Open it

    Double-click in Excel, or use File, Import in Google Sheets, then save it in that program's own format.

  5. Mark each day

    Type x in a day's cell when you do the habit. Done and Rate % update on their own.

Questions people ask

Is the habit tracker template free?

Yes. It is built in your browser and downloaded straight to your device. There is no sign-up, no email and nothing is sent anywhere.

Why is it a CSV file and not .xlsx?

A CSV opens in Excel, Google Sheets, Numbers and LibreOffice alike, and all of them turn the formulas into working ones when the file opens. Save it as .xlsx or as a Google Sheet afterwards to keep your formatting.

Do the formulas work in Google Sheets?

Yes, as long as "Convert text to numbers, dates, and formulas" is on when you import, which is the default. The template only uses COUNTA, ROUND and SUM, which work the same in Excel and Google Sheets.

What do I type in a day's cell?

Anything. COUNTA counts any cell that is not empty, so x, 1 or a tick all count as done. Leave missed days empty.

Can I track a whole year?

The file holds one month. Download one file per month and copy the sheets into one workbook, or use the 2027 habit tracker printable for a year on one page.

Next to this

Read next

Start with three habits and one month.

You will know by the end of it whether this is the tracker that sticks. That is a shorter test than most things you have tried.

Start freeSee the tools