Features Industries Customer Service AI Pricing Blog Log in Start for free
FREE TEMPLATE

OKR template: a free spreadsheet with a filled-in example.

Two objectives, three key results each, with a target, current value, and owner. Download the spreadsheet or track your OKRs directly in Tasskee, linked to tasks.

Example: HVAC services company with 20 employees, Q4 Download it as a spreadsheet (opens in Excel and Google Sheets) or build it right in Tasskee, with deadlines, assignees and notifications.
Download spreadsheet Use it on Tasskee, free
ObjectiveKey resultGoalCurrentOwnerDue dateSituation
O1. Be the company that fixes it right the first timeKR1. Reduce rework (repeat visits)From 12% to 6%9%Sandro Figueiredo19/12In progress
O1. Be the company that fixes it right the first timeKR2. Tickets resolved on the first visit85%78%Sandro Figueiredo19/12In progress
O1. Be the company that fixes it right the first timeKR3. Technicians using the visit checklist100% (8 technicians)5 techniciansPaulo Henrique31/10At risk
O2. Grow with recurring clientsKR1. Active preventive maintenance contractsFrom 18 to 3023Renata Camargo19/12In progress
O2. Grow with recurring clientsKR2. Renewal of contracts expiring this quarter90%100% (4 of 4)Renata Camargo19/12On target
O2. Grow with recurring clientsKR3. Satisfaction survey (average score)4.5 out of 54,2Juliana Moreira19/12At risk

What is an OKR

OKR (Objectives and Key Results) is a method for focusing a team over a short cycle, usually a quarter. It has two parts. The objective is a qualitative sentence that says where you want to go: "be the company that fixes the most on the first try." The key results are numbers that prove whether you got there: "85% of tickets resolved on the first visit."

The example above is from an HVAC services company with 20 employees, with two objectives and three key results each. Note that each result has a starting value, a target, a current value and an owner.

How to fill it in, column by column

ColumnWhat to writeCommon mistake
ObjectiveA short, inspiring, qualitative sentence, with no numberWriting the objective as a numeric target ("sell R$ 1 million")
Key resultSomething measurable, with a starting point and a destination: "from 12% to 6%"Writing a task ("run training") instead of a result
TargetThe value you want at the end of the cycleA target with no starting value, which doesn't show the size of the jump
CurrentThe value measured today, updated every weekUpdating only at the end of the quarter
OwnerOne person who looks after the numberA collective owner ("customer service team")
Due dateThe end date of the cycle, or of the intermediate milestoneA cycle that is too long, a year, with no mid-cycle review
StatusOn track, at risk or behind, using an agreed criterionEverything green until the last day

Step by step to build yours

  1. Choose few objectives. Two or three for the cycle. Ask: if only this worked out this quarter, would that be good?
  2. Write the objective without a number. It should be clear enough for any employee to understand and remember.
  3. Define two to four key results for each one. If the objective is met, these numbers change.
  4. Write down the starting point. Without knowing where you are today (12% rework), the target (6%) means nothing.
  5. Give each result an owner. One person, by name.
  6. Schedule a short weekly check-in. Fifteen minutes: current value, what got stuck, what's next.
  7. At the end of the cycle, review and start another. Without rewriting the past.

Common mistakes

  • A key result that is a task. "Roll out the checklist" is an action; "100% of technicians using the checklist" is a result. The task stays in the project and the result stays in the OKR.
  • Results the team doesn't control. If the owner can't influence the number, it's just a tracking metric.
  • Too many OKRs. Fifteen results for a team of eight people scatter attention. Cut back until only what matters is left.
  • Tying OKRs to bonuses in the first cycle. When the score turns into money, the target shrinks. Start with the method and only then discuss compensation.
  • Never looking during the cycle. OKRs only work if the number is reviewed often, and the week's conversation changes the course.

When the spreadsheet template isn't enough

An OKR spreadsheet is simple to set up and hard to keep alive. The current value has to be updated by hand, the objective's progress is a calculation someone has to do, and there is no link between the number and the work that moves it. The KR "100% of technicians with the checklist" advances because someone trains technicians, but that action lives somewhere else, in another tool, and nobody sees the connection.

For the method in detail, with cycles and check-in best practices, read the OKR guide. And to see the link between goal and task in practice, the post OKRs linked to tasks shows an example.

OKRs linked to what the team does

In Tasskee, the objective's progress is calculated from the key results, and tasks stay linked to the goal. What moves the number shows up right next to it.

See goals and OKRs

How to use OKRs in Tasskee

Goals and OKRs are available from the Pro plan.

  1. Add each objective as a goal and each key result as a result of that goal, with the target value and the owner.
  2. Update the current value at each weekly check-in. The objective's progress is calculated from the results; you don't type in the objective's percentage.
  3. Link tasks and projects to goals, so you know which actions move each result.
  4. Use reports and dashboards to follow goals alongside the work.
  5. Set up a reminder automation for the weekly check-in day.

If the actions behind the key results run in short cycles, see the backlog and sprint template. And to break an action down into dates and assignees, use the project schedule template.

Frequently asked questions

OKR FAQ

What is OKR?
OKR stands for Objectives and Key Results. The objective says where you want to get to, in words; the key results say, with numbers, how you'll know you got there.
How many objectives and key results should I have?
Few. Two to five objectives per cycle, with two to five key results each. When everything is a priority, nothing is. The example uses two objectives and three results each.
What's the difference between an OKR and a goal or KPI?
A KPI is an indicator you track all the time. A goal is a number to hit. An OKR pairs a qualitative, inspiring objective with quantitative results that measure it. It's a focus method for a cycle, usually a quarter.
How much of the target is a good result?
It depends on how the company defines it. Many teams treat OKRs as stretch goals and celebrate a big step forward even without reaching 100%. What matters is agreeing on the yardstick before the cycle, not adjusting the target midway.
How do you track OKRs in Tasskee?
You add the objective and key results, update the values every week (check-in), and the objective's progress is calculated from the results. Tasks stay linked to the goal, and the team sees what depends on what.

OKRs that move with your team's tasks.

Objectives, key results, and calculated progress, tied to the real work. Try Tasskee free, no credit card.

15 days with everything unlocked No credit card Support in Portuguese
Contact us