2027 Habit Tracker Spreadsheet: Weekly Goals, Streaks, Skip Days, Yearly Log, Excel and Google Sheets

A habit tracker for habits you don't do every day. Give each habit its own weekly goal (walk 5 days a week, lift 3 days a week) and keep a week streak going when you hit it, even with rest days in between.

What's inside:

- Habits: up to 15 habits, each with a goal of 1 to 7 days per week and a note on why it matters to you. Shows done this week, left this week, week streak and best week streak, day streak and best day streak, the last 30 days, the last 4 weeks vs. your goal, and totals.

- Log: one row per day for a full year (53 weeks). Type x when you did a habit, or s for a skip day (sick, travel, rest). Skip days don't break your day streak. Today's row is highlighted.

- Today: each habit's status today, this week's count vs. goal and both streaks, made for a quick check on your phone.

- Weeks: every week's count per habit, green when you hit the goal.

- Months: each month's share of days done for every habit.

- Setup: pick any start date. Each week runs from that weekday.

- Instructions tab first, locked formula cells and a layout designed for small screens.

Who it's for: Anyone who has quit a daily habit tracker because one missed day reset everything, or who tracks habits like workouts that aren't meant to be daily.

How it differs from most free trackers: one log for the whole year instead of a new tab each month, a weekly goal per habit, week streaks, and skip days. It uses only standard formulas that work in Excel and Google Sheets. The sample habits and check-offs are made up. This file doesn't give health or medical advice.

Everything is typed in by hand. There is no live data and no account connection. The sample data is made up, so you can delete it and enter your own.

Format: one .xlsx file. Open it in Excel, or upload it to Google Sheets. It uses only standard formulas that both support. No macros, no add-ons, no links to other files.

Delivery: instant download after checkout. The download link is also in your receipt email.

Questions or a problem with the file? Use this store's Contact page, or email the address in your receipt. If the file doesn't work for you, we'll fix it or refund you.

License: personal use. Use it for yourself. Please don't resell, share or re-upload the file.

Built and tested with AI assistance.