All Collections
Apps that automate content updates for your displays
Business 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

✔ Authenticate securely with Azure AD credentials

✔ Choose Your Excel file with ease using OneDrive file picker

✔ Your Excel application will display either your file’s Charts or Table data based on your settings

OneDrive File Picker

Secure authentication – choose your file from OneDrive App settings

✔ OneDrive file picker to choose your file

✔ Choose tab and set the data range

✔ Choose to show either the Charts in the file or the table data

✔ 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. Authorize using OAuth2 Authorization

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

    Need admin approval?

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

  2. Excel file

    Choose your excel file.

  3. 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

  4. 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

    IMPORTANT ! 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.

  5. Cell border color

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

  6. Duration

    How many seconds should a post be visible.

  7. SHOW ADVANCED

    1. Update interval in hours. Min 1, max 24

      How often Valotalive should fetch data from One Drive

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.

You might also be interested in this article:

Did this answer your question?