Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Forums Adobe After Effects Spreadsheet -> AE

  • Spreadsheet -> AE

     Randy Gonzalez updated 1 week ago 5 Members · 16 Posts
  • Adam Lewen

    December 6, 2018 at 2:14 pm

    I know about a couple of scripts that help with several tedious tasks. I am looking for something that could really cut down some tedious work:
    To simplify-
    I have a spreadsheet (Excel) with 50 rows (for 50 Comps)
    Each row has a name column (Comp name)
    and size column (all different resolutions)
    Is there a script that I can execute and get an AE Project to help with creating those 50 Comps, each comp having the specific rez?
    If anyone knows, any tip will very very much appreciated!
    Thank you!

  • Adam Lewen

    December 6, 2018 at 8:44 pm

    Hey Dave, thanks for the reply.
    Sure making 50 comps is easy, but since it’s a pretty automatic task, and my situation might happen a couple times a week, not a one time project, where 50 can turn to 80 or even more… An automated way of starting a project, which is dealing with the content of these comps, will help tremendously. I thought asking here might be helpful.
    This forum helped me numerous times with knowledgeable scripting suggestions or direction ☺


  • Adam Lewen

    December 8, 2018 at 8:29 pm

    I will.
    Thanks Dave.

  • Mark Doctor

    December 8, 2018 at 10:31 pm

    Yes there is a script! I haven’t seen it for ten years, but its out there. Sorry to be of no help now, but maybe I can find it.

    Greets Mark

  • Adam Lewen

    December 9, 2018 at 7:30 am

    Mark, thanks for the reply. If there is one I’ll be very thankful!

  • Walter Soyka

    December 9, 2018 at 11:25 am

    This sounded useful, so I wrote one:

    You will need a six-column Excel grid with header rows for Comp Name, Width, Height, pixel aspect ratio, time, and frame rate:

    The script presents an area for input like this:

    Paste your data from Excel into this area, like this:

    Click the “Make many comps” button, and many comps will be made.

    Walter Soyka
    Designer & Mad Scientist at Keen Live [link]
    Motion Graphics, Widescreen Events, Presentation Design, and Consulting
    @keenlive [twitter]   |   RenderBreak [blog]   |   Profile [LinkedIn]

  • Adam Lewen

    December 9, 2018 at 7:57 pm

    Walter, this is not the first time you reply to my quest with a tailor-made useful script. I am speachless. I am sure its useful many purposes and many people. i’m going to try it first thing tomorrow morning. Stay tuned ????. Thank you so so so much!

  • Adam Lewen

    December 10, 2018 at 10:37 am

    Walter Thanks again! It works like butter! (I needed to tweak the order of the columns a bit, but I think its due to RTL-LTR on my side, and btw, it works with other languages – for the comp names!)

    Can I share this with people of interest?


  • Walter Soyka

    December 10, 2018 at 10:44 am

    You’re welcome, Adam. This looked like the sort of thing we could use, too, so hopefully it works well for both of us. Please do feel free to share; I post these publicly so the whole community can benefit.

    Walter Soyka
    Designer & Mad Scientist at Keen Live [link]
    Motion Graphics, Widescreen Events, Presentation Design, and Consulting
    @keenlive [twitter]   |   RenderBreak [blog]   |   Profile [LinkedIn]

  • Adam Lewen

    December 12, 2018 at 1:19 pm

    Walter, where do you post publicly?

Viewing 1 - 10 of 16 posts

Log in to reply.

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