Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Forums Adobe After Effects CSV data-driven animation of position and time

  • CSV data-driven animation of position and time

     Walter Soyka updated 1 week ago 2 Members · 2 Posts
  • Diana Marques

    March 31, 2021 at 4:43 am

    I have a .csv file with multiple occurrences (rows) and to each occurrence there is an xyz coordinate and a timestamp (four columns); the time unit is frames (set at 30 fps). As in this sample but extending for thousands of rows:



    In After Effects I would like to have a circle show briefly for each occurrence (think many blinking lights), at the `position and time determined by the data. I’m imagining a circle shape layer showing for a duration of 2 frames, at each position, at the corresponding starting frame indicated by the fourth column.

    I am having trouble writing the expression to encode this. I’ve looked for examples of expressions where data determines position and time, but unsuccessfully so far. If you have any ideas or examples you know of I would very much appreciate, thank you.

  • Walter Soyka

    April 5, 2021 at 8:59 pm

    This is not super-straightforward to do in Ae, because you can’t just “draw” each circle — you actually need to have a layer (or a set of many shape objects within a layer) already set to respond to the data.

    The way I would probably approach this is to reformat the data so it better matches Ae’s model. Consider each row in the spreadsheet to be a single dot, each column to be a single frame (so column A is frame 0, column B is frame 1, etc.), then store the position [x,y,z] in each cell.

    Once you’ve done that, you can import the CSV into Ae, build out layers for the maximum number of dots you’ll have on-screen, and use expressions to get the position for each dot from its corresponding record.

Viewing 1 - 2 of 2 posts

Log in to reply.

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