1. Home
  2. Templates
  3. Business
  4. OKR tracker
Business template

OKR tracker

Set quarterly objectives with measurable key results and watch progress roll up. Scores use a 0 to 1 scale with traffic light icons.

  • Free
  • No account needed to try
  • Download as .xlsx
Preview of the OKR tracker template

What's inside

Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.

1 sheet
  • OKRs
39 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 116 filled cells in all.
Built in
  • Charts
  • Conditional formatting
  • Dropdowns
  • Live dates
  • Frozen headers
  • 1 chart

A look at the OKRs sheet

The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.

ABCDEFGH
1Team OKRs
2Update Current for each key result. Progress = (current minus start) / (target minus start), capped at 0 to 100%.
3QuarterQ4 2026Days left47
4
5
6ObjectiveKey resultsAvg progressGrade
7Delight new customers365%Fair
8Grow recurring revenue345%Fair
9Build a healthy team374%Strong
10All objectives961%
11
12Key results
  • okr
  • goals
  • objectives
  • quarterly
  • strategy

Start your okr tracker now

It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.