Skip to main content

How to Display Live Excel Data on Digital Signage

Connect Microsoft 365 Excel to your Valotalive displays to show live metrics, charts, and KPI dashboards across your organization. Data updates automatically every 15 minutes.

Written by Leonie

M365 Excel – Live KPI dashboards on digital signage

Key Features

✔ Secure authentication with Entra ID credentials

✔ Display Excel charts, table data, or both

✔ Specify the exact sheet and data range to show

✔ Supports a wide range of Excel formatting — see below

Example of the Valotalive Excel app for Digital Signage

Supported Excel Formatting

Feature

Description

Conditional formatting

Color-code cells based on their values to reveal trends

Fill color

Change cell, row, or column background colors

Color scales

Apply gradient colors to represent data distribution

Table format

Display styled Excel tables with built-in formatting

Font color

Customize text color within cells

Border color

Change cell border colors to organize data visually

Cell style

Apply predefined formatting for consistent presentation

Prerequisites

  • An active Microsoft 365 account with access to Excel files stored in OneDrive or SharePoint

How to activate the M365 Excel App

  1. Go to the Valotalive Dashboard and click New App

  2. Find the M365 Excel App and click Create New

👉 For a full activation walkthrough, see: Valotalive content App – Activate and go live

Configuration

  1. Theme

    Select a theme to set the background color. All other colors are sourced directly from your Excel file.

  2. Authorize with OAuth2

    Authenticate Valotalive with your Microsoft account.

    Authorizing the Excel app using OAuth2 and your Microsoft 365 credentials.

    If prompted with "Need admin approval?", see:

  3. Select your Excel file

    Use the file picker to select the Excel file you want to display.

    Selecting an Excel file using the file picker.

    Excel File Picker2

  4. Choose What to Display

    • Show only cell data – Displays a scrolling view of your table data. The Duration setting controls how long it takes to scroll through the data once.

    • Show only graphs – Automatically displays all charts found in the Excel file.

    • Show both graphs and cell data – Displays charts and table data together.

      Valotalive Excel app - what to show on Digital Signage screens?

  5. Set the Data Range

    Specify the data range. Use A1 notation: [SheetName]![top left corner]:[bottom right corner]. Default range: A1:Z24 (first 24 rows of the first visible sheet)

    Example: To show cells A1 to C10 on a sheet named Sheet1, enter Sheet1!A1:C10

    ⚠️ Important:

    • All column letters must be in capitals

    • The sheet name in the settings must exactly match the name in your Excel file. For example, if your sheet is named Tabelle1, use Tabelle1!A1:C10 — not Sheet1!A1:C10

  6. Cell border color

    If your theme has a light background, select a darker border color for better visibility.

  7. Duration

    Set how many seconds each page or data view is displayed on screen.​

Next steps

Related Articles

Related Articles
Did this answer your question?