Looking for a way to track all of your OKRs in one place? Look no further.
This Google Sheets OKR template is as intuitive as it gets, simple to maintain, and easily accessible. Guide your teams towards excellent execution and learn how tracking the progress of your OKRs can have a tremendous impact on your daily work.
The best part? Our Google Sheets OKR tracking template can be used by every company or team of any size or shape. And it’s free!
However, before you start tracking OKRs in a template or software, make sure you have done your homework. Conduct a thorough planning session to uncover the most business-critical Objectives and Key Results.
Refresher: Objectives & Key Results
OKRs (Objectives and Key Results) are a collaborative way of setting and managing goals to create more transparency, alignment, focus, and ownership among teams. Objectives are inspiring goals that contribute to the business’s long-term success, while Key Results represent the outcome-driven checkpoints in achieving those goals.
The method has become popular through companies such as Google, LinkedIn, Spotify, or Slack, and is supporting companies of all sizes and shapes in selecting what they should focus on.
Read more about OKRs in our OKR guide.
We built this Google Sheets OKR template all-in-one, which means that you can track progress and review your OKRs in one place. Furthermore, you’ll get:
- Tips on how to make OKRs your primary success factor
- Team check-in guide
- Progress overview dashboard
- Integrated time progress tracker
- One company and five team OKR tracking sheets
- OKR examples
How to use the Google Sheets OKR template
1. Get the free template
Open the tracking template in Google Sheets. To edit it, copy it to your company or team’s Google Drive. A Google account is therefore needed to use this template. If you do not have one, feel free to download the template as an Excel file.
2. Sharing the Google Sheets OKR tracking template
OKRs only work collaboratively. To share it with all team members involved, click on the green button that says “Share” in the top-right corner.
Then, add the contact information and make sure that the permission is set to “edit” so that everyone can adjust the information in the sheet. If you want more control over the template, share the document by selecting the permission “view.”
3. Getting started
As soon as you open the file, the first “Getting Started” tab will guide you through the features of the OKR tracking template and where to find them. Also, it will tell you where to put which information. Furthermore, you can find helpful resources and links around OKRs here.
4. OKR dashboard overview
The second tab is the dashboard and works as your compass to navigate through the overall progress.
To integrate OKRs into your daily work, regular progress reviews are crucial. It is the regularity that makes the OKR method successful in the long term. Thus, the OKR Check-in tab contains a guide for you and your team to transform weekly check-ins into a habit.
6. Adding cycle information
Before you add your Objectives and Key Results, the active cycle needs to be adjusted at the top of each OKR sheet. From here, the sheets will automatically calculate the remaining time of the cycle and synchronize the dashboard.
7. Setting company and team OKRs
Most commonly, OKRs are set top-down first, then bottom-up, which means that the leadership level defines the company OKRs first, followed by teams (or departments). If your OKRs are already defined, first add the team names at the top of each sheet, then fill in your Objectives and Key Results.
For inspiration, you can find examples for company and team OKRs in the sheet tabs 5 and 7, which are indicated with “EXAMPLE.”
8. Adding supporting information
To update start and target values, adjust the information in columns H and I. To calculate the progress of your Key Results, adjust the current value in cell J. Overall progress will be displayed at the top of each team sheet, and in the dashboard. Update the current value at least once a week.
Optionally, you can fill in additional information for your OKRs, such as:
- Metric: What is the metric or unit of the respective Key Result?
- Confidence Level: How confident are you that you will reach the Key Result at the end of the OKR cycle?
- Owner: Who owns the Key Result?
8. Final check
- Are all teams included?
- Are the Objectives big and aspirational?
- Do the KRs feel ambitious yet achievable?
- Are the KRs easy to measure and actual results, not tasks, projects, or simply KPIs?
- Do the objectives reach the right level of motivational discomfort (50% – 70% confidence)?
- Is the dashboard displaying every piece of information correctly and in the right time frame?
- Is a proper check-in routine already in place?