Build habits you can actually see.
Streakline is a habit tracker spreadsheet with a sleek dark design. You set up your habits once, tick them off each day, and the file does the maths. Streaks, rings, charts, a Year in Pixels view and a full annual dashboard all fill in by themselves.
It works in Microsoft Excel and Google Sheets. No macros, no add-ons, no subscription.
Who It’s For
- Anyone starting a new routine who wants proof it’s sticking
- People who want the whole month on one screen, not one day at a time
- Students, parents and busy professionals tracking sleep, workouts, study, money or anything else they do most days
- Night owls. The dark design is easy on the eyes after sunset
What It Does
- Habit Planner: set the year, list up to 40 daily habits, pick a category and how many days a week you’re aiming for. Monthly goals work themselves out, and you can type over any of them.
- 12 monthly trackers: type x or 1 to tick a habit. Squares fill with colour by week, today’s column is highlighted, and each habit shows done, %, a progress bar, current streak and best streak.
- Monthly dashboard: four live rings (7-day momentum, today, this week, month progress), a daily progress chart, top 5 habits and your longest active streaks.
- Weekly habits: up to 10 things you do once a week, ticked per week block.
- Mood tracking: rate each day 1 to 5.
- Monthly rewards: pick a treat for each month. The tracker tells you how close you are and when it’s unlocked.
- Reflection boxes: wins, what got in the way, and your focus for next month.
- Annual dashboard: year totals, rings, a done vs goal chart, top 10 habits, Year in Pixels, a habit scorecard heat map, category breakdown, quarters and weekly-habit success.
- Insights: choose any habit to see its year month by month, its best and toughest weekday, best streak and best month. See your strongest weekday overall and how mood lines up with your habits.
- Habit Ideas: 63 ideas across 9 categories.
- Start Here page with quick steps and a button for every tab.
What’s Included
- Streakline-Habit-Tracker.xlsx (blank, set to 2027, works for any year)
- Streakline-Habit-Tracker-Sample.xlsx (filled with 9 months of example data)
- Streakline-Printable-Tracker-2027.pdf (13 ink-friendly printable pages)
- Streakline-User-Guide.docx (18 illustrated pages, with troubleshooting and FAQ)
Why It’s Different
- One file that works in Excel AND Google Sheets
- Any year, and you can start on any day. Days before your start don’t count against you
- Goals based on days per week, so a 3-day gym habit isn’t marked as a failure
- Streaks can carry over from one month to the next
- Formulas are protected (no password), so you can’t break them by accident
How It Works
- Download the files after checkout.
- Open the tracker in Excel, or import it into Google Sheets (File > Import > Upload).
- Fill in the Planner: year, habits, categories, days per week.
- Tick your habits each day on the month tab.
- Check your dashboards and Insights whenever you like.
File Formats
.xlsx (Excel workbook), .pdf (printable), .docx (user guide)
Software Requirements
Microsoft Excel 2016 or newer (Windows or Mac), Microsoft 365, Excel for the web, or Google Sheets (free with a Google account).
Customisation
Rename the 9 categories, set your own goals, rewards and weekly habits, and change the year whenever you like. Want different colours or fonts? Unprotect the sheet (no password) and make it yours.
Digital Download
This is a digital product. No physical item will be shipped. Your files are available to download straight after payment. Licensed for personal use only. Please don’t share or resell the files.
Reviews
There are no reviews yet.