Contact Us My Activity Community

Importing Excel Spreadsheets and .CSV Files

Rather than manually inputting your data in Livestream Studio, you can import all your data from an Excel (.xlsx) spreadsheet or .CSV file.

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

To get started, click the + button, then navigate to Import Layer. Select Excel Spreadsheet or .CSV File.

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 module. Click the gear wheel to enter its 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 A 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 module to enter the GFX Designer.

Select Excel or .CSV in the dropdown menu and 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 choose font, size, color, opacity, etc.

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 Back to view the layer module. 

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.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.