error importing numbers from csv data

error importing numbers from csv data

Created by Tibo
3 Months Ago
May 5, 2020 @ 1:32 pm

Seems to be an issue with the way numbers larger than 32768 are imported into AE from a CSV file for data-driven animations.

Steps to reproduce:

1 - Import CSV with numbers smaller and larger than 32768 and add to comp.

2 - Drag out Number data from CSV to composition.

3 - Notice that any numbers larger that 32768 are imported as being "32768" (E.g: Number data point should be 40,000, imports into AE as 32768.

3 Months Ago
May 12, 2020 @ 6:14 pm

After Effects seems to limit the range of values you can import via CSV. That is because it uses 16bit integers internally so the values supported would be −32,768 to 32,767. Anything above or below that would be capped.

You could scale your values in the spreadsheet - that'd still give you the correct animation, but you may have to change the labels you use to match the 'actual' values you want to display.

For an actual 'bug fix' you'd have to contact Adobe support or raise a technical issue / bug with them

Hope that helps!


& to join the conversation - it's free


Get in touch via social media


Tobias Avatar
I am passionate about providing high quality VFX & Film Making Edutainment online. Check out my training courses on Udemy
© 2020 Surfaced Studio