Some Titler Live products can display data from XLSX and CSV files in graphics. If the data in a spreadsheet file follows a basic format, you can display one line of data at a time. If the data in a spreadsheet file follows a block format, you can display blocks, lines, and parts of a line.
Notes
- The features described in this article are only available in Titler Live Broadcast, Complete, and Present.
- For details on how to create basic and block data files, please see Connect spreadsheet data to a design.
Sections in this article:
- Select data in basic data files
- Select and hide data in block data files (Broadcast and Complete only)
- Automatically play spreadsheet data
See also: Select graphics and spreadsheet data with Instant Search
Select data in basic data files
- If you haven't already created a basic spreadsheet file and connected it to a design, complete the steps in Connect spreadsheet data to a design.
- Select a spreadsheet-connected graphic in the playlist to view the graphic in the Edit / Preview panel.
- If the Spreadsheet panel lists more than one spreadsheet input, expand the spreadsheet input that is connected to the graphic you selected in the previous step.
- Click a line in the Spreadsheet panel to display the information in the graphic.
Select and hide data in block data files (Broadcast and Complete only)
Note: This feature is only available in Titler Live Broadcast and Complete.
- If you haven't already created a block spreadsheet file and connected it to a design, complete the steps in Connect spreadsheet data to a design.
- Select a spreadsheet-connected graphic in the playlist to view the graphic in the Edit / Preview panel.
- If the Spreadsheet panel lists more than one spreadsheet input, expand the spreadsheet input that is connected to the graphic you selected in the previous step.
- Click anywhere in a block of data in the Spreadsheet panel to display the information in the graphic.
Example of a block-data design showing one block of data:
- To turn off (and turn on) specific blocks, lines, or parts of lines, do any of the following steps. (Note that all data are turned on by default.)
- Click the Block button near the top-left corner of a data block to turn the block off and on.
- Click the Line button next to a line to turn the line off and on.
- Click a cell in a data block to turn the cell off and on.
Automatically play spreadsheet data
When a graphic is connected to a spreadsheet input that includes multiple lines or blocks of data, Titler Live can automatically display each line or block of data in succession during playback.
- If you haven't already created a spreadsheet file and connected it to a design, complete the steps in Connect spreadsheet data to a design.
- If you connected a design to blocks of spreadsheet data and you want to hide some data in a block, select the desired data. For details, see the Select and hide data in block data files section.
- Click the Auto Play button in the Spreadsheet panel for the input that's connected to the graphic that you want to display.
- Enter a number in the Delay field to specify the number of seconds each line or block of data will be displayed during playback.
- Click the Play button for the spreadsheet-connected graphic in the playlist. Titler Live automatically displays and rotates through each line or block of data in the spreadsheet file.