Skip to main content
kulss
Inspiring
March 8, 2023
Answered

Batch render in one click through .CSV data

  • March 8, 2023
  • 3 replies
  • 3144 views

Hello there!

 

On this Ukramedia video, he explains how he created a .CSV file on Excel and how he can batch render multiple clips on one click from AE using that .CSV file. In order to do so, around 9:54, he talks about a script that he created for this situation, and by using that script, he can batch render in one click multiple videos based on the rows inside the Excel file.

 

Is there any way I could do this without his plugin? Another plugin will do the work as well, but I currently can't find anything like that.

 

Most of the stuff I've found is how to link Texts from AE to columns on a .CSV file, but what I am looking for here is to export different versions of the same video with a different text.

 

Thank you all!

 

PS: an option on Premiere will do the work as well, but just wondering if I could do it on AE. Any other alternative without using a .CSV file will do the work too 🙌

Correct answer Mylenium

I'm sure you could find something on AEScripts.com, but ultimately not exactly the same. That's the point in selling specialized scripts. If you're feeling adventurous, you perhaps could use the good old CompsFromSpreadsheet script as a template and add the render queue functions you need. Otherwise spending a few bucks can save a lot of headache.

 

Mylenium

3 replies

Participating Frequently
July 28, 2025

All great suggestions below - if you wanted something that works in the cloud and can connect to more than just a .csv (think API, RSS, Airtable, Excel...etc) you can check out Plainly (plainlyvideos.com)

Legend
March 8, 2023

Hi There,

Check out Templater from Dataclay.  https://dataclay.com/templater — it will amp up your workflow.  You can use Google Sheets so your data is "in the cloud" and you don't need to be concerned about local files.   You can have others collaborate on the data while you focus on the creative. 

 

Enjoy!

Mathias Moehl
Community Expert
Community Expert
March 9, 2023

As Arie mentioned, Templater is a good solution. Automation Blocks also has very powerful workflows for this and can be customized easily:

https://mamoworld.com/docs/automation-blocks/tools-ae/compDuplicatesFromSpreadsheet

 

 

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
Mylenium
MyleniumCorrect answer
Legend
March 8, 2023

I'm sure you could find something on AEScripts.com, but ultimately not exactly the same. That's the point in selling specialized scripts. If you're feeling adventurous, you perhaps could use the good old CompsFromSpreadsheet script as a template and add the render queue functions you need. Otherwise spending a few bucks can save a lot of headache.

 

Mylenium

kulss
kulssAuthor
Inspiring
March 16, 2023

Thank you for your answer, Mylenium!

 

I ended up giving a try to the good old CompsFromSpreadsheet and it did the exact thing I needed. Such an amazing script 🤩