pasting spreadsheet data into keyframes / linking spreadsheets to ae

[Filip Vandueren]

If you don’t want to go the route of importing a csv or Json file,
maybe you can do this:
Add a marker to your Shape layer, and paste the row of data in the marker’s comments:
10% 20% 90% 80% 55% 76% 12%

Then this expression will create an array of the values:

percentages = marker.key(1).comment.split("%\t").map( s => parseFloat(s));

// quick example with some animation:
t = clamp(Math.floor(time), 0, percentages.length -1 );
fromP= percentages[t]
toP= percentages[t+1];

ease(time%1, 0.5, 1, fromP, toP);


[James Sandifer]

Thank you I’ll see if I can make that work.

[Tomas Bumbulevičius]

Hey Filip,

but what about Y comparison between the lines? Do you have an idea for this?

For me it looks like huge bottleneck to compare these with expressions as the author is planning to do one way or another!

Find out more:
Motion Graphics Design & After Effects Tutorials
On YT
On VH