Back to milestra.app

Free template

Free OKR and KPI tracker: objectives, key results and KPIs in one file

Most OKR spreadsheets stop at a list of goals. This one runs the rhythm: owners log a value and their confidence each week, and progress, status and the dashboard update themselves. Monthly KPIs sit alongside, so the measures you track every month and the results you are changing this year are in one place.

Preview of the oKR and KPI tracker
Excel · 6 sheets

OKR and KPI tracker

Objectives, key results and weekly check-ins, with monthly KPIs and a dashboard that scores everything for you.

  • Progress from baseline, latest value and confidence for every key result
  • Status: On track, At risk, Off track, Needs update
  • Monthly KPIs against target with green, amber, red
  • Dashboard with progress bars for every objective
Free · Opens in Excel and Google Sheets · Sent to your inbox

What's inside

SheetWhat it does
DashboardOverall progress, status counts, every objective's progress bar and your KPIs at a glance.
ObjectivesThree to five objectives with owner, team, period and dates; progress, time elapsed and status are calculated.
Key resultsBaseline, target, unit and due date; the latest value, progress, confidence, days since update and status fill in from Check-ins.
Check-insOne line per key result per week: the date, the latest value and High, Medium or Low confidence.
KPIsTwelve months of values per KPI with a target and direction; latest value, % of target and status calculated.
Start hereSix steps to set it up and run it, and what each colour means.

How to use it well

  1. Write three to five objectives. Qualitative and motivating: what will be different by the end of the period.
  2. Add two to four key results to each. Each with a baseline, a target and a unit, so progress can be measured rather than argued.
  3. Give every key result one owner. One name, not a team. Owners log the check-ins.
  4. Check in every week. The latest value and a confidence level take a minute. A key result with no check-in for 14 days is flagged.
  5. Track your KPIs monthly. Income, reach, cost per result: the measures you keep healthy all year.
  6. Review the dashboard together. Spend the meeting on what is at risk or off track, not on reading numbers aloud.

Skip the spreadsheet

Run your OKRs without chasing updates

Milestra asks each owner for their weekly check-in by email (SMS and WhatsApp coming soon), keeps evidence with every result, escalates what's slipping and builds your board report from the live numbers. Free for up to 5 people, and nonprofits get 50% off paid plans.

Frequently asked questions

What is the difference between an OKR and a KPI?

A KPI is a measure you watch all the time to keep something healthy, like monthly income or cost per person reached. An OKR is a time-bound push to change something: an objective with two to four key results you aim to move this quarter or year. Most organisations need both, which is why this tracker has both.

How is progress calculated?

From the baseline: (latest value − baseline) ÷ (target − baseline), capped between 0% and 100%. A key result that moves from 1,200 to 3,480 households against a target of 4,000 is 81% of the way there.

How is status decided?

Achieved at 100%. Otherwise the owner's latest confidence sets it: High is On track, Medium is At risk, Low is Off track. If there has been no check-in for 14 days it shows Needs update, because an old number is not a status.

How many objectives should we have?

Three to five for the organisation, each with two to four key results. More than that and nobody can say what matters most.

Can I use it for teams as well as the whole organisation?

Yes. Use the Team column on Objectives, or keep one copy per team and a summary copy for leadership.

Does it work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Formulas, dropdowns, colours and progress bars carry over. It also works in Excel 2019 or later and Microsoft 365.

Is it really free?

Yes. Enter your email and we send the file straight to your inbox. Use it and share it inside your organisation as often as you like.

More free resources