Include CSV Data in After Effects

With this method you can include your data from a GPS Watch or Smartphone in After effects. If you want to create a video with live statistic data, for example heartrate, speed or height meter this is the best way to do it. Make sure that you export your data as CSV table. This method is also working if you want to auto change the text, which is stored in an array or string. Very important is, to check the settings of your GPS watch or Smartphone, that the gadget writes the data every second.
Here is the source Code: (Expression text/code)
string = "arg1, arg2, arg3, arg4, arg5, arg6";
array = string.split(",");
l = array.length;
sek = Math.floor(time);
if(sek "write here the smaller Sign in" l){
array[sek];
}else{
"End of Data";
}

[@carloshenriquenascimento6027]

Great! You give me a big help in this tutorial. Thank you so much!

[@juergenws]

Hi Erwin, thank you very much - I was looking for something like this for a while!Cheers

[@MishalMr97]

Good one!

[@ronaldeliassenhole]

Great video. But could you make the code available in the info text? It would save some time writing it off the video. thx.

[@exitparadise2244]

Can I set "sek" = to the actual time data from excel ?

[@veltins74]

Thanks a lot. I now can make unique data driven number counters for my motion graphics data vizzes. :-)

[@veltins74]

It will save a lot of time.

[@SuperHebbe]

Thanks :D This helped me a lot :D Now I can make my own cool animated HR and more from that data :D

[@alxcastro95]

tkns i give it a try

[@denzelvanlent7031]

Do you know how to do this with .srt data? I want to have the data of my dji fpv drone FE: latency “variable x” and animate a diagram based upon data x

[@abhishekpavani1779]

Hey Erwin, does this scripting work only in after effects or is it also possible in premiere pro? I have been trying to find something similar in premiere pro but I couldn't. Can you help me?

[@madaripurgraphicsclubclub7789]

Namoskar, Hi i am Bangladeshi. Plz Help Me. I need every 10 frame change text. Now chane 1 sec. PLZ Help;

[@bdoernberg]

Thanks so much for the help!!!

[@gspacec7772]

How can i change the time to show the data. I want to change the data every 5 seconds.

[@ErwinTrummer]

sek = Math.floor(5*time) or sek = Math.floor(time/5) not sure yet, try it!

[@michelcambray6496]

sek=Math.floor(time/5)

[@vijfmm5055]

Beste Meneer Trummer, `U heeft nog altijd niet gereageerd. Ik zou het ten zeerste appreciëren als u reageert. Met vriendelijke groeten, Vijf MM

[@vijfmm5055]

Hi Erwin the data does NOT appear, what I'm doing wrong???

[@vijfmm5055]

Hello, this takes long???

[@vijfmm5055]

Knock knock, who's there, NOT ERWIN!

[@vijfmm5055]

Hello Erwin?

[@vijfmm5055]

Erwin?

[@vijfmm5055]

Thanks for the quick response, NOT!

[@vijfmm5055]

Hello?

[@ErwinTrummer]

HELLO!!

[@vijfmm5055]

how are you @@ErwinTrummer

[@vijfmm5055]

You only do this for the money!

[@vijfmm5055]

Erwin?

[@vijfmm5055]

Hello?

[@vijfmm5055]

Erwin?

[@vijfmm5055]

Hello?