Sync team membership with Excel

You have the option of configuring Hoopla to sync Team Membership information for each user who appears in the Hoopla Mapped sheet tab in your Excel Sheet. In a separate sheet tab, you can use that Team Membership information to calculate Team Metric values based on Player values that you already have in Hoopla. Once you have Team Metric values, you can map them back into Hoopla and use them on Leaderboards!

How to Enable Team Membership Syncing

1. In Configuration, click on the Excel Online tile and either add a new Excel Online mapping or edit your existing one.

2. Under the Hoopla → Excel mappings section, there is a link to “Show team membership syncing”. Click the link to reveal the setting.

3. Toggle the switch to “ON” if you want to start syncing team membership to your spreadsheet.

4. Click OK and Save.

Check out these articles on mapping metrics from Hoopla → Excel, and from Excel → Hoopla.

How Team Membership Syncing Works

Each time Hoopla syncs with your Excel Sheet, each user’s Team Membership will update along with any updated Metric values that you’re syncing to the Hoopla Mapped sheet tab. The column called “Team Membership” will always show the list of current Teams that the user belongs to. The Team names are separated by the “|” character so that you can reliably calculate Team Metric values on other sheet tabs within your spreadsheet.

Related articles

• Map Hoopla data to Excel Online Export Hoopla metric data to the Hoopla Mapped tab of an Excel Online workbook on a schedule for calculations, reporting, or analysis.
• Map data from Excel Online to Hoopla metrics Automatically update Hoopla player or team metrics from an Excel Online workbook by mapping sheet columns to metrics on a sync schedule.
• Connect Hoopla to Excel Online Connect Hoopla to your Business Office 365 account so you can export metric data to Excel Online and import processed data back.