Skip to content

A free one-month habit tracker for Excel and Google Sheets

Type up to 10 habits, pick the month, and tick off each day. Streaks, rates and the month's numbers update as you go.

Excel 2016 or newer and Google Sheets. Free.

Habit Tracker: Free One-Month Spreadsheet for Excel and Google Sheets

What you get

  • A daily grid

    For 10 habits, with weekends and today highlighted.

  • Per habit

    Done count, rate, current streak and best streak.

  • For the month

    Completion, check-ins, perfect days and best streak.

  • Daily score and chart

    A score strip and a chart of the month.

  • Any month

    Pick the month and year at the top, or leave them blank for the current month.

Who it is for

  • Anyone starting one new habit this month
  • People who want to try a spreadsheet tracker before a full year
  • Google Sheets and Excel users who prefer a file to an app

Details

Format
Excel workbook (.xlsx)
Works in
Excel 2016 or newer, Google Sheets
Habits
Up to 10
Months
Any one month you pick
Price
Free, or pay what you want

How it works

  1. 1

    Get it on Gumroad: type 0 as the price at checkout.

  2. 2

    Open the Tracker tab, type your habits and pick the month at the top right.

  3. 3

    Type x or pick the tick on each day you did a habit.

Questions

Is it really free?

Yes. Enter 0 at checkout. If it helps you, you can pay what you like.

How do I start a new month?

Save a copy of the file, clear the ticks and pick the next month.

Which versions of Excel work?

Excel 2016 or newer on Windows and Mac, including Microsoft 365. Google Sheets: in Google Drive choose New, then File upload, pick the file, open it and choose File, then Save as Google Sheets.

What does the full Habit Tracker add?

12 month tabs with streaks that carry across months, 20 habits with weekly goals, notes for every day, a year dashboard, a year in pixels and a dark edition.

Get Habit Tracker

Free One-Month Spreadsheet for Excel and Google Sheets

Need help after you buy? Reply to your receipt email and describe what happened. We will help you get it running.