Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Activity Forums Adobe After Effects Is there any Script or Expression to pull data from a spreadsheet?

  • Is there any Script or Expression to pull data from a spreadsheet?

    Posted by Matt Cheah on April 9, 2012 at 7:02 pm

    Hey all,
    I’m trying to create 200+ videos that only differ by one or two text layers and I’d like to know if there’s a script or expression that I can use to pull text from a spreadsheet, input into a text layer in after effects, and then render it out with an incremented number after the file name.
    I can do it manually but it would just save me a bunch of time. Any ideas or thoughts?
    Much appreciated!

    Walter Soyka replied 14 years, 1 month ago 3 Members · 4 Replies
  • 4 Replies
  • Walter Soyka

    April 9, 2012 at 7:18 pm

    https://aescripts.com/compsfromspreadsheet/

    Walter Soyka
    Principal & Designer at Keen Live
    Motion Graphics, Widescreen Events, Presentation Design, and Consulting
    RenderBreak Blog – What I’m thinking when my workstation’s thinking
    Creative Cow Forum Host: Live & Stage Events

  • Matt Cheah

    April 9, 2012 at 8:27 pm

    Thanks Walter!

  • David Cabestany

    April 10, 2012 at 4:02 pm

    Check this tutorial by Harry Frank also, it might be a little easier to implement if you’re only changing one or two text objects.

    https://www.graymachine.com/2009/04/expressions-and-external-documents-revisited/

  • Walter Soyka

    April 11, 2012 at 6:19 pm

    [Dave LaRonde] “I just learned you went to SU. Wouldn’t you know, I grew up in Liverpool. “

    Cool. I’ve got some family in Liverpool and some friends in the Syracuse area, but I haven’t been up there in some time.

    [Dave LaRonde] “Heid’s…. mmmmmm! Dinosaur BBQ, too.”

    Well, now I’m hungry…

    [Dave LaRonde] “And I’ll bet it didn’t get past you that another Walter by the name of Biscardi also put in four years at Newhouse.”

    The coincidences don’t end there. Walter B.’s hometown borders mine.

    Walter Soyka
    Principal & Designer at Keen Live
    Motion Graphics, Widescreen Events, Presentation Design, and Consulting
    RenderBreak Blog – What I’m thinking when my workstation’s thinking
    Creative Cow Forum Host: Live & Stage Events

We use anonymous cookies to give you the best experience we can.
Our Privacy policy | GDPR Policy