Skip to main content
Patrick Lomasney
Inspiring
September 17, 2021
Answered

How to format .csv data driven animations

  • September 17, 2021
  • 1 reply
  • 1555 views

Hello,

I am trying to format a .csv file so I can have a live speed data as a value which I can link directly to a text layer.  It is for exporting telemetry from sim racing games and putting into an After Effects project.  I hacve linked the raw telemetry export data as well as a version of it what I have formatted to try and get the effect to work.  What I want is for the folder below called  KPH to be a pickable parameter for a text layer.  Not to have all the diffrent values seperate.

I hope yo understand what I mean and that you will be able to help.  Below I have linked a screnshot of the Graphics which I am making,

Thanks

This topic has been closed for replies.
Correct answer Mathias Moehl

dataValue([0,0])

accesses the first row/column of your spreadsheet

 

timeToFrames(time)

returns the current frame number.

Hence,

dataValue([0,timeToFrames(time)])

will use the first column for the first frame, the second colum for the second frame etc.

 

1 reply

Mylenium
Legend
September 17, 2021

https://helpx.adobe.com/after-effects/using/data-driven-animations.html

 

You simply call up the column and row, where in your case the row would be addressed as timeToFrames(time) to fetch the entries for each individual frame.

 

Mylenium

Patrick Lomasney
Inspiring
September 17, 2021

Thanks fo the response,

Can you give me an example of how I would type that?

Would it be an expression?

Which layer would the expresion go on?