Compatibility After Effects Please check exact version compatibility under the "COMPATIBILITY" tab below
Add Your tagsClose
Automated Versioning of Your Comps
CompsFromSpreadsheet allows you to quickly generate copies of your After Effects compositions, updating the new comps with data from a spreadsheet used to insert text and replace layers.
The script has been used by NBC, HBO, Disney and thousands of others.
New in Version 5.1
- Interface changed to accommodate spreadsheets with many columns.
- Double quotes apparently get mangled by excel when you convert to tab delimeted text. Now if you put
in your spreadsheet, the script will convert it to “
- If you want to update your template comps without duplicating them, there is a checkbox in settings->processing “Don’t Duplicate Template and Pre Comps”. When checked the script will not duplicate comps or precomps instead working on the original template comp and precomps
-You can now import an image sequence by appending a * instead of > in the layer name. Previously if you tried to import an image sequence, only the first frame would come in.
- You can now import an image sequence by appending a * instead of > in the layer name. Previously if you tried to import an image sequence, only the first frame would come in.
- Fixed "undo group mismatch" bug.
- Fixed issues with saving render to an image sequence and other issues with render settings.
Read about the new features in detail: CompsFromSpreadsheet 5.1 New Features PDF
New in Version 5
- Layers replaced with compositions can receive data from the spreadsheet
- Ability to define import directory
- Composition length can be adjusted based on layers length
- Output Module and Render Settings can be set from the spreadsheet
- Various bug fixes and minor features
Read about the new features in detail: CompsFromSpreadsheet 5 New Features PDF
Creating Template Comps
In order to use CompsFromSpreadsheet you need to create a template composition to receive data from your spreadsheet.
- Text layers that begin with ^(shift 6) will be able to receive data from the spreadsheet as the source text for that layer. If you need a new line or comma in a text layer DO NOT put these characters in your spreadsheet. Instead use <br> for a newline and <c> for a comma and CompsFromSpreadsheet will replace these symbols with their intended values at runtime.
- If you have a text layer named ^date it will receive today’s date (great if you’re generating slates) default format is MM/DD/YYYY numerically. You can switch to a different date format by clicking on the settings window and going to the Misc tab.
- 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 a >, it will be replaced by a file. CompsFromSpreadsheet 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, CompsFromSpreadsheet will only import it once and use that item for every other time the file is referenced. Instead of putting the path in your spreadsheet, you can define a default import directory.
- 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.
- You can designate a layer to control the length of the composition by putting a ~ at the end of the name. So if you have a layer that is named audio which will receive imported audio files you can add a ~ to the end making the layer name >audio~ this will cause this layer to dictate the length of the comp. So when CompsFromSpreadsheet replaces that layer with the imported audio file, it will adjust the compositions length so that the comp ends on the last frame of the imported audio file.
If you are running CompsFromSpreadsheet 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.
So if you click on the button to create text object and type "title" in the window, After Effects will create a text layer named "^title" in the currently selected comp.
Setting up your spreadsheet
The spreadsheet is the way that you create copies of your template comp and update text and layers.
The first line of your spreadsheet must contain the names for each column. If you have more than one composition in your project, you will need a column named COMP that will hold the name of the comp to copy for that line.
When you run CompsFromSpreadsheet it will take each of these column names and allow you to connect that column with target layers in your template comp(s). If you name the columns the same name as the layers they are going to update, these items will automatically be selected.
Synching Column Data to your CompWhen CompsFromSpreadsheet reads the first line of your spreadsheet, it needs you to tell it where the data from each column should go in your comp. The Field Init window opens. Each column name from the first line of the spreadsheet appears with a dropdown box underneath.
The dropdown box links the data from that column in the spreadsheet to elements in your template comps. The drop-down box contains the names of all the layers that were set up earlier to receive data (remember, the text layers that started with ^ will receive the data from this column, layers with a # will be replaced with the project item named in this column, and layers with $> will be replaced by files imported from the location specified in the column.) If a column name is the same as an element name in one of your comps, that will be automatically selected in the drop-down i.e. If you have a column in your spreadsheet phone and a text layer in one of your template comps named ^phone, that item will be automatically selected in the dropdown box. If however, your text layer is ^phone number it will not be selected in the dropdown box. If you have more than one comp to be used you will need to have a column named COMPin your spreadsheet with the name of the comp to be used for that line. This is not necessary if you only have one composition in your project
Converting Your SpreadsheetBefore After Effects can read your spreadsheet, it needs to be converted into a tab delimited text file (most spreadsheet programs do this easily). This is a universal text format that will allow After Effects to read in your data and organize it by rows and columns. When you run CompsFromSpreadsheet be sure to point it to this newly created text file and not your spreadsheet as After Effects can-not read any spreadsheet format (maybe I should call it compsFromTabDelimitedTextFile).
Render SettingsBy default, every comp created by CompsFromSpreadsheet will be placed in the render queue using the default settings for your render queue. It will default to saving the renders in the same directory as your project. If you don’t want your new comps put in the render queue you can turn this off in the settings.
If you click the “Render Settings” button (on the “field init” window) you can select which render setting and output module to use for CompsFromSpreadsheet and where to put the rendered files. If you check the “Remember Settings” box these settings will be used every time you run compsFromSpreadsheet; if not checked, these settings will be used in the current run. You can also set the output module and render setting for each item via the spreadsheet
Running CompsFromSpreadsheetWhen you click the run compsFromSpreadsheetbutton a window will pop up asking you to select your grid file. This is the tab-delimited text file that you created from your spreadsheet. Do not select your actual spreadsheet as CompsFromSpreadsheet will not be able to understand it. Once you select the tab-delimited text file, CompsFromSpreadsheet will read the first line of it which needs to contain the names of all the columns. The field init window will pop up to allow you to sync the data in the text file to target layers in your comp.
Restart After Effects.
Click on the After Effects “Window” menu.
Way down at the bottom of the “Window” menu click on “compsFromSpreadsheet”, the compsFromSpreadsheet interface will load onto a new panel.
A window will pop up allowing you to enter a license, or run a fully functional demo.
In After Effects General Preferences, make sure that "Allow Scripts to Write Files and Access Network" is enabled.
If you own version 3 or 4 you can upgrade for $24.99. To get the upgrade pricing simply login to the same account as your original purchase. Contact us if you have any questions.
|After Effects||CC 2019, CC 2018, CC 2017, CC 2015.3, CC 2015, CC 2014|