Home › Productivity & Goals › Goal Tracker Spreadsheet with Automatic Progress

The Goal Tracker spreadsheet for Excel and Google Sheets, with steps, automatic progress and deadlines. A preview shows the dashboard with active, completed and overdue goals, average progress, charts and the next deadlines.

Goal Tracker Spreadsheet with Automatic Progress

Name: Goal Tracker Spreadsheet with Automatic Progress
Brand: Else Court

Big goals are easier to follow when they are split into small steps. In the Goal Tracker you list your goals, add the steps of each one and set a step to Done as you go.

Progress, days left and a heads-up label update by themselves: 3 steps done out of 4 is 75%, and each goal shows whether it is overdue, due this month or on track. The Dashboard lists your next deadlines and the active goals with the lowest progress.

It is a digital download for Excel and Google Sheets, made for personal goals, study, work and home projects.

View on Etsy

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Up to 30 goals with category, priority, status, start date and due date
Up to 600 steps, each linked to a goal from a dropdown
Progress percent, steps done, days left and a heads-up label for every goal
Categories: Personal, Health, Career, Finance, Learning, Home, Family and Other
A dashboard with 8 tiles and 4 charts, and a due calendar for the next 12 months
Goals by status, category and priority

Who it's for

Anyone with several goals and different deadlines
Students and professionals who like to see steps and progress
Anyone planning a personal, home or work project in stages

How it works

List your goals with a category, a priority and a due date.
Add the steps of each goal on the Steps tab.
Set a step to Done as you finish it.
Check the Dashboard for progress and the next deadlines.

See inside

Goal dashboard with 8 summary tiles (active goals, completed, overdue, due this month, average progress, steps remaining, high priority and data warnings), charts by status, category and priority, and two ranked tables.

Steps tab where every goal is broken into small steps: choose the goal, type the step, add a due date and set the status to Done. Progress updates automatically as each step is completed.

Goals tab with up to 30 goals, each with category, priority, status, start date and due date, plus steps total, steps done, progress percent, days left and a heads-up.

Goal list showing progress and a heads-up for every goal: overdue in red, due today and due in 7 days in amber, completed in green, on hold in grey and all steps done in blue.

Summary tab with goals and average progress by status, category and priority, a due calendar for the next 12 months and step totals including overdue steps.

Dashboard section with the next deadlines, showing due date, days left and progress, a table of active goals with the lowest progress and a short summary line.

List of the 5 tabs included in The Goal Tracker and three steps: download, add your goals, then add steps and tick Done. Goal tracking tool, no macros, no subscription, digital download.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You get an Excel workbook and a PDF guide with a link to make your own copy in Google Sheets. The two versions are separate files and do not sync.

What if a goal has no steps?

It shows 0% until you set its status to Completed, which counts as 100%.

Can I put a goal on hold?

Yes. On hold goals are never shown as overdue.

Is there an example file?

Yes. A second Excel file is filled with example data for goals and steps, so you can see how everything works before using your own numbers.

More in Productivity & Goals

The Habit Tracker spreadsheet for Excel and Google Sheets, with flexible weekly targets and streaks. A preview shows the dashboard with habits done today, habits on target this week, month and year completion and charts.

Habit Tracker Spreadsheet for Excel & Google SheetsTrack daily, weekly and monthly habits with clear streaks and summaries.