2027 Habit Tracker Spreadsheet, New Year Goal Planner for Excel & Google Sheets

Make 2027 the year your goals actually stick.

Write down up to 10 goals for the year, then build the daily habits that get you there. The New Year Goal & Habit Tracker 2027 gives you a dated habit grid for every month from January to December, works out your completion % for every habit, every day and every month, and shows how close you are to each goal on one dashboard.

WHAT'S INCLUDED
• Dashboard: goals set, goals done, average goal progress, habit completion for the year and this month, and your best habit month
• Progress bars and a status (Done, On track, Behind, Past due) for every goal
• Two charts: habit completion by month and progress by goal
• Goals tab for up to 10 goals: category, why it matters, measure, start, target, where you are now (or a simple % done) and a deadline
• Habits tab for up to 12 habits, each linked to a goal with a target %, plus a year-at-a-glance grid colored against your target
• 12 monthly habit trackers for January to December 2027 with day numbers and weekdays already filled in, a daily score and completion % per habit
• Monthly check-in sheet: rate the month, biggest win, what got in the way, what you learned and your focus for next month
• Start Here guide
• Two files: a blank tracker and a filled-in example

WORKS WITH
• Microsoft Excel (2010 or later, Windows and Mac, and Excel online)
• Google Sheets (free): upload the file to Google Drive and open it with Google Sheets

HOW IT WORKS
1. Purchase and download instantly from your Etsy Purchases page.
2. Open the file in Excel, or upload it to Google Drive and open it in Google Sheets.
3. Add your goals and habits, then check off each day on that month's tab.

PLEASE NOTE
• This is a digital download. No physical item will be shipped.
• The monthly trackers are dated for 2027 (January 1 to December 31, 2027).
• For personal use. Please don't resell or share the file.

How we make it: Every Penny & Pencil template and worksheet is designed in-house with AI-assisted tools, then each page, formula and answer key is checked and tested before it is listed.

Questions? Send us a message. We usually reply within a day.