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

Community Beginner ,
Sep 19, 2022 Sep 19, 2022

Copy link to clipboard

Copied

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

TOPICS
Expressions , Scripting

Views

49

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 19, 2022 Sep 19, 2022

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
Sep 19, 2022 Sep 19, 2022

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Sep 19, 2022 Sep 19, 2022

Copy link to clipboard

Copied

Thank you very much both ! 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 19, 2022 Sep 19, 2022

Copy link to clipboard

Copied

LATEST

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:

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines