Recently, I conducted over 30 in depth interviews with our OKR clients and the number one pattern that emerged was that about 75% of companies were using spreadsheets before they gave up and switched to an automated tool for their OKRs.
So, if you are thinking about implementing OKRs, you should seriously consider if spreadsheets is the right OKR solution for you. You might end up wasting your precious time.
Here is what some of them had to say about implementing OKRs in spreadsheets:
- "Google spreadsheets were hard to use, hard to manage and people were checking it only at the end of the quarter"
- "Google sheets were too complex for OKRs"
- "It was hard to update and hard to follow"
- "We stopped using spreadsheets as often as I would've liked."
- "People were not engaged with the system and did not update their OKRs"
- "The central problem with spreadsheets were that it was a time consuming process that was difficult to manage and keep track of"
Check out some OKR case studies here.
Don't get me wrong, spreadsheets are a great tool for getting started and organizing your personal OKRs, but the number one problem with spreadsheets is implementation. Companies start using OKRs in order to get people engaged with their goals. In order to that, you need to make it as easy and comfortable as possible.
One of our clients Kaspar – CEO of Humanitec AG, illustrated the point very well: "It is sometimes difficult to convince people to use OKRs, so you want a solution that is extremely simple, intuitive and excellent to understand. Otherwise, people feel overwhelmed and face the daunting task of using yet another tool".
Let's be honest, the main reason why people start OKRs on spreadsheets is because it is free. While it is nice to see if OKRs are a good fit for your company, cheaper isn't always better. Moreover, most of the OKR softwares offer free trials anyway. If you are not convinced yet, here are the top 6 benefits people have pointed out about using an OKR software instead of spreadsheets.
1. You don't have to manually set up an OKR template.
With an OKR software you would have a pre-filled out template, where you can easily insert your objectives and 3-4 key results. In addition, you can add a custom measurement unit to any key result. Whether it is a percentage, numerical value or even currency.
2. You can link personal Objectives to team, department and company Objectives and get an OKR hierarchy view
In order, for people to understand how each team member plays a part in taking the whole company closer to its goals, OKR linking is essential. With an OKR tool you can easily link all of the OKRs in every level.
You can link individual objectives to team objectives, team objectives to department level and all the way up to the company level. That way everybody can have an instant view of everyone's goals and therefore increase the transparency and engagement.
"The clear benefit of Weekdone is that we are more aligned, structured, and people feel more connected." Kaspar von Grünberg – CEO of Humanitec AG Read more
3. Easy to follow and update OKR progress
That is one of the biggest pain points that get in the way of successful OKR implementation with spreadsheets. With an OKR tool you can update your OKR progress with one click. The system will instantly update the status of your OKRs and if the OKRs are linked to other levels, it will also change the progress of other OKRs.
Also, the changes made are instantly visible to everybody else. With a tool like Weekdone, everybody will get a notification in their newsfeed or OKR timeline and see that somebody made progress on their goals. With spreadsheets, it is harder to update your goals and the changes are not as easily seen as in an automated tool.
4. Visual dashboard where you can see how your OKRs are progressing and whether you are on track or not
In addition, to easily updating your OKRs, you will have your personal dashboard where you can see if your OKRs are on track, off track, at risk or you have exceeded your expectations. The same view is available for the Company, where you can see how you have progressed as an entire company. Also, see the team and personal progress. The view is illustrated with graphs, so the information could be instantly attainable and everybody would be accountable.
On the basis of everybody's progress you are able to make better decisions and adjustments how to move forward. Maybe somebody needs help with their OKRs, maybe some of the people need a 1:1 conversation etc. Unfortunately with spreadsheets this high level visibility doesn't exist and you are left with sorting through individual OKRs to see if they are on track.
5. You can comment and provide feedback on an individual Objective and Key Result
As mentioned in the previous point, it is great to have an overview how people are progressing with their OKRs and provide feedback. In an OKR tool, you can comment on a single Objective and an individual Key Result. You are able to provide feedback and offer advice to your team members.
6. You have OKR experts helping you out
Moving from spreadsheets to automated OKRs
OKRs are meant to align and engage people, but if this process is not made comfortable enough, there is a big chance that you won't be able to reap the full benefits of OKRs. For a successful implementation you need to create a habit of using OKRs regularly.Therefore, I urge you to evaluate your current situation with OKRs, whether you are starting off or are already using them in spreadsheets, and see if people would actually use it.
As I said, spreadsheets are great for getting started and kind of practising OKRs on your own. In case you are looking to do that, we have a free OKR Google spreadsheet and Google docs template for you.
In case, you are serious about implementing OKRs with your team, I would recommend to use a tool that takes away the pain of clunky spreadsheets and implement an automated OKR software, so you could start making real progress towards your team or company goals. Test it out for free here.
Below are all OKR related materials you might need to get started and also a guide how to move your OKRs from spreadsheets to automated OKRs:
- Step by step guide: From Spreadsheets to Automated OKRs: Transitioning OKR Platforms
- Guide: What are OKRs and How to Get Started? [Infographic]
- Free OKR ebook
- Employee Guide to Getting Started with OKRs
- OKR examples by job positions
- OKR templates and examples
- Weekdone Academy resources page with OKR examples and OKR templates
- How Google sets goals with OKR's
- Top 10 Questions Managers Have About OKR Goal Setting (Examples and Templates)
- OKR FAQ – Everything you've ever wanted to know about Objectives and Key Results