All tools

OKR template: objectives and key results

Write each objective and its key results with the starting value, the target and the current value. The template calculates progress for each key result and objective, and warns you if a key result looks like a task or has no number. Download it as Excel to update it every week with your team.

Your draft is saved in this browser.

Objective 1

Excel (.xlsx)

With progress for every key result and objective calculated by formulas: you only update the Current column.

If you download without writing anything, the Excel file comes with three empty objectives to fill in by hand.

Everything is built in your browser. The draft is saved only on this device.

How to write good OKRs

Objective: what you want to achieve, in one qualitative, motivating sentence, without numbers. "New hires feel part of the team from their first month."

Key results: how you will know you got there. 2 to 4 per objective, each with a starting number and a target. "Cut 6-month turnover from 18% to 10%."

A key result measures an outcome, not a task. "Launch the onboarding program" is a task: it goes in the work plan, not the OKR.

3 to 5 objectives per team per period. More than that dilutes focus.

Progress = (current − start) / (target − start). It works for goals that go up and goals that go down.

Your draft is saved in this browser.

How to read progress

  • OKR targets are set ambitiously on purpose: reaching 70% is usually considered a good result. If you always hit 100%, your targets are too easy.
  • Review progress every week or two in a short meeting. What matters is discussing what is blocking progress, not the number.
  • At the end of the quarter, score each key result, write down what you learned and only then set the next OKRs.
  • Keep OKRs separate from performance reviews: if bonuses depend on OKRs, people set easy targets.
Step-by-step guideWhat OKRs are and how to use them at your company (with examples by team)What OKRs are, how to write objectives and key results, how to review them weekly, examples by team and common mistakes. With a free Excel template.

Frequently asked questions

What are OKRs?
OKR stands for Objectives and Key Results. It is a goal-setting method where each qualitative objective comes with 2 to 4 measurable results that show whether it was achieved. They are usually set quarterly and reviewed often.
What is the difference between OKRs and SMART goals?
A SMART goal is a single specific, measurable, time-bound goal. An OKR is a broader objective with several key results, which are usually SMART themselves. OKRs are more ambitious and are not usually tied to bonuses.
How many OKRs should a team have?
3 to 5 objectives per period, with 2 to 4 key results each.
What progress percentage is good?
Around 70% is considered a good result, because targets are ambitious. A constant 100% means targets are too easy; below 40%, something went wrong with the plan or the target.
Do you store what I type?
No. The draft stays in your browser and the Excel file is built on your device.

Know what you want to ask?

Build the survey in SurvIQ, share it by link, WhatsApp or QR code, and watch results come in live. The Free plan is free forever.

Create a free survey

More tools