ℹ️ Available on Premium and Supreme.
Connect Excel Online to Perdoo to update your goals from your spreadsheets. Link a KPI, Key Result, or Initiative to a cell, and Perdoo uses its value to update the goal.
Once connected, Perdoo updates the goal for you as often as its sync frequency says. For more about progress drivers, see Progress drivers.
Connect Excel Online
Find Excel Online and click Enable.
Click Connect. If your Microsoft admin needs to approve the app, submit the request.
Select your Microsoft account and accept the permissions request.
Click Finish.
Superadmins can also connect Excel Online in Configure > Integrations. After you connect it, click Settings (1) to choose whether your connection is private or shared with everyone.
Update a goal with Excel Online
Open the KPI, Key Result, or Initiative. To set it up while you add a goal, open Advanced options.
In the Details panel, click Progress driver.
Select Integration and choose Excel Online.
Select your Connection.
Select the File, Worksheet, and Cell.
Check the preview.
Click Save & Sync now.
Good to know
How often does Perdoo fetch the latest value?
As often as the goal's sync frequency says, for example daily or weekly. Every sync adds a progress update, even if the value hasn't changed. To update sooner, click Update on the goal.
What happens if the connection stops working?
You get an email, and the goal shows a red connection error. Reconnect Excel Online in Personal settings > Integrations.
Can others update a goal that uses my private connection?
Yes. Anyone who can update the goal can fetch the latest value, but only you can change the connection's settings.
Which files can I use?
Files that the connected Microsoft account owns, or that are shared with it with view or edit rights.
Need help?
Start a live chat with our Support team by clicking the question mark at the left or right bottom of your screen.


