Is it possible to get data from csv with different sheets - footage expression

[claire334]

Hi,

I want to get data from a csv file.

This file has differents sheets.

I can get data with simple csv file (without sheets) and expression.

But is it to possible to get data and navigate into the sheets to get the data i want.

Thank you in advance

[Mylenium]

By definition a CSV cannot have different sheets. That's merely some extra info Excel generates for reimporting the data. So, no. You need to export them separately and link them individualyl just as well.

Mylenium

[Arie Stavchansky]

Hi There,

This is definitely possible with Adobe's built-in tool set.  You import the CSV as footage layer type and then use its layer properties in that CSV in the expression.  You can possibly pick-whip specific CSV properties while your cursor is in the expression editor.

You can also easily accomplish this with Templater for After Effects.  It supports TSV (tabbed-separate value files) along with cloud-based Google Sheets, among other data source types.

You can read this article on how to get dynamic data into expressions.

Hope these references help!

—Arie

[claire334]

Thank you very much both ! 

[Mathias Moehl]

As Mylenium said, csv files cannot include multiple sheets.

See https://stackoverflow.com/questions/29615196/is-csv-with-multi-tabs-sheet-possible

So most likely, you have to export a separate csv file for each sheet.

By the waay, my extension Automation Blocks also offers an easy and powerful csv file workflow for After Effects:

[video]