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

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:

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

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