Skip to content
The title slide and first slides of the OKR Tracker template

OKR Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Style
Modern
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

The OKR Tracker helps a team set a few clear objectives for the quarter and measure each one through its key results. The Key results tab records the target, the current value, the dates and a confidence rating for each result. Progress is worked out automatically. The Dashboard shows how the key results are doing and the average progress for each objective.

It comes with sample data for four objectives across a quarter. Make a copy and replace the sample rows. The formulas, dropdowns and charts update on their own.

Useful for

  • Setting quarterly objectives for a team or company
  • Running a weekly check-in on key results
  • Showing leaders where progress is slipping

What's included

  • 3 tabs: Dashboard, Key results, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Key results: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Key results tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this OKR Tracker template free?

Yes. Make a copy in Google Sheets or download the .xlsx file for Excel. There is no charge for the template.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Excel. The formulas, dropdowns and charts work there as well as in Google Sheets.

How is progress calculated?

Progress is the current value divided by the target, capped at 100%. Enter the numbers and the percentage and the dashboard average update on their own.

  • #okr
  • #okr-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More okr review templates

See all 6

Also in Business operations

All business operations templates
Get this template

Preparing your template…