Skip to content
Displai Displai Displai Knowledge Base Hoopla Help Center

How-to · Hoopla

Display data tables from Excel Online in Hoopla

Show up to four columns from an Excel Online spreadsheet as a data table on your Hoopla screens, synced on a schedule you set.

KB-0296 Last verified

If you are using our Excel Online integration, you can use data from an Excel spreadsheet to show lists of information that are not necessarily related to users. For example, you may want to show a list of last month’s “Top 10 Opportunities”. Data Tables pull data directly from Google reports, and update on a regular schedule.

To configure a Data Table:

Section titled “To configure a Data Table:”

  1. In the Configure tab, click Excel Online Integration underIntegrationsin the left nav. Alternatively, click the Integrations tile and then Excel Online Integration tile.

  2. Click Add.

  3. Use the dropdown to select an Excel Spreadsheet to map into Hoopla, and then select a Sheet Tab.

  4. Optionally, change the report’s name in Hoopla.

  5. Select up to 4 columns from the report. The order in which you make your selections will determine the order on Hoopla TV, from left to right.

  6. Optionally, change each column’s label in Hoopla.

  7. Schedule how often you want Hoopla to sync with the Excel spreadsheet.

  8. Click OK, then Save.

Don’t forget to add it to the TV Channel that you want your data table displayed!

Section titled “Related articles”
  • 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.
  • What are Data Tables? Understand how data tables show list-style information that isn’t tied to users, and the four sources you can build one from.
  • Create a channel Create a channel, add steps such as metrics, posts and leaderboards, then assign it to teams and publish it to your TV displays.

Still having trouble?

Email our support team.

support@displai.ai