Skip to main content

Export Displays to CSV

Download your filtered list of screens as a CSV file, then edit it and import it again to update your displays in bulk.

To audit a fleet of screens, check which screen runs which profile or send the list of disconnected screens to your on-site team, you had to open each screen and copy its information by hand. On a deployment of several hundred screens, that is not doable.
Bulk changes had the same problem: before changing the time zone of 300 screens through the CSV import, you first had to rebuild the file yourself.


The CSV Export button, above the list of the Displays page, downloads the list exactly as you see it, with your search, filters and sort, in a spreadsheet file. The file uses the same columns as the import: edit it in Excel or Google Sheets, then import it again to update your screens in bulk.

Before you start

⚠️ Permission required: your role must include the "Associate screens" permission, the same as for the import, because the file holds serial numbers and locations. Without it, the CSV Export button is not shown on the Displays page.

To change the permissions of a role, see Manage User Role Permissions.
​

Export your screens

  1. In the sidebar, click Displays.

  2. Narrow the list if you need to: search for a screen, sort the list, or apply one or more filters (Connected, Disconnected, Sleeping, No location).

  3. Click "CSV Export", above the list, on the right.

The button shows a spinner while the file is built, then your browser downloads a file named screens_<space name>_<date>.csv, for example screens_01-Spie-Batignolles_2026-11-10.csv. The file holds one row per screen of the list, all pages included, in the order of the list.
​

💡 Tip: to send the list of disconnected screens to your on-site team, apply the Disconnected filter, then click "CSV Export".
​

What the screens file contains

The columns are in this order. The first ones can be imported again; the others are there for information and are ignored by the import.

Column

Content

Import

Display ID

ID of the screen in LumApps Signage

Information

Name

Name of the screen

Imported

Serial number

Serial number of the player associated with the screen, empty if none. The import uses it to find the screen to update.

Imported

Timezone, Clock format, Unit system, Language

Regional settings of the screen, for example Europe/Paris, 24h, metric, fr

Imported

Profile ID

ID of the screen profile, empty if none

Imported

Profile name

Name of the same profile

Information

Latitude, Longitude

Location of the screen

Imported

Screen group IDs, Screen group names

Screen groups of the screen, separated by ;, in the same order in both columns

Imported

Status

Online or Offline when you export

Information

Last connection

Date and time of the last connection, in the format YYYY-MM-DD HH:mm

Information

Manufacturer, Model, OS / Firmware, Comeen Play app version, Web app version, MAC address, IP address

Hardware details sent by the player. Empty when the screen has no player or the player sends no details.

Information

Metadata: <key>

One column per metadata key of the exported screens, sorted by key, up to 50 columns. Empty when a screen does not have the key.

Information

ℹ️ The Clock format, Unit system and Language columns hold the values set on the screen itself. When a profile is assigned to the screen, the profile's values still apply on the screen, but they are not copied into the file.

Export the screens of several spaces

If your space manages organization units and the Include all organization units displays toggle is on, the export also contains the screens of the other spaces, as the list shows them. The CSV Export button is then next to the toggle. Before the download, a message warns you that the file includes screens of other spaces: click "Continue" to download it.

The file is named screens_<space name>_all-ou_<date>.csv. Use it for an audit only: it cannot be imported again into your space, because its screens, profiles and screen groups belong to other spaces.

Update screens in bulk with the export

The screens file is ready to be imported again: you do not have to rebuild a file or map the columns by hand.

  1. Export your screens as described above.

  2. Open the file in Excel or Google Sheets and change the values you need, for example the Timezone column. Keep the Serial number column as it is.

  3. Save the file as CSV.

  4. On the Displays page, click "Import from a CSV" and select the file.

  5. Check the mapping step: the columns that can be imported are mapped automatically, the information columns are left out.

  6. Start the import.

Each row is matched to the screen of your space with the same serial number, and that screen is updated. For the full import procedure, see How to import displays from a CSV.

ℹ️ The import accepts up to 1,000 rows and 5 MB per file. If your export has more screens, apply a filter before exporting, or split the file into several files.

How it works

  • What you see is what you export. The file holds the list as it is displayed, with its search, filters and sort, across all the pages of the list. Like the list, the file only holds the screens you can see.

  • Empty list. When the list has no screen, the button is disabled and shows "No screen to export".

  • File format. UTF-8 with BOM, so Excel shows accents correctly, , as delimiter, " as enclosure, headers on row 1.

  • Language of the headers. The headers follow the language of your interface. A file exported in any language is recognized by the import, whatever the language of the person who imports it.

  • Dates. Last connection is written in your own time zone, as you see it in the interface.

  • Values starting with = + - or @. They get a ' in front of them in the file, so that a spreadsheet does not run them as a formula. The import removes this ': a screen named -Lobby keeps its name when you import the file again.

  • Screen groups. At the import, the screen group columns replace the groups of each screen. A screen that is removed from a group no longer plays the playlists of that group. To learn more, see Add a display to a screen group.

  • Size limit. An export holds at most 10,000 rows. When your screens have many metadata keys, the limit is lower, because each key adds a column. Above the limit, the export is refused with a message: apply a filter to export the list in several parts.

  • Number of exports. You can run up to 10 exports per minute, screens and users exports together. Above that, a message tells you how many seconds to wait.

  • Activity history. Each export is recorded in the activity history of your space, with the number of exported rows.

To learn more, see How to import displays from a CSV and Create a screen group. To export your users, see Export users to CSV.

FAQ

I don't see the CSV Export button. Why?

Your role does not include the "Associate screens" permission. Ask an administrator of your space.

The button is greyed out. Why?

The list is empty, for example because no screen matches your filters. Clear the filters or change the search, then try again.

Does the file hold all my screens, or only the first page?

All the screens of the list, across all the pages, with your search and filters applied. To export all your screens, clear the search and the filters first.

I get the message "Too many screens to export". What should I do?

The list is above the export limit. Apply a filter, for example Connected then Disconnected, or search by site, to export the list in several files.

Why do some cells start with a '?

Their value starts with = + - or @. The ' stops a spreadsheet from running it as a formula. It is removed when you import the file again.

Did this answer your question?