Import Excel Spreadsheets and .CSV Files – Livestream

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.

Excel spreadsheet showing a column of names and a column of titles.

If you want to include images, make a column with the URLs where the images are hosted.

Excel spreadsheet showing a third column with image links

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.

Studio graphics add menu, highlighting import layer followed by csv file and excel spreadsheet options.

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.

Graphics layer panel showing three columns with rows of data from the previously shown spreadsheet.

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.

Layer settings, focused on a checkbox labeled 'watch file for update'

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.

graphics layer settings, showing checkbox labeled 'use first row as column titles' and highlighting column titles.

Click on the name of any column to change the data type that is in the column (text or image).

Column title dropdown menu showing the option to change to image column

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.

layer settings showing a uncheck checkbox labeled 'read only,' and showing a row highlighted and able to be edited.

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

csv layer settings showing two dropdown menus, separators and character encoding.

Scroll down to find your Auto-Loop settings, including interval between rows, direction, and starting point.

layer settings showing auto-loop settings and options such as interval, restarting from the beginning, 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.

the graphic designer data button showing the three column names as options.

From here, you can drag and drop each field to wherever you want it to be displayed.

the graphic designer showing the data fields and other design elements

Click the gearwheel icon on each field to configure its appearance settings.

one element selected, showing the menu that appears when you select the attached gearwheel icon.

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.

Graphics layer settings panel, highlighing the back arrow in the upper left corner.

Make sure the eye icon corresponding to that layer is highlighted blue, meaning that it is visible.

The graphic layer, highlighting the eye icon being enabled.

You can then click the associated PRV, PUSH, and PULL buttons to utilize that graphics overlay.

Studio transition controls, highlighting the three graphic overlay controls for each track.