Skip to content

CompsFromSpreadsheet 5

by Michael Cardeiro·Workflow

Images © Michael Cardeiro. Used for product review; image policy.

Why we like it

Earns its place in the aescripts library for turning a spreadsheet into a batch of After Effects comps, with layer-name prefixes controlling item swaps and precomp updates. Compatibility spans CC 2015.3 through After Effects 2026.

What is CompsFromSpreadsheet 5?

CompsFromSpreadsheet 5 is a script for After Effects that produces versions of your compositions from a spreadsheet. You arrange your data in columns, and the script builds comps from a template using those rows. The interface was reworked to accommodate spreadsheets with many columns.

Layer names act as instructions. A non-text layer whose name starts with # is replaced by the project item named in your spreadsheet, and a precomp layer starting with ! has its inner layers updated from the spreadsheet when set up for compsFromSpreadsheet. Layers replaced with compositions can also receive spreadsheet data. You can define an import directory, adjust composition length based on layer length, and set the Output Module and Render Settings from the spreadsheet.

Version 5.23, updated on 30 July 2025, refreshed the aescripts license code, following earlier fixes to render settings, image-sequence output and an "undo group mismatch" bug. It also handles double quotes that Excel can mangle when converting to tab-delimited text. A demo video is available, and it runs across After Effects releases from CC 2015.3 through 2026.

Who is CompsFromSpreadsheet 5 best for?

CompsFromSpreadsheet 5 is best for after Effects artists producing multiple versioned comps from spreadsheet data.

How much does CompsFromSpreadsheet 5 cost?

CompsFromSpreadsheet 5 is completely free to download and use.

Key features

  • Generates multiple comp versions from a spreadsheet template
  • Non-text layers named beginning with # are replaced by the project item named in the spreadsheet
  • Precomp layers beginning with ! update inner layers set up for compsFromSpreadsheet from the spreadsheet
  • Layers replaced with compositions can receive data from the spreadsheet
  • Output Module and Render Settings can be set from the spreadsheet
  • Composition length can be adjusted based on layer length
  • Import directory can be defined, with interface built to handle many spreadsheet columns

Tags

#After Effects#spreadsheet#automation#comp versioning#data-driven#scripting#aescripts#batch

Frequently asked questions

Which After Effects versions does CompsFromSpreadsheet 5 support?

CompsFromSpreadsheet 5 lists compatibility with After Effects 2026, 2025, 2024, 2023, 2022, 2021 and 2020, along with CC 2019, CC 2018, CC 2017 and CC 2015.3. That range covers current releases as well as several older Creative Cloud versions, so it fits both up-to-date and legacy setups. Version 5.23 was last updated on 30 July 2025. If you run a build outside this list, check the developer's page for the latest compatibility details before installing.

How does CompsFromSpreadsheet 5 replace layers with project items?

CompsFromSpreadsheet 5 uses layer-name prefixes to swap content. A non-text layer whose name begins with # is replaced by the project item named in your spreadsheet. A precomp layer whose name begins with ! has any layer inside that precomp, when set up for compsFromSpreadsheet, updated from the spreadsheet. Layers that were replaced with compositions can also receive data from the spreadsheet. Together these rules let one template comp generate many versions from your spreadsheet rows.

Can CompsFromSpreadsheet 5 set render settings from the spreadsheet?

CompsFromSpreadsheet 5 can set the Output Module and Render Settings from the spreadsheet, and it lets you define an import directory for referenced files. Composition length can also be adjusted based on layer length as each version is built. Recent updates fixed issues with saving a render to an image sequence along with other render-settings problems, and resolved an "undo group mismatch" bug. A demo video is available, and the developer's page has full setup details.

Is CompsFromSpreadsheet 5 free?

CompsFromSpreadsheet 5 is listed as free in this catalog. Licensing terms can change, so confirm the current arrangement on the developer's aescripts page before you download. The script has refreshed its aescripts license code across recent releases, including version 5.23, and earlier versions added support for floating licenses. For the most accurate licensing information, refer to the developer's page rather than relying on this listing alone.

Alternatives to CompsFromSpreadsheet 5

Also in Workflow for After Effects.

Similar plugins