OKR tracking template in Microsoft Excel (2023)

Many organizations use Objectives and Key Results (OKRs) for setting objectives or goals and measuring performance.

Developed originally byAndy Grovein the 70s, the method saw a rise in popularity after being adopted by tech giant Google. The OKR framework is arguably one of the catalysts that helped Google grow to its current size.

Meanwhile, the OKR framework has been adopted by many other fast-rising companies in the technology sector such as LinkedIn, Twitter, Dropbox, Spotify, and Uber.

What do OKRs actually mean for companies?

Every organization benefits from having clearly defined goals and metrics. This is where OKRs come in to help companies plan and evaluate organizational performance.

First, set clearly defined goals throughout the entire organization. Then, track the progress made towards completion to make sure these goals are being achieved.

The OKR method is designed to help teams:

  • Align targets across the entire organization
  • Set goals at the individual, team and company level
  • Reach ambitious milestones quickly
  • Encourage innovation

Is there a difference between KPIs and OKRs?

Both KPIs and OKRs are performance measurement tools. However, KPIs and OKRs are not the same things. KPIs (Key Progress Indicators) focus on reporting results. In contrast, OKRs are goal-oriented. Besides, OKRs are more specific and have results that can be measured in a numerical format.

Another difference is the time span. Once KPIs are set, they usually remain the same for an extended period of time. In contrast, OKR’s are more short-term focused. As such, they track progress over a defined time period: usually a business quarter.

(Video) OKR template Excel (plan and track Objectives & Key Results)

How can organizations track OKRs?

As mentioned before, the OKR framework is popular amongst tech companies in Silicon Valley. However, not only the tech giants benefit from using OKRs. Any company that works in a fast-paced business environment will find OKRs useful to achieve specific goals in short timeframes.

While many tools exist to help organizations manage their performance, there is no real need to invest heavily in expensive specialist software. Instead, create an effective OKR tracking system using anOKR templatein Microsoft Excel.

Why use Excel to track OKRs?

  • Flexibility:Excel spreadsheets can be modified and changed according to your organization’s needs and requirements. As such, there is no need for complicated software solutions or putting pressure on your IT department to build a customized system.
  • Accessibility:Whether you are working from a tablet, a desktop, laptop, or smartphone, managers and employees always have access to the workflow.
  • Compatibility:Microsoft Excel is easily compatible with other software that your organization might be using. Therefore, any related company data you already have is easily imported into Excel spreadsheets.
  • Ease of use:Many employees are familiar with spreadsheets and if they are not, it is easy to train them. Indeed, using an Excel-based template is ideal for beginners and advanced users alike.

OKR tracking template in Microsoft Excel (1)

What is an Excel-based workflow template?

Sheetgo’s Company OKR template provides you with a complete system. The template workflow consists of separate Excel spreadsheets. These spreadsheets exchange data between them through Sheetgo connections.

Each employee manages their work privately. Besides, they can easily share their data with others in a few clicks. Consequently, companies are not bothered by slow spreadsheet loading because multiple people are working in the same file. Additionally, your data will remain private and secure.

Different teams submit different requests in their separate spreadsheets. The manager checks all sent requests and additional information in the master sheet.

In summary, an Excel-based workflow provides companies with outstanding organization, data privacy, scalability, and integration.

What you get with the OKR template in Microsoft Excel

When you install the Sheetgo OKR template, 7 Microsoft Excel files with pre-built Sheetgo connections are saved to your preferred cloud-based account:

  • SixDepartmentspreadsheets in a folder. Rename and share these files with each team and make as many copies as you need for additional departments. The team uses their file to set their objectives and key results and to update their progress individually.
  • OneCompany OKRsmaster sheet for the manager(s). Data flows into this file from the Department spreadsheets, providing an overview of all Team Objectives and Key Results in tables and dashboard charts.

OKR tracking template in Microsoft Excel (2)

(Video) DYNAMIC Objectives and Key Results Easy to Use Excel Template Tutorial

How to install the Company OKR template

  1. Clickhereto install the template.
  2. Log in to Sheetgo with your Microsoft account. As this template is based in Microsoft Excel, the files will be saved to your Onedrive or Sharepoint account.
  3. ClickInstall on Onedriveor choose your preferred platform from the drop down list.
  4. Please allow a few moments as Sheetgo creates the connections and saves a copy of the template files to your chosen account.

OKR tracking template in Microsoft Excel (3)

Company OKRs template

OKR tracking template in Microsoft Excel (4)

Google Sheets workflow template to track individuals' OKRs and progress per department.


Step 1: Share the department sheets

First open theDepartmentfiles by double-clicking one of them in your main workflow. A new tab will open in OneDrive or your chosen cloud-based account. Here, you can find the different departments.

Next, select the relevantDepartmentand clickShare. Rename each department for the ones in your company. If you prefer working in Excel, simply clickOpen Desktop Appafter opening a file.

OKR tracking template in Microsoft Excel (5)

Step 2: Teams set their OKRs

The first step for each team is to agree on their objectives. Afterwards, enter these objectives into theTeam Objectivestab.

(Video) OKR Excel Template vs OKR Software

Make sure that you give each objective a clearly distinguishable title to avoid confusion when allocating key results to each objective.

Keep in mind that objectives are not the same as goals. Goals represent a destination while objectives are milestones on the way to that destination.

Besides that, ensure that your objectives are S.M.A.R.T., that is to say: specific, measurable, attainable, realistic, and time-bound.

OKR tracking template in Microsoft Excel (6)

Step 3: Teams set their Key Results

  1. In theKey Resultstab, choose anObjectivefrom the dropdown menu and enter how you will achieve that goal inColumn B: Key Result. Remember that key results must be measurable.
  2. Now type the name of the colleague responsible inColumn C: Owner.
  3. Then enter aMetricinColumn D.
  4. Finally, enter aStart ValueandTargetinColumns E and F.

The sample data contains some insight on what these values can look like.

OKR tracking template in Microsoft Excel (7)

Step 4: Teams log OKRs

At this point, your colleagues are entering the progress towards their OKRs and have to fill outColumn G: Current Valuein theKey Resultstab.

Step 5: Transfer the data

Once the template is set up and in use, it’s time to pull the departmental OKR data into the master sheet.

To let the data flow into the master sheet, update your Sheetgo connections. Go back to the tab with your main workflow and then clickRun.

OKR tracking template in Microsoft Excel (8)

Data now flows directly from the department files into the master sheet and dashboard.

Check how all employees are progressing in theKey Results tab.

(Video) FREE DOWNLOAD - OKR Templates, Excel / Google Sheets

Step 6: Automate your workflow

Data is regularly transferred, especially in busy companies that are growing rapidly.

Automation ensures you always have the latest OKR data from every department in your master sheet and dashboard.

Open the main workflow again and instead ofRun, clickAutomatein the menu bar.

OKR tracking template in Microsoft Excel (9)

Choose your preferred transfer schedule and clickSaveto finish.

Check the usage summary at the bottom of theSchedule settingsto get an idea of how many transfers you will be running per month.

How to add more departments

To add more department spreadsheets to your OKR tracking system, simply copy one of the department spreadsheets and add them to the same folder (namedSheetgo Templates>Company OKRs template) in your Drive storage.

Next time Sheetgo runs the workflow, the data from the new department spreadsheet will be included.


Your automated OKR template in Excel is now up and running.

If you are looking for more workflow templates, check out the post on Sheetgo’sEmployee timesheet template in Excel.

Did you like this post?

If you enjoyed reading this post, share it with your friends and colleagues. And don’t forget to take a look at the related articles below.

(Video) OKRs Planning with a Spreadsheet


How do I create a workload tracker in Excel? ›

Here are the steps involved in creating an effective workload management template in Excel:
  1. Determine your team's current workload and capacity. ...
  2. Create an "assignee" column. ...
  3. Create a "project title" column. ...
  4. Create a "project span" column. ...
  5. Create a "project status" column. ...
  6. Create an "optimum work time" column.
Aug 29, 2022

What is the difference between KPI and OKR? ›

KPIs are used to measure performance but they don't tell you what needs to change or improve to drive the growth of those numbers. OKR is a quarterly goal-setting method that helps businesses improve performance and drive change. OKRs are used to decide what needs to be changed, fixed, or improved.

How does Microsoft use OKRs? ›

OKRs create cross-functional cooperation to unify direction and improve collaboration. When each individual, team, and department goal are aligned to the company's broader strategy, teams have a lens through which their work, and the impact it's intended to have, is prioritized.

Is OKR a replacement for KPI? ›

OKR is a strategic framework, whereas KPIs are measurements that exist within a framework. OKR is a simplistic, black-and-white approach that uses specific metrics to track the achievement of a goal. Typically, an organization will have three to five high-level objectives and three to five key results per objective.

What is an OKR template? ›

What is an OKR Template? OKR (Objectives and Key Results) templates work as a performance management system to provide a framework for setting team objectives and tracking results.

How do I create a tracking database in Excel? ›

How to Create a Database in Excel
  1. Step 1: Set up a data spreadsheet framework. Open an Excel spreadsheet, place your cursor in the A1 cell, and type in your database title. ...
  2. Step 2: Add or import data. ...
  3. Step 3: Convert your data into a table. ...
  4. Step 4: Format the table. ...
  5. Step 5: Save your database spreadsheet.
Sep 12, 2022

How do I create a project tracker in Excel? ›

Learn step-by-step
  1. Log into Microsoft Excel Online and open a blank spreadsheet.
  2. Share a document in Microsoft Excel and organize the sections of the tracker.
  3. Use project management skills to develop a project tracking spreadsheet.
  4. Add static content and drop-down menus to the project tracker.

How do I create a task tracker in sheets? ›

Create a project plan in Sheets
  1. In Google Drive, click New Google Sheets. Blank spreadsheet.
  2. Click Untitled spreadsheet and enter a title for your project plan.
  3. Add columns. For example, you might add columns for tasks, task owners, due dates, status, and comments.
  4. Add content to track the tasks in your project.

What is the OKR formula? ›

John Doerr's OKR formula is to set an objective, which is “what I want to have accomplished,” and the key results, which are “how I'm going to get it done.” Thus, with OKR, a goal isn't just what you want to achieve; it must include a way to measure achievement.

What is a great example of OKR? ›

Top company objectives—OKR examples

Hit company global sales target of $100 Million in Sales. Achieve 100% year-to-year sales growth in the EMEA geography. Increase the company average deal size by 30% (with upsells) Reduce churn to less than 5% annually (via Customer Success)

Does Google still use OKRs? ›

Everyone works together to ensure that their company is on track in terms of hitting their targets. Google does OKRs yearly. Annual OKRs are the umbrella objectives where the rest of the individual and team OKRs can be patterned from.

What are the 2 components of OKR? ›

OKRs have two important parts: The objective you want to achieve and the key results, which are the way you measure achieving the objective.

What are the three parts of OKR? ›

OKR Methodology Overview

OKRs consist of an objective, a clearly defined goal, and key results, which measure progress toward achieving the defined goal.

What are the two types of OKRs? ›

There are two types of OKRs goal: committed OKRs and aspirational OKRs. Both committed and aspirational OKRs define different purposes and have separate methods to achieve them. If you are someone new to OKRs (Objectives and Key Results), this information can be overwhelming.

What is a doughnut chart in Excel? ›

Just like a pie chart, a doughnut chart shows the relationship of parts to a whole, but a doughnut chart can contain more than one data series. Each data series that you plot in a doughnut chart adds a ring to the chart. The first data series is displayed in the center of the chart.

How do I create a spin button in Excel? ›

Add a spin button (ActiveX control)
  1. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click Spin Button .
  2. Click the worksheet location where you want the upper-left corner of the spin button to appear.
  3. To edit the control, make sure that you are in design mode.

What is dashboard reporting in Excel? ›

What Is an Excel Dashboard? The Excel Dashboard provides an overview of metrics and other data points in one place. In simple terms, dashboards are visual representations of data. They mostly consist of charts and graphs, thereby grabbing the user's attention. Looking at raw Excel data can be boring.

Why not use OKR? ›

OKRs work only when everyone from the top gets involved in the system. The team has to align from top to bottom. It will be challenging to perform. The top-level can't just design OKRs and implement them and then forget about it.

How does Google manage OKRs? ›

How Does Google Grade OKRs? Since OKRs are big, ambitious goals, at Google, they don't expect to reach them all, as this will mean that the goals haven't been ambitious enough. Google grades them with a color scale to measure how well they did. A grade of 0.6 to 0.7 is considered the best target.

What are the 5 benefits of OKRs? ›

OKR's five key benefits include focus, alignment, commitment, tracking, and stretching — or as John Doerr likes to call them, “the five superpowers” of OKRs.

Can you use KPIs and OKRs together? ›

How do OKRs and KPIs work together? While KPIs measure ongoing performance and operational efficiency, OKRs set strategic goals for the future. KPIs can feed into OKRs, providing measurable results for objective progress. Together, they can give a complete picture of the company's health and future direction.

What is the difference between OKR and KPI vs smart? ›

KPIs are just all numbers. SMART goals may be inspiring, and they have numbers. OKRs offer something for people who aren't numbers-driven."

Why OKRs should not be used for performance evaluation? ›

Using OKRs to control, not innovate

An employee sees their OKRs alongside their performance reviews and starts to draw conclusions. This kills engagement and productivity, but also stifles the learning, risk-taking, and creative cultures that your OKR program needs to succeed.

What is an OKR dashboard? ›

What is an OKR dashboard? OKR dashboards track progress against a type of goal-setting methodology known as OKRs. OKR stands for Objectives and Key Results. OKRs are popular with organizations who favor an agile-style approach to work, perhaps most famously, Google.

How do you write a successful OKR? ›

An OKR best practice is to write three to five objectives for each group — company, team, and individual –– each of which should come with two to four key results. “For me, three is the magic number [of objectives], and sometimes you'll end up with a fourth,” Shalabi said.

Can you do tracking in Excel? ›

Click Review > Track Changes, and then click Highlight Changes. Note that in newer versions of Excel, the Track Changes button has been hidden. Here's how to unhide it. In the Highlight Changes dialog box, select the Track changes while editing check box.

Can MS Excel be used as a database? ›

Even though Excel is not a database, it is widely used to store data, and it is often used to solve simple database problems. However, Excel is a flat file database, not a relational database.

Does Excel have a time tracking template? ›

An Excel timesheet template is a spreadsheet that businesses use to track employee hours and manage their payrolls. These templates allow employees to enter total hours and calculate pay easily, and are also organized and editable to suit your needs.

Where do I find Excel templates? ›

Go to Create.Microsoft.com. Click Templates at the top of the page. On the Templates page, click Excel. Tip: To see more templates, under BROWSE BY CATEGORY, click the category (like Calendars) that you want to see.

How do business analyst use Excel? ›

The following are some of the most important features of Excel that Business Analysts use:
  1. Working with IF formulas. ...
  2. Using VLOOKUP. ...
  3. Extracting clarity from clutter. ...
  4. Uncovering data patterns. ...
  5. Documenting spreadsheet systems. ...
  6. Using PivotTables. ...
  7. Visualizing data. ...
  8. Understanding industry-relevant Excel features.
Jun 3, 2022

How do I create a workload tracker? ›

9 steps for creating a workload management template
  1. List the team's projects. ...
  2. Determine the team's capacity. ...
  3. Open a spreadsheet program. ...
  4. Create a project row. ...
  5. Designate the project effort. ...
  6. Assign a row for project status. ...
  7. Highlight peak work time. ...
  8. Check in with team members.
Feb 3, 2023

How do I create a task tracker in Microsoft teams? ›

Contact us
  1. Open Microsoft Teams (free). ...
  2. Go to the one-on-one or group chat where you want to create a task list.
  3. Select the Add a tab. ...
  4. Select Tasks.
  5. Type the name of the new task list in the Tab name field and select Save.
  6. Add tasks by entering them in the New task field and pressing the Enter key.

What is the 3 * 5 principle in OKRs? ›

A typical OKR is made up of 3 to 5 high-level objectives, under which 3-5 key measurable results are listed. The said key results are measurable through a defined set of indicators or scores (usually between 0 and 1.0. The use of quantitative indicators allows an organization to check or measure progress.

What is the ideal number of OKRs? ›

We typically recommend setting a maximum of 3-5 OKRs per team per quarter. This is a maximum, not a minimum – it's perfectly appropriate to have only 1-2 OKRs. What matters most is that you don't pick a number and then let that dictate how many goals you need to achieve within the given timeframe.

What are the five recommended categories for OKRs? ›

OKRs provide your business with five important elements: focus, accountability, engagement, transparency and visibility.

What is an example of a bad OKR? ›

Some more examples
Well-Written OKRsPoor-Written OKRs
Objective: Reduce energy consumption by 20%Objective: Save energy
Key Result: Implement energy-efficient lighting in all facilitiesKey Result: Change the lights
Key Result: Increase the percentage of renewable energy used by 25%Key Result: Use clean energy
2 more rows

How do I track my key results? ›

How to track OKRs.
  1. Write qualitative Objectives and quantitative Key Results. ...
  2. Assign percentage benchmarks for each Key Result. ...
  3. Set responsibilities and accountability for Key Results. ...
  4. Share OKRs with your team. ...
  5. Track results on a regular schedule (with calendar reminders). ...
  6. Discuss key learnings along the way.
Mar 18, 2022

What software does Google use to track OKRs? ›

Google Docs or Google Sheets

From the company that was built on OKRs, it's not surprising that Google provides powerful, free tools to track them. Utilizing Google Docs or Google Sheets is a simple and easily accessible way to track your goals. The WhatMatters.com has made a template for both.

Does Netflix use OKR? ›

Many major tech companies, such as the aforementioned plus Microsoft, Twitter and even Netflix, use the OKRs framework to set and track goals within their business.

What is the difference between goals and OKRs? ›

Goals are the kind of long-term strategy or guideline. They explain what you want to achieve in your organization, and they are usually long-term and global. OKRs are short-term goals (often created quarterly) that are split into two parts: an Objective (the “what”) and Key Results (the “how”).

How do I create a dashboard in a spreadsheet? ›

To create a dashboard in Sheets, follow these steps:
  1. Collect your data. Input the data you want to summarize within a spreadsheet. ...
  2. Create a chart. ...
  3. Insert a new tab. ...
  4. Copy your chart. ...
  5. Add more charts. ...
  6. Format your dashboard.
Feb 3, 2023

How do I create a dashboard in Excel from multiple sheets? ›

First, select the Insert menu select the 2D Area chart. In the Chart Design menu, from the Data group, select Select Data. In the Select Data Source window that pops up, click the Chart data range field, and then select the cells in the data spreadsheet you'd like to display with this line chart.

How do I create a dynamic and interactive dashboard in Excel? ›

How to Create an Interactive Excel Dashboard
  1. Organize Your Source Data and Create a Layout. ...
  2. Build PivotTables to Organize Your Data. ...
  3. Apply Appropriate Formulae. ...
  4. Use Visual Elements, Charts, and Graphs. ...
  5. Add Interactive Settings and Tabs.
Sep 21, 2022

Does Excel have dashboard templates? ›

Excel dashboard templates are a type of information management tool that you can use to visually monitor, analyze then display: Key Performance Indications or KPIs. Key data points and metrics that monitor the health of your business, its departments, or a certain process.

Does Excel have a dashboard function? ›

The Excel Dashboard provides an overview of metrics and other data points in one place. In simple terms, dashboards are visual representations of data. They mostly consist of charts and graphs, thereby grabbing the user's attention. Looking at raw Excel data can be boring.

Can you make an interactive dashboard in Excel? ›

To create an interactive dashboard in Excel, you first need to create interactive charts. To do so, you first have to convert your data into a Pivot table. These pivot tables will then be used to create interactive charts which will then go on the Excel dashboard.

What specific features in Excel are most used to create an Excel dashboard Why? ›

Excel Features to Create Dashboards
  • Excel Tables. The most important component of any dashboard is its data. ...
  • Sparklines. ...
  • Conditional Formatting. ...
  • Excel Charts. ...
  • Excel PivotTables. ...
  • Dynamic Dashboard Elements with Interactive Controls. ...
  • Excel Power PivotTables and Power PivotCharts. ...
  • Excel Power View Reports.

What is pivot in Excel? ›

A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.

How do I make my Excel dashboard fit on one page? ›

Shrink a worksheet to fit on one page

Select the Page tab in the Page Setup dialog box. Select Fit to under Scaling. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. Note: Excel will shrink your data to fit on the number of pages specified.

How do I create a dashboard in Excel using slicers and timeline? ›

Create an Excel Dashboard in 8 Simple Steps
  1. Start with a Clean Dataset.
  2. Format data as a Table.
  3. Create the first Pivot table and Pivot Charts.
  4. Create Multiple Pivot table and Pivot Charts for other variables.
  5. Assemble the Excel dashboard.
  6. Add Slicers & Timelines.
  7. Connect Slicers to data.
  8. Update the Excel Dashboard.
Jul 8, 2020

How do I create a dynamic dashboard? ›

Create A Dynamic Dashboard In Salesforce
  1. Go to reports, click on new and select cases as report type.
  2. Select filter as MY cases and all time and open equals to true.
  3. Add grouping by Status.
Mar 7, 2022


1. OKR (Objectives and Key Results) Template
(Tim Demoures)
2. How to Track the Recruiting Process in Microsoft Excel : MS Word & Excel
3. Template Tutorial OKR - Overview (strategic planning / goal management)
4. What are the Best Free Tools to Track OKRs (objectives and key results)
(What Matters)
5. OKR Dashboard
(MAQ Software)
6. 12 Week Year - Free Goal Tracking Template
(Hook Agency)


Top Articles
Latest Posts
Article information

Author: Dan Stracke

Last Updated: 08/13/2023

Views: 5511

Rating: 4.2 / 5 (63 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Dan Stracke

Birthday: 1992-08-25

Address: 2253 Brown Springs, East Alla, OH 38634-0309

Phone: +398735162064

Job: Investor Government Associate

Hobby: Shopping, LARPing, Scrapbooking, Surfing, Slacklining, Dance, Glassblowing

Introduction: My name is Dan Stracke, I am a homely, gleaming, glamorous, inquisitive, homely, gorgeous, light person who loves writing and wants to share my knowledge and understanding with you.