About Editing a Project's Captions in a Spreadsheet Editor

Storyboard Pro allows you to export your project's captions in a spreadsheet in the Comma Separated Values (.csv) format. This format of spreadsheet can be opened and edited in spreadsheet editing software such as Microsoft Excel, LibreOffice Calc and Google Sheets.

Storyboard Pro can also import a spreadsheet in the same format, and update the captions in your project with the content of the spreadsheet. Hence, you can export your project's captions in a spreadsheet, edit them in a third-party software, and then import the edited spreadsheet and update the captions in your project.

This procedure cab be useful if you want to make sweeping changes to your project's captions, if you want to write your captions from scratch into a spreadsheet, or if you need your project's captions to be reviewed.

NOTE

CSV is a text-based spreadsheet format that is commonly supported by spreadsheet editors, and which is easy to process in scripts and other software as it is merely a text file containing the value of each cell, typically separated by a comma. However, it does not support advanced spreadsheet features such as text formatting and formulas.

IMPORTANT If your captions contain non-latin character (ie: Japanese, Chinese, Korean, etc.), you should avoid editing a CSV containing your project's captions in Microsoft Excel, as it will display those non-latin characters, but it will not save them in your CSV file. LibreOffice Calc and Google Sheets support saving CSV files with non-latin characters.