CompsFromSpreadsheet 5
-
Compatibility After Effects Please check exact version compatibility under the "COMPATIBILITY" tab below
Adding to cart... 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 Comp
When 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 Spreadsheet
Before 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 Settings
By 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 CompsFromSpreadsheet
When 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.Installing CompsFromSpreadsheet
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.
Upgrade notice
If you own version 4 you can upgrade for $34.99. There is no upgrade discount from prior versions. To get the upgrade pricing simply login to the same account as your original purchase. Contact us if you have any questions.
| After Effects | 2025, 2024, 2023, 2022, 2021, 2020, CC 2019, CC 2018, CC 2017, CC 2015.3 |
|---|
5.21 (Current version) - Oct 30, 2023
5.2 - Oct 10, 2022
5.19 - Apr 19, 2022
5.18 - Sep 29, 2020
5.17 - Sep 2, 2019
5.16 - Jul 12, 2019
5.15 - Nov 26, 2018
5.14 - Feb 8, 2017
5.12 - May 23, 2016
-Fixed the new version checker
5.11 - Apr 21, 2016
-Double quotes apparently get mangled by excel when you convert to tab delimeted text. Now if you put
-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.
-Fixed "undo group mismatch" bug.
-Fixed issues with saving render to an image sequence and other issues with render settings.
5.0 - Apr 27, 2016
-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.
-
- Compatibility After Effects
Ray Dynamic Color 2
Add to CartThe industry leading Color Palette for After Effects.
$29.99 -
- Compatibility After Effects
Plexus 3
Add to CartNow with Multi-Frame Rendering (MFR) Support! Rowbyte Plexus is a next-gen particle engine for After Effects that lets you create, manipulate and visualize data in a procedural manner. Not only you can render the particles, but also create all sorts of interesting relationships between them based on various parameters.
$249.99 As low as: $199.99 -
Data Storyteller
Add to CartData Storyteller is a data visualization plugin set designed to easily turn data into animations.
From: $199.00
-
- Compatibility After Effects
MonkeyBars
Add to CartThe quickest, easiest way to create animated lower 1/3s. This Monkey is a workhorse.
-
- Compatibility After Effects
LCDeffect
Allows you to get the look of LCD (or you may see like CRT) like effect in 1-click.Add to Cart -
- Compatibility After Effects
AEInfoGraphics 2
Add to CartCreate beautifully animated infographic charts from a connected spreadsheet or directly entered data with real-time previews.
-
- Compatibility After Effects
Matrix
Takes a layer in your comp and breaks it into pieces. You choose the size of the pieces, whether to animate in order or random, and how long you want the transition to take.Add to Cart$14.99 As low as: $11.99 -
- Compatibility After Effects
SpellCheck
Goes through the currently selected composition, and any precomp contained within and checks every text layer for proper spelling.Add to Cart$9.99 -
- Compatibility After Effects
Trajectory
Align all layers in a composition evenly on a line between 2 nulls with delay controls for animation.Add to Cart$9.99