Creating comps with data imported from Excel

[A-Picquout]

Hello,

I would like to know if there is any way to automatically create compositions with datas imported from an Excel file, just like InDesign does ?

It would be more about automatically changing texts to make a custom video for multiple people.

It tried to find out on my own, but it's actually pretty confusive...

Thank you in advance.

[Justin Taylor-Hyper Brew]

If you want an out-of-the-box solution, check out Templater or Comps From Spreadsheets.

If you wanna build your own system, I'd recommend exporting your spreadsheets and CSV, processing with a CSV parser, and then creating comps from there.

If you're new to scripting, David Torno has a good free series to get you up and running: https://www.provideocoalition.com/after-effects-extendscript-training-complete-series/ and the latest changes are updated on the online docs: http://docs.aenhancers.com/