Rather than manually inputting your data into Livestream Studio, you can import all your data for graphic overlays from an Excel (.xlsx) spreadsheet or .CSV file.
For the best experience, we recommend that your document have no more than 250 rows. You can use other Excel or .CSV files in as many graphics layers as needed if you need to show more data.
If you want to include images, make a column with the URLs where the images are hosted.
To get started:
- Select a GFX panel.
- Click the + Create Custom Graphic button.
- Hover the cursor over Import Layer.
- Choose either .CSV File or Excel Spreadsheet.
The browse window will appear, allowing you to select your file and import it. The data from your file will appear on the right side of the panel. Click the gear wheel to enter your graphic layer's settings.
Checking Watch file for update will prompt Livestream Studio to make any changes to the data that are made in the original .xlsx file on your hard drive.
Checking Use first row as column titles will change row 1 in your spreadsheet to be titles of the corresponding columns in the GFX layer.
Click on the name of any column to change the data type that is in the column (text or image).
If you want to be able to edit the information within Livestream Studio, uncheck Read Only. Otherwise, changes can only be made in the original file.
Any edits made to in Livestream Studio will not change content in the original document.
.CSV File Only - Further down in the settings, you can adjust the separators in the document as well as the character encoding (which is typically detected automatically).
Scroll down to find your Auto-Loop settings, including interval between rows, direction, and starting point.
Next, click on the paintbrush icon at the bottom of the graphics panel to enter the GFX Designer.
Select Excel or .CSV in the left side dropdown menu, then click the list icon to insert your text and image fields into the designer.
From here, you can drag and drop each field to wherever you want it to be displayed.
Click the gearwheel icon on each field to configure its appearance settings.
Feel free to add any additional elements to your graphics overlay using the other icons at the bottom of the designer.
Close out of the GFX Designer when you have finished. To use the graphic, click the back arrow to view the layer in the panel.
Make sure the eye icon corresponding to that layer is highlighted blue, meaning that it is visible.
You can then click the associated PRV, PUSH, and PULL buttons to utilize that graphics overlay.