Projects
OKR Template: How to Write, Track and Score OKRs
OKRs (Objectives and Key Results) are a simple way for a team to agree on what should change this quarter and how everyone will know it changed. The objective gives direction; the key results are the numbers that prove progress. Written well, a team's OKRs fit on one page and make it obvious what to say no to.
Below you will find a free OKR template in Excel and Word, field-by-field instructions, a filled example with progress calculated, a quarterly routine and the mistakes that make OKRs fail.
What is an OKR?
An objective is a short, qualitative statement of where you want to go, such as 'Make our product a monthly habit for customers'. Each objective gets two to five key results: measurable outcomes with a baseline and a target, such as 'Monthly active customers from 1,200 to 2,000'. Most teams keep one to three objectives per quarter.
OKRs are not the same as KPIs or a performance review. KPIs are health metrics you watch all the time; OKRs pick the few numbers you want to move this quarter. Because OKRs are meant to be ambitious, reaching about 70% is often considered a good result, which is why most companies keep OKR scores separate from pay decisions.
When to use an OKR template
- Before a quarter starts, to agree on team goals with leadership
- When checking that several teams' goals point in the same direction
- In weekly check-ins, to update progress and confidence on each key result
- At quarter end, to score results and run a retrospective
- After a reorganisation or new strategy, to reset priorities
How to fill in the OKR template
The download contains exactly these fields. In the key results table, enter baseline, target and current values as plain numbers so the spreadsheet can calculate progress.
Basics
| Field | What to write | Example |
|---|---|---|
| Team and owner | The team responsible and one named owner. | Growth team / owner: Maya Chen |
| Period | Quarter with start and end dates. | Q4 2026 (Oct 1 – Dec 31) |
| Objective | One memorable sentence stating direction and why it matters. | Make our product a monthly habit for customers |
| Alignment | Which company or department OKR this supports. | Supports company O2 'Grow subscription revenue' |
Key results table
| Field | What to write | Example |
|---|---|---|
| Key result | A measurable outcome, not a task. Move tasks to initiatives. | Monthly active customers |
| Baseline | The real value at the start of the quarter. | 1,200 |
| Target | Where you want to be by quarter end. Avoid numbers you will beat easily. | 2,000 |
| Current and progress | Update weekly; progress = (current − baseline) ÷ (target − baseline) × 100. | 1,680 → 60% |
Execution and review
| Field | What to write | Example |
|---|---|---|
| Initiatives | The projects that should move the key result, with an owner and date. | Redesign onboarding emails (Leo, Nov 15) |
| Confidence | Weekly 1–10 estimate of hitting the target this quarter. | 7/10 |
| Check-in cadence | When and how the numbers are updated. | Mondays, 15-minute stand-up |
| Score and retro | End-of-quarter score from 0.0 to 1.0, lessons and what carries over. | 0.62 – conversion experiments carry over to Q1 |
OKR example
A mid-quarter check (second week of November) for a SaaS growth team. All key results are metrics where higher is better.
| Team | Growth team (owner: Maya Chen) |
|---|---|
| Quarter | Q4 2026 |
| Objective | Make our product a monthly habit for customers |
| Overall progress | 62% average as of week 2 of November |
Key results
| Key result | Baseline | Target | Current | Progress (%) |
|---|---|---|---|---|
| Monthly active customers | 1,200 | 2,000 | 1,680 | 60 |
| Trial-to-paid conversion (%) | 8 | 12 | 10.6 | 65 |
| Net Promoter Score | 32 | 45 | 40 | 62 |
Progress = (current − baseline) ÷ (target − baseline) × 100, rounded. The average of the three key results is (60 + 65 + 62) ÷ 3 ≈ 62%, which is on track for the middle of a quarter.
Free download
Free, no sign-up. Opens in Excel, Google Sheets, Numbers, Word, Google Docs and LibreOffice.
Open the downloaded file in Nobami, our web office, to edit it right away.
How to run OKRs in a quarter
- Start from company priorities. Read the company or department OKRs and pick one to three areas where your team can make the biggest difference.
- Write each objective in one sentence. No numbers, just direction and purpose, short enough that everyone on the team can repeat it.
- Add two to five key results per objective. Give each a baseline and a target. If it reads like a task, move it to initiatives.
- Assign owners and first initiatives. One owner per key result, plus the work you will start in the first two weeks.
- Check in for 15 minutes every week. Update current values and confidence, then spend the time on the key results that are stuck.
- Score and reflect at quarter end. Score each key result from 0.0 to 1.0, write down what you learned and use it to draft the next quarter.
Legal and privacy notes
No law regulates OKRs as such; they are an internal management practice. Legal questions appear when OKR results feed into pay, bonuses or performance ratings: then the criteria should be written into your compensation or appraisal policy, applied consistently and free from discrimination.
If you track key results per person, those numbers are personal data. In the EU and UK, data protection law requires a clear purpose, limited access and transparency towards employees, so share individual results only with the people who need them and prefer team-level dashboards.
Many companies deliberately keep OKR scores out of bonus formulas. When people are paid on the score, they set safer targets and the ambition that makes OKRs useful disappears.
Sources
- European Commission: data protection explained (checked November 11, 2026)
- GOV.UK: data protection in your business (checked November 11, 2026)
General information, not legal advice. Employment and privacy rules differ by country and company; check your internal policies before linking OKRs to pay or ratings.
Common OKR mistakes
- Writing five or more objectives and dozens of key results, so nothing is a priority
- Listing tasks such as 'launch new landing page' as key results
- Sandbagging: choosing targets you know you will hit
- Writing OKRs at the start of the quarter and never looking at them again
- Paying bonuses directly on OKR scores, which kills ambitious goals
- Leaving out the baseline, so progress cannot be calculated
OKR template FAQ
What is the difference between OKRs, KPIs and a performance review?
KPIs are ongoing health metrics, OKRs are the few outcomes you want to move this quarter, and a performance review assesses a person's contribution and links it to pay or promotion. Use OKR results as one input to a review, not as the score itself.
How many OKRs should a team have?
One to three objectives per quarter, each with two to five key results. More than that usually means no real focus.
Is a score of 0.7 a failure?
For ambitious OKRs, 0.6 to 0.7 is usually a good outcome. If you score 1.0 every time, your targets are probably too low.
How do I calculate key result progress?
Use (current − baseline) ÷ (target − baseline) × 100. The Excel download uses the same formula.
Can I use the template in Google Sheets?
Yes. The .xlsx file opens in Google Sheets and the .docx file opens in Google Docs.