• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Linking MS Excel spreedsheet data into an After effects comp

New Here ,
Dec 12, 2022 Dec 12, 2022

Copy link to clipboard

Copied

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.

TOPICS
Dynamic link , How to , Import and export , Scripting

Views

430

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 12, 2022 Dec 12, 2022

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 13, 2022 Dec 13, 2022

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 14, 2022 Dec 14, 2022

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 13, 2022 Dec 13, 2022

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 13, 2022 Dec 13, 2022

Copy link to clipboard

Copied

Thank you for the help

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
Dec 14, 2022 Dec 14, 2022

Copy link to clipboard

Copied

LATEST

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...

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines