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.
What's in the template
| Column | What to put in it |
|---|---|
| Ref | A short reference, like G-1, so goals are easy to discuss |
| Goal | What you want to achieve, in one sentence |
| Owner | One person accountable for the goal |
| Due date | When 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 |
| Status | Green (on track), Amber (monitor), Red (off track) or Complete |
| Last updated | The date the owner last reviewed the row |
| Notes and next action | What'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.
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.