Skip to content
The title slide and first slides of the New Year Goals Tracker template

New Year Goals Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Minimal
Difficulty
Beginner
Updated
November 6, 2026

Every slide (4)

Overview

A goal tracker for setting yearly goals across areas such as health, money, career and learning. The Goals tab records each goal with its target, current figure, progress and status. The Check-ins tab is a monthly grid where you tick each month you review a goal. The Summary tab shows how many goals are done or at risk, and the average progress for each life area.

The template comes with sample goals and check-ins. Make a copy, then replace the sample rows with your own. Progress, the summary, the check-in totals and the chart update on their own as you change the figures.

Useful for

  • Setting three to five goals for the year ahead
  • Reviewing progress once a month with the tick grid
  • Spotting goals that have fallen behind

What's included

  • 4 tabs: Summary, Goals, Check-ins, How to use
  • Summary: a dashboard with 4 summary figures
  • Goals: a table
  • Check-ins: a grid
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Goals tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this New Year Goals Tracker template free?

Yes. Download the template and make a copy for your own use at no cost.

Does it work in Excel?

Yes. Download the .xlsx file from this page and open it in Microsoft Excel. The tabs, formulas, dropdowns, checkboxes and charts all work there.

Do I need to change the months in the check-in grid?

No. The grid has the twelve months of the year. Tick the months when you check progress, and the total column counts your check-ins for each goal.

  • #goal-tracker
  • #new-year-goals-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More new year templates

See all 38

Also in Holidays

All holidays templates
Get this template

Preparing your template…