Skip to content
Goal Tracker cover: a sample sheet with goals set, average progress and goals done and a bar chart, beside the Dashboard and Goals tabs

Goal Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This goal tracker suits anyone planning a year of targets across money, health, career, learning and home. The Goals tab holds a row for every goal, with its area, start and due dates, progress percent, status and next step. Days left is worked out from the due date, and a row turns red once the date passes without the goal marked Done. The Dashboard counts your goals, averages progress and charts goals by area.

Begin with three to five active goals, and give each one a small next step so nothing sits idle through January. Update progress monthly, not every day. When a status turns Behind, move the deadline or split the goal into smaller pieces rather than dropping it. Replace the sample goals with your own on the Goals tab, and keep the Dashboard open as a monthly review page.

Useful for

  • Setting and checking personal goals for the coming year
  • Planning household money and home projects together
  • Reviewing career goals with a manager each quarter

What's included

  • 3 tabs: Dashboard, Goals, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Goals: a table
  • 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

How do I track progress on each goal?

Type the progress as a percent in the Progress column, anywhere between 0% and 100%. The Dashboard averages it across all goals and by area. Change the status to On track, Behind or Done in the same edit, so the counts stay accurate.

Does the tracker work for team goals?

Yes. Add a column for the owner of each goal and filter by name when you review. A short area list keeps the chart readable. A shared copy works well for a household or a small team that reviews goals together.

What changes when the year rolls over?

Replace the dates on the Goals tab with dates in the new year. Days left uses TODAY(), so it always counts down from the current date. Clear the sample goals and start a fresh list for the new year.

  • #habit-tracker
  • #goal-tracker-2027
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More habit tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…