Skip to main content
All CollectionsApps that automate content updates for your displaysBusiness intelligence
M365 Excel - Live and automated KPI dashboards and data from Microsoft Excel on digital signage
M365 Excel - Live and automated KPI dashboards and data from Microsoft Excel on digital signage

Share your KPIs automatically where you know everyone will see them.

Katariina avatar
Written by Katariina
Updated over a week ago

Connect your Digital Signage displays with Microsoft Excel to display live metrics and visualisations across organisations.

App main features

✔ Secure authentication with Entra ID credentials (previously known as Azure AD credentials)

✔ Excel files are easy to pick with OneDrive file picker

✔ Show either Excel Charts or Table data on the displays based on your settings

✔ Set the tab and the data range

✔ Set the data update interval

M365 Excel - Activate and use

Easiest way for activating a content App is from Valotalive Dashboard. Just click the icon of the content you wish to activate and proceed. More detailed info of the first steps can be found here:

Settings on the Apps' Configuration tab

  1. Theme:

    • The color palette from the file itself isn't provided to Valotalive.

      However, the look & feel can be adjusted by choosing (or creating) a theme.

    • Font Color - Is applied according to the Theme’s body text font color

      Tip: By embedding the Excel sheet /chart to a PowerPoint you can run contents with the chosen colors on displays.
      Further read: How to activate Valotalive PowerPoint app

  2. Authorize using OAuth2 Authorization

    Need admin approval?

    If you are prompted about needing admin approval read how to proceed from these articles:

  3. Choose the Excel file

    OneDrive file picker is accessible after authentication. This allows you to choose the right file to display.

    OneDrive File Picker

  4. What to visualize?

    1. Show only celldata

      Displays a scrolling view of the table. You can adjust the speed of the scroll with “Duration” - the duration of scrolling through the data once

    2. Show only graphs

      Choose this setting to display the graphs (the charts) in the particular file. The app automatically displays all graphs that can be found in the file.

    3. Show both graph and celldata

  5. Data range from the sheet

    Enter the data range you want to use. Default setting is A1:Z24 selecting 24 rows from the columns A to Z in the first visible sheet.

    Use A1 notation: [SheetName]![top left corner]:[bottom right corner]. Row numbers are mandatory. E.g. if you want to show contents on Sheet1 from cells A1:C10 type in Sheet1!A1:C10


    • All letters for data range need to be in CAPITAL letters.

    • Make sure the name of the sheet in the settings matches with the name on your Excel sheet. E.g. If it says Tabelle1 instead of Sheet1 in your Sheet, you have to put Tabelle1!A1:C10 instead of Sheet1!A1:C10.

  6. Cell border color TIP: If you have a light background (Theme settings) you should use darker color for cell borders

  7. Duration

    How many seconds should a post be visible.

Complete the work by adding the app to a flow or directly to a display.

The M365 Excel App will display the selected chart in its original size as an image and data updates are every 15 minutes.

You might also be interested in this article:

Did this answer your question?