Free template

Free goal and KPI tracking template

One simple Excel sheet for your team's goals. Every goal gets an owner, a due date and a red, amber or green status. Attach a KPI and target where it helps.

Get the free template

Excel workbook. Enter your email and the download link appears here.

We'll ask you to confirm your email address, then send a few practical follow-ups. Unsubscribe anytime. See our Privacy Policy.

A glowing spreadsheet grid with green, amber and red status lights and an owner marker on each row, under a download arrow

What's in the template

ColumnWhat to put in it
RefA short reference, like G-1, so goals are easy to discuss
GoalWhat you want to achieve, in one sentence
OwnerOne person accountable for the goal
Due dateWhen it needs to be done
KPI (optional)The measure that shows progress, if a number helps
Target (optional)The level of the KPI you're aiming for
Latest result (optional)The most recent figure, updated by the owner
StatusGreen (on track), Amber (monitor), Red (off track) or Complete
Last updatedThe date the owner last reviewed the row
Notes and next actionWhat's changed, and what happens next

The workbook also has a short instructions sheet and a status summary that counts how many goals are green, amber, red and complete. Three example rows show how it works. They're marked EXAMPLE, so delete them before you start.

How to use it

Five steps to a goal tracker your team will use

  • List the goals that matter this year. Keep it to the few your leadership team will actually review.
  • Give each goal one owner and a due date. If two people own it, nobody does.
  • Add a KPI only where a number helps. Leave the KPI and target blank for goals that are judged by a milestone or a finished piece of work.
  • Ask owners to update the status before each meeting. Use green, amber and red honestly. Amber is a useful early warning, not a failure.
  • Review it on a rhythm. Weekly, fortnightly or monthly, start with what's red and amber.

Need ideas for what to measure? See KPI examples for leadership teams. New to RAG status? Read RAG status meaning and examples.

When the spreadsheet stops working

A spreadsheet is a good start. It gets harder when several people edit it, nobody's sure which copy is current, and the update only happens the night before the meeting.

LeaderKit keeps the same structure, with goals, owners, due dates, optional KPIs and red, amber or green status, and adds what a spreadsheet can't:

  • key actions under each goal, with their own owners and due dates
  • reminders before deadlines and a weekly digest in Microsoft Teams
  • a recurring review meeting with an agenda you can preview
  • board packs: frozen, read-only snapshots for your board, showing each goal's saved KPI
  • a download of your data as Excel and CSV files whenever your subscription is active

Start your 14-day free trial, or see KPI software.

Template FAQs

Is the template really free?

Yes. Enter your email and the download link appears straight away. Use it as often as you like.

What format is it?

An Excel workbook (.xlsx). It also opens in Numbers and other spreadsheet apps that read Excel files.

Do I have to fill in a KPI for every goal?

No. The KPI, target and latest result columns are optional. Use them where a number genuinely shows progress.

Can I bring these goals into LeaderKit later?

Yes. The template follows the same structure as LeaderKit: goal, owner, due date, optional KPI and status. During your free trial, set your goals up in LeaderKit and retire the spreadsheet.

Every goal owned, every deadline visible

Start with the template. When you're ready for reminders, review meetings and board packs, try LeaderKit free for 14 days. LeaderKit is New Zealand founded and built for teams everywhere.