OKR Template for Excel: Write, Track and Score Objectives and Key Results
Set up an OKR template in Excel or Google Sheets: objectives, key results with baseline and target, automatic progress, expected-progress comparison, weekly check-ins, end-of-quarter scoring and a worked example.
An OKR template in Excel lists each objective for the quarter with three to five measurable key results — baseline, target and current value — then calculates progress for every key result and the objective, and compares it with how far through the quarter you are. OKRs (Objectives and Key Results) separate the qualitative goal (“what we want to achieve”) from the measurable evidence (“how we’ll know”). For small teams, a spreadsheet is enough to run the whole cycle: setting, weekly check-ins and end-of-quarter scoring.
This guide belongs to our Project Management hub. OKRs set direction; the work that moves them lives in a project management template or a to-do list.
Objectives, key results, initiatives and KPIs
| Element | What it is | Example |
|---|---|---|
| Objective | Qualitative, motivating, time-bound goal | Make onboarding effortless for new customers |
| Key result | Number with a baseline and a target | Raise 30-day activation from 42% to 60% |
| Initiative | Work expected to move a key result | Rebuild the welcome email sequence |
| KPI | Ongoing health metric | Monthly revenue, gross margin, churn |
A common mistake is writing initiatives as key results (“launch new help center”). The launch is a task; the key result is the change it causes (fewer tickets, faster activation). Ongoing KPIs belong on an Excel dashboard.
Template structure
- OKRs tab: quarter, team, objective, key result, unit, baseline, target, current, weight, progress, status, confidence (1–10), owner, last comment.
- Check-ins tab: one row per week per key result with the measured value — the source for trend charts.
- Initiatives tab: initiatives linked to key results, with owner, due date and status.
- Settings tab: quarter start and end dates and status thresholds.
Formulas
Key result progress
=MIN(1,MAX(0,(F5-D5)/(E5-D5))) with baseline in D, target in E and current in F. It works for metrics you want to decrease as well: going from 6 days to 4.5 days against a target of 3 days gives (4.5 − 6) / (3 − 6) = 50%.
Objective progress
- Simple average:
=AVERAGE(G5:G8) - Weighted:
=SUMPRODUCT(G5:G8,H5:H8)/SUM(H5:H8)
Expected progress today
=MIN(1,MAX(0,(TODAY()-Settings!B1)/(Settings!B2-Settings!B1)))
Status
=IF(G5>=$J$1,"On track",IF(G5>=$J$1-0.2,"At risk","Off track")) with expected progress in J1. Combine it with the owner’s confidence score: a key result can be “on track” by the numbers but low confidence because a dependency is slipping.
Worked example: onboarding objective, week 6 of 13
Expected progress at week 6: 6/13 ≈ 46.2%.
| Key result | Baseline | Target | Current | Progress | Status |
|---|---|---|---|---|---|
| 30-day activation rate (%) | 42 | 60 | 54 | 66.7% | On track |
| Median days to first value | 6 | 3 | 4.5 | 50.0% | On track |
| Onboarding tickets per new customer | 1.8 | 1.0 | 1.5 | 37.5% | At risk |
| Onboarding CSAT (1–5) | 4.1 | 4.5 | 4.3 | 50.0% | On track |
| Objective | 51.0% | On track |
The objective is slightly ahead of the calendar (51.0% vs. 46.2%). Activation is moving fastest; support tickets are the laggard. In the weekly check-in, the team might shift effort to the help-center articles that address the most common onboarding questions. Figures are illustrative.
Writing OKRs that work
- One to three objectives per team per quarter.
- Three to five key results per objective, each with a known baseline.
- Outcomes, not outputs: “publish 10 articles” is output; “cut onboarding tickets from 1.8 to 1.0 per customer” is an outcome.
- Weekly measurable: if a number only appears at quarter-end, it can’t steer the work.
- Committed vs. aspirational: label each OKR. Committed OKRs are expected to hit 100%; aspirational ones are deliberately stretching, so partial achievement can still be a good result.
- One owner per key result.
The OKR cadence
| When | What | Time |
|---|---|---|
| Quarter start | Review last quarter, set OKRs, record baselines | Half a day |
| Weekly | Update values and confidence, flag blockers | 15–30 min |
| Mid-quarter | Sanity-check key results; adjust initiatives, not targets | 1 hour |
| Quarter end | Score, write lessons, carry over what still matters | 1–2 hours |
Record check-in decisions with the meeting minutes template so the “why” behind changes isn’t lost.
End-of-quarter scoring
Freeze the final values and keep the progress formula as the score (0.0–1.0). Add a short note per key result: what worked, what didn’t, and whether it continues next quarter. A simple chart of objective scores across quarters shows whether the team is setting goals that are too easy or too ambitious.
Common mistakes
- Too many OKRs — focus disappears.
- No baselines — progress becomes opinion.
- Tying OKRs directly to bonuses — encourages sandbagged targets.
- Set and forget — without weekly check-ins, OKRs become a wish list.
- Overwritten formulas — lock calculated columns; see how to protect formulas in Excel.
FAQ
How often should OKRs be set?
Quarterly is most common, sometimes with annual objectives as context. A quarter is long enough to move a metric and short enough to change course.
What’s a good final score?
It depends on the OKR type. Committed OKRs should be fully met. For aspirational OKRs, many organizations treat roughly two-thirds achievement as a solid result. Agree on the rule before the quarter starts.
Do individuals need their own OKRs?
In small teams, company or team OKRs are usually enough. Individual OKRs add overhead and blur into performance reviews.
Does the template work in Google Sheets?
Yes — MIN, MAX, AVERAGE, SUMPRODUCT, IF and TODAY all work the same way.
Next step: write one objective for next quarter, define three key results with baselines and targets, and set up the OKRs tab with the progress formula. More planning tools are in the Project Management hub.