Select spreadsheet data in graphics

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:

See also: Select graphics 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 design.
  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 a line in the Spreadsheet panel to display the information in the graphic.

    input-csv-preview.png

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 design, complete the steps in Connect spreadsheet data to a design.
  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 design showing one block of data:

    input-csv-block-in-preview.png

  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 input-csv-btn-toggle-table.png button near the top-left corner of a data block to turn the block off and on.
    • Click the Line input-csv-btn-toggle-row.png 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, complete the steps in Connect spreadsheet data to a design.
  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 that you want to display.

    input-csv-auto-play.png

  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 in the playlist. Titler Live automatically displays and rotates through each line or block of data in the spreadsheet file.

Back to top

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request