Select spreadsheet data in graphic layers

Titler Live products can display data from XLSX and CSV files in graphic layers. 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: For details on how to create basic and block data files, please see Connect spreadsheet data to a graphic layer.

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 graphic layers and spreadsheet data with Instant Search

 Select data in basic data files

1. 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 graphic layer.
2. Select a spreadsheet-connected graphic layer from a channel to view the graphic layer in the Preview panel.
3. 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.
4. Click a line in the Spreadsheet panel to display the information in the graphic layer.
   
   

   

Back to top

Select and hide data in block data files (Broadcast and Complete only)

Note: This feature is only available in Titler Live Broadcast and Complete.

1. If you haven't already created a block spreadsheet file and connected it to a graphic layer, complete the steps in Connect spreadsheet data to a graphic layer.
2. Select a spreadsheet-connected graphic in the playlist to view the graphic in the Edit / Preview panel.
3. 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.
4. Click anywhere in a block of data in the Spreadsheet panel to display the information in the graphic.
   
   

   Example of a block-data graphic layer showing two blocks of data:

   

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

Back to top

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.

1. If you haven't already created a spreadsheet file and connected it to a design layer, complete the steps in Connect spreadsheet data to a graphic layer.
2. 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.
3. Click the Auto Play button in the Spreadsheet panel for the input that's connected to the graphic layer that you want to display.
   

   

4. Enter a number in the Delay field to specify the number of seconds each line or block of data will be displayed during playback.
5. Click the Play button for the spreadsheet-connected graphic layer. Titler Live automatically displays and rotates through each line or block of data in the spreadsheet file.

Back to top