Skip to main content
eclare
Participant
December 13, 2022
Question

Linking MS Excel spreedsheet data into an After effects comp

  • December 13, 2022
  • 3 replies
  • 1456 views

Hi all, I stuggling to find answers on how to easily link a MS excel spreed sheet to produce multiable graphics of the same design with variale data.

 

Is anybody able to help??

Thank you.

This topic has been closed for replies.

3 replies

Sulaco
Inspiring
December 14, 2022

You could also give Templater from dataclay.com a look. It's more pricey than Mylenium's suggestion, but it's pretty easy to use. We have been testing it for a couple of productions and it's been working pretty well. But I think there is a free trial version, maybe you can get your project done with that...

Mylenium
Legend
December 13, 2022

Sounds more like you may need a classic script rather than actual data-driven animation. This one sounds more like the deal:

 

https://aescripts.com/compsfromspreadsheet/

 

Mylenium

eclare
eclareAuthor
Participant
December 13, 2022

Thank you for the help

Mylenium
Legend
December 13, 2022

https://helpx.adobe.com/after-effects/using/data-driven-animations.html

 

Anything more would require better explanations on what you actually need/ want to do.

 

Mylenium

eclare
eclareAuthor
Participant
December 13, 2022

Yes.  I film hundreds of horses and I need a graphic at the start of each video identifying each horse.  I have every horse's details in a excel spreed sheet.  I would like to create one introduction graphic for each video with the same design but different text detailing each horse. 

 

See this link to an example video to give you the idea.. https://vimeo.com/679581171 

thank you

Mathias Moehl
Community Expert
Community Expert
December 14, 2022

You could Automation Blocks "Comp Duplicates from Spreadsheet" for that:

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

 

Another option it Templater.

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects