How to format .csv data driven animations

[Patrick Lomasney]

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

[Mylenium]

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]

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?

[Patrick Lomasney]

Using what you have given I just get this 

[Patrick Lomasney]

Okay ignore my previous replies.

I have used what you said and what the help article said and managaed to do this. However how do I make the layer move down the column so I can have the live speed? At the moment it is just taking the value from the top cell and that is it,

Thanks

[Mathias Moehl · Accepted solution]

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.