CompsFromSpreadsheet v3.01 AEScripts

Automated Versioning of Your Comps

The compsFromSpreadsheet script allows you to quickly generate copies of your master comps with data from a spreadsheet used to update text or replace layers.

Demo

Getting Started

TimelineBefore you can use the script you need to setup one or more template compositions to receive data from your spreadsheet. There are a few ways your template comp can be updated from the spreadsheet

Text layers that begin with ^(shift 6) will be able to receive data from the spreadsheet as the text for that layer.

If you need a line break in a text layer DO NOT put a line break in your spreadsheet cell as this will cause the script to think it is the end of that line of data. Instead use <br> and the script will replace that with a newline in your text layer

If you have a text layer named ^date it will receive todays date (great if you're generating slates)

default format is MM/DD/YYYY. You can switch to a different format by clicking on the settings window.

If you have a non-text layer in your comp that begins with #, it will be replaced by the project item named in your spreadsheet

If you have a non-text layer in your comp that begins with >, it will be replaced by a file. The script will import a file based on the path in your spreadsheet, then that imported file will replace the layer. If you have the same file referenced more than once in your spreadsheet, the script will only import it once and use that item for every other time the file is referenced

If you have a precomp layer in your comp that begins with !, any layer in the precomp setup for compsFromSpreadsheet will be updated from the spreadsheet.

If you are running the script as a dockable panel, there will be buttons to automatically create either a text, layer replace, or import object in the currently selected comp. When you create the layers this way a window will pop up asking for the name of the layer, do not put in the ^ > or # in this window as After Effects will do this for you.