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
The compsFromSpreadsheet script is meant to be run as a dockable panel (but it can run as a straight script). This means it needs to be saved in “Adobe After Effects CS(your version here)/Support Files/Scripts/ScriptUI Panels/” folder. Save the “compsFromSpreadsheet.jsxbin” file into the “ScriptUI Panels” folder
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.
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
- Fixed a bug where, if you choose "Original Comp Name with Incrementing number" as your new composition name, sometimes the comp would be renamed with one of the pre-comps from your template.
5.2 - Oct 10, 2022
- Updated licensing code
5.19 - Apr 19, 2022
- Updated licensing code
5.18 - Sep 29, 2020
- fixed a bug that caused the script to fail when run from the file menu
5.17 - Sep 2, 2019
- Updated licensing to work with latest apple os
5.16 - Jul 12, 2019
- Fixed bug that would occasionally cause the script not to open in cc2019 (an error message would say "error at line one expected )."
5.15 - Nov 26, 2018
- Added support for floating licenses
5.14 - Feb 8, 2017
-Fixed an issue that would cause the script to fail in cc2017 after the first comp is created.
5.12 - May 23, 2016
-Fixed a bug that would cause the script to fail if you had a field blank for an imported file in your spreadsheet
-Fixed the new version checker
-Fixed the new version checker
5.11 - Apr 21, 2016
-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.
-Fixed "undo group mismatch" bug.
-Fixed issues with saving render to an image sequence and other issues with render settings.
-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
-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.
-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
MochaImport+ V6
Add to CartMochaImport simplifies your workflow between mocha and After Effects. Create stabilized precomps, move masks, effect points and layers, and distort them in perspective.
€47.99 -
- Compatibility Premiere
Textyle Premiere
Add to CartAnimate text with an easy to use interface that includes many presets and styles in Premiere Pro
-
- Compatibility After Effects
TextBox 2
Add to CartTextBox is a native plugin that creates a perfectly sized, customisable shape behind your text that updates automatically and is applied directly to the text layer so no need for parenting, mattes or expressions.
-
- Compatibility After Effects
MonkeyWipes
Add to CartA wild procedural transition system with virtually endless possibilities. Built for easy experimentation. Great for logos, text or motion graphics.
-
- Compatibility After Effects
ASH Syntax Highlighter
ASH brings code-editor syntax highlighting to your AE text layers! Perfect for FUI artists everywhere!Add to Cart -
- Compatibility After Effects
Text2Spreadsheet
Export text from your After Effects project to a spreadsheet, make edits, then reapply the changes back to your project with a single click. Ideal for translations, client reviews, and streamlined text processing tasks.Add to Cart
-
- 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.59 -
- 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.59 -
- 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.39 As low as: €11.51