Budget and tracker spreadsheets · Ink and Index
Each month has its own tab with habits down the side and days across the top. Type x on the days you did the habit.
$5.99 on Etsy · instant download · sold by Ink and Index
Works in Excel and Google Sheets. A blank copy and an example-filled copy are included.
The Yearly Habit Tracker Spreadsheet is a habit tracker for the whole year. Each month has its own tab with up to 18 habits down the side and the days across the top. Type x on the days you did the habit, and the tab works out the days done, the percentage so far, your current streak and your best streak, and says whether you are on target. A Year tab shows every habit by month as a shaded percentage table with two charts. It comes as a blank and an example-filled workbook with a 4-page guide for Excel and Google Sheets.
- A daily grid for each month, with today's column outlined
- Streaks that carry over between months, and a status of On target, Close or Below target
- A Year tab with every habit by month as a shaded percentage table and two charts
- 18
- habits
- 12
- month tabs
- 2
- year charts
- 14
- sample habits in the example
Why Habit Trackers Stop After a Few Weeks
A tracker that punishes a missed day teaches you to stop opening it. One that rewards a day done keeps the picture honest and the pressure low.
- You miss one day and the streak resets, so you quit.
- The monthly total cannot tell a run across two months from two short runs.
- You tick future days by mistake and the numbers go false.
- The year view is another file you build by hand.
- You cannot see which habit is slipping until it is gone.
Six Parts of the Habit Tracker
Pick a part to see it. You type x on the days you did a habit, and everything else is a formula.
Part 1 of 6 · the month tab
A grid for every month
- Habits down the side and days across the top
- Choose x for each day you did the habit
- Today's column is outlined
Part 2 of 6 · current and best
Streaks that carry over
- A run that starts on 28 January and continues into February counts as one run
- The current streak counts up to yesterday until you tick today
- Best streak for each habit
Part 3 of 6 · the Year tab
Every habit, every month
- Every habit by month as a shaded percentage table
- The year total and the best streak
- A status for each habit
Part 4 of 6 · two charts
See the trend
- All habits by month
- Each habit against its target
- Built from the Year tab
Part 5 of 6 · the Setup tab
List your habits
- Type the year
- List up to 18 habits with a target for each, for example 80% of days
- Done once
Part 6 of 6 · plain words
On target, close or below
- Days done and the month percentage
- On target, Close or Below target
- Two rows under the grid show how many habits you ticked each day
$5.99 on Etsy · instant download · sold by Ink and Index
Read the guide first
1 / 5
How to Track Habits in Five Steps
Setup takes a few minutes. After that each day is a tick.
-
Type the year
On Setup, enter the year you are tracking.
-
List your habits and targets
Add up to 18 habits, each with a target such as 80% of days.
-
Tick each day
Open the month tab and choose x for each day you did the habit. Today's column is outlined.
-
Read the status
See days done, percentage, current and best streak, and whether you are On target, Close or Below target.
-
Check the year
Open the Year tab for every habit by month and the two charts.
What Is Inside the Yearly Habit Tracker
- Setup
- The year, then up to 18 habits with a target for each.
- Twelve month tabs
- A grid of habits by day. For each habit: days done, month percentage, a status, current streak and best streak.
- A Year tab
- Every habit by month as a shaded percentage table, the year total, the best streak and a status, plus two charts.
- Streaks that carry over
- A run that crosses a month boundary counts as one run.
- No pressure
- A missed day lowers that month's percentage and ends a streak, nothing else. Ticks on days that have not happened yet are ignored until the date arrives.
- A blank and an example workbook
- The example has invented ticks for 14 sample habits from 1 January to 18 March 2027.
Habit tracker or planner?
| Compare | Habit Tracker Spreadsheet | Printable Planner |
|---|---|---|
| Format | Excel and Google Sheets | PDF to print |
| Habits | Up to 18 with streaks and percentages | A habit grid on each monthly focus page |
| Maths | Done by formulas | Done by hand |
| Page | You are here | 2027 Printable Planner |
Where to buy, and what each store sells
| Store | Price | Includes | Buy |
|---|---|---|---|
| Etsy | $5.99 | Blank and example-filled .xlsx workbooks and a 4-page guide for Excel and Google Sheets | Buy on Etsy |
Prices checked 23 October 2026. Each store shows its own refund terms at checkout.
Streaks That Carry Over, Pressure That Does Not
A streak is the number of days in a row with an x. The current streak does not drop to zero just because today is not ticked yet. It counts up to yesterday until you tick today. A run that starts on 28 January and continues into February counts as one run.
Missed a day? It lowers that month's percentage and ends a streak, nothing else. Fill in an earlier day whenever you like. There are no notifications or reminders, no phone app, no automatic tracking and no macros. The workbook does not give medical, fitness, nutrition or financial advice.
AI tools were used to help write the wording and the code that builds the workbook, the guide, the pictures and the video. The workbook's results were checked against an independent calculation of the example data. Personal use. Please do not resell, share or upload the files.
What You Download
Three files: a blank workbook, an example-filled workbook and a 4-page read-me guide. One year at a time and 18 habits. It uses ordinary formulas and no macros.
- 3
- files
- 18
- habits
- 0
- macros
Ticks on days that have not happened yet are ignored until the date arrives.
Yearly Habit Tracker Spreadsheet: Frequently Asked Questions
What is the Yearly Habit Tracker Spreadsheet?
A habit tracker for the whole year. Each month has a tab with habits down the side and days across the top. You type x on the days you did the habit, and it works out the days done, the percentage, your current streak and your best streak.
How many habits can I track?
Up to 18, each with its own target, for example 80% of days.
How do streaks work across months?
A streak is the number of days in a row with an x. A run that starts on 28 January and continues into February counts as one run. The current streak counts up to yesterday until you tick today.
What if I miss a day?
It lowers that month's percentage and ends a streak, nothing else. Fill in an earlier day whenever you like.
Does it work in Google Sheets?
It uses ordinary formulas and no macros, so it runs in Excel and in Google Sheets. In Google Sheets, use the link in the PDF guide to make your own copy, or upload the .xlsx to Google Drive, open it and choose File, Save as Google Sheets. Formulas, dropdowns and colors usually carry across, but chart styling can change a little, so check the main tabs after you import.
Does it send reminders?
No. There are no notifications or reminders, no phone app and no automatic tracking.
What do I get when I buy it?
Three files: a blank workbook, an example workbook with invented ticks for 14 sample habits and a 4-page guide.
How much does it cost, and where can I buy it?
As of 23 October 2026 it costs $5.99 on Etsy. The table above shows what the store sells.
More questions
Can I track more than one year?
One year at a time. Save a copy for each year.
Is it medical or fitness advice?
No. The workbook does not give medical, fitness, nutrition or financial advice.
Does it have a printable version?
It is a spreadsheet. For a habit grid on paper, the 2027 Printable Planner has one on every monthly focus page.
Was AI used to make it?
AI tools were used to help write the wording and the code that builds the workbook, the guide, the pictures and the video. The workbook's results were checked against an independent calculation of the example data.
Can I share the files?
Personal use. Please do not resell, share or upload the files.
What if a file will not open?
Email the address on the contact page. If a file will not open or is not what the listing describes, it gets fixed or replaced.
Start Ticking Today
List your habits, tick today's box and let the tab keep the numbers. The spreadsheet is an instant download. For a calmer budget alongside it, see the ADHD Budget Spreadsheet.
$5.99 on Etsy · instant download · sold by Ink and Index
Planning the year on paper? The 2027 Printable Planner has monthly focus pages.