In Comeen, data sources allow you to display dynamic content inside your templates. By connecting an Excel file, your screens can automatically update whenever your data changes.
This guide explains how to:
Create an Excel data source
Connect this data source to a template
Prerequisites
Before getting started, make sure that:
Your Excel file is accessible online (e.g. OneDrive)
Your data is properly structured (one row = one entry, clear columns)
The first row contains column headers
1. Create an Excel data source
A data source allows you to import external data into Comeen and use it in your templates.
Steps
Go to the Data Sources section
Click on New data source
Select the appropriate account to retrieve your Excel file
Pick your Excel file from OneDrive
Fill in the required information:
Name of the data source
Icon and color (optional)
Update frequency (every 10 minutes by default)
Select the Worksheet.
Select each column type; the following column types are available:
Text
Date
Date and time
Numeric
Boolean
URL
HTML
Click Save
Your data source is now ready for use.
2. Prepare your data for the template
Before connecting your template, make sure your data is clean and structured.
One column = one type of data (title, image, link, etc.)
One row = one item to display
Avoid merged cells
Use simple formats (text, URLs, date)
3. Connect a template to the data source
Once your Excel data source is created, you can use it inside your templates to display dynamic content.
Step 1: Prepare your template
Open the Designer
Add elements (text, image, QR code, etc.)
Step 2: Bind your data
Select an element in your template
In the right panel, open the Data Source tab
Select your Excel data source
Map the columns to your template elements
Example:
Column A (Title) → Text field
Column B (Link) → QR code
Column C (Image) → Image
Column D (Category) → Text
Each element can be connected to a specific column from your Excel file.
Step 3: Handle multiple rows (pagination)
You can display multiple entries from your Excel file:
Row 1 → Page 1
Row 2 → Page 2
etc.
Select an element and enable pagination to automatically rotate through your data within the template once added to a playlist.
4. Add your template to a playlist
Once your template is ready:
Define the number of pages to display
Each page will correspond to a row in your Excel file
Your content will automatically update based on your data.
Result
Your template is now connected to your Excel file:
Data updates automatically
Content adapts dynamically
You can manage displays at scale easily
Best practices
Regularly check your Excel file structure
Use clear and consistent column names
Test your template with multiple rows
Use Data Views to filter or organize your data if needed