1. Betterworks
  2. Betterworks
  3. NextGen

Microsoft Excel 365 Integration (NextGen)

Note: The following article shows the NextGen user interface. If the steps and/or screenshots do not match what you see in your organization's Betterworks instance, try this article that shows the same feature in the Classic user interface. 

Contents

Overview

The Microsoft Excel 365 integration allows users to connect the progress of their Betterworks milestones to a defined cell in a workbook. When a user updates the cell, the progress of the associated milestone will automatically update as well. 

Note: The integration will only connect to workbooks that are stored in Microsoft Sharepoint or OneDrive for Business. The integration does not apply to personal accounts. 

Integration Benefits

  • Time-saving automation
  • Easy data import for streamlined performance tracking
  • Increased accuracy by reducing the risk of errors in manual data entry
  • Improved collaboration between team members through shared workbooks

Configuration (Administrators)

Note: You must be a Super Admin to set up the integration. 

  1. Access the Third-party page.
    • Click Admin on the top banner menu.
    • Select the Program Configuration header from the left panel.
    • Select Integrations.
    • Select the Third-party tab. 
  2. Scroll down to Microsoft Excel 365 and expand the section. 


     
  3. Click the toggle to Enable the integration. 



     
  4. Access Microsoft Excel 365. 
    • Click Goals on the top banner menu.
    • Click Create Goal on the Goals page.
    • Enter a goal. 
    • Click into the milestone field.
    • Click the Microsoft Excel 365 icon under Integration on the right panel. 
       
  5. Click Sign in with your Microsoft Office Account.
     
  6. Enter your credentials. 
     
  7. Grant approval.

    Note: The integration requires approval from you as your organization's Microsoft administrator. This is because it does not currently have Microsoft Publisher verification. However, the integration is safe to use. Once you've granted approval, the pop-up will disappear. The pop-up will not display for any users who access the integration after this.  

Permissions

The permissions used by this integration are as follows:

  • user.read: Grants permission to read the profile of the signed-in user.
  • files.read.all: Allows Betterworks to read all files the signed-in user can access.
  • offline_access: Allows Betterworks to read and update user data, even when they are not using the application.

Connecting Milestones (Users)

Once the integration has been set up, any user in the organization can use it.

  1. Access Microsoft Excel 365. 
    • Click Goals on the top banner menu.
    • Click Create Goal on the Goals page.
    • Enter a goal. 
    • Click into the milestone field.
    • Click the Microsoft Excel 365 icon under Integration on the right panel. 
       
  2. Click Sign in with Microsoft.
     
  3. Enter your credentials. 


     
  4. Select the workbook and cell. 
     

Note: It is possible to connect multiple milestones to the same workbook.

Data Sync

  • Automatic Sync: The Betterworks integration captures data from and automatically updates the progress of your milestones at the top of every hour (2 PM, 3 PM, etc.). Therefore, if you make a change in the workbook at 2:15 PM, our application will check at 3 PM and make the update to progress in Betterworks at that time.
  • Manual Sync: You can manually sync the progress on your milestones by going to Goals → My Goals, selecting the relevant goal, clicking on its corresponding milestone, and opening the right-side panel. From there, click the three horizontal dots and select "Sync" from the drop-down menu to update the progress. This will take a few minutes. 

Troubleshooting

  1. Ensure that the data starts in row 1. Otherwise, the integration will return data from a cell whose row equals the row that you selected plus the rows that were skipped (i.e. if you select a cell in row 8, but have two empty rows at the top of your workbook, the integration will return data from a cell in row 10).
  2. A milestone will not update if linked to a cell that contains text, as the Betterworks application only supports numerical data, not text. Once the data in the sheet is changed from text to numerical, the milestone will need to be re-linked.
  3. Only cells containing integers will sync. Other characters (i.e. "$" or "%") will not be recognized.
  4. Ensure that the value has not been moved. The Betterworks application will track the value in the cell, but if the workbook is edited and the selected value is moved to a different cell, the associated milestone will need to be updated manually.
  5. If progress is not updating, check if progress locking is on. Progress locking is a sub-set of goal locking and extends to milestones connected to third-party applications via our integrations.
  6. If you cannot access the integration at all and you've confirmed that your administrator has approved it, your client secret (internal application password) may have expired. Please contact support@betterworks.com if you suspect this is the case.

FAQs

How long does it take for progress made in my Excel workbook to be reflected in Betterworks?

Our application checks for updates from MS Excel 365 at the top of every hour (2 pm, 3 pm, etc.). Therefore, if you make a change in the workbook at 2:15 pm, our application will check at 3 pm and make the update to progress in Betterworks at that time.