<p>Is there a way to read a CSV file or spreadsheet containing dates in timecode in one column and data in another column, then use the time/date to pair with footage to display the corresponding data?</p>

<p>Let's say I have a spreadsheet or csv with the number of sales a company has made in one column and in the other column a timestamp by the second or minute of when the sale was made. I then want to create a video showing in "real time" how many sales are being made during the action on screen.</p>

<p>I've seen a tutorial on reading arrays and importing that data into individual comps, but I'm wondering how I can sync data with video</p>

CC BY-SA 3.0
2016-09-23T06:14:13.683Z
It's a bit unclear what you're asking. When you say "in real time" you don't mean you want it to change as the data changes? If so you're using the wrong ap. I you want to do a graph then yes, you can do it with expressions, but it might be easier to do it in Excel or illustrator and then animate in AE.
stib
CC BY-SA 3.0
2016-09-23T19:36:30.860Z
Not in real time in that way, as if the video is live, but rather to give the impression that the numbers updating correspond with the time within the video.

I am basically looking for a way to auto create text based on a spreadsheet, and have it be synced with footage.
auto
CC BY-SA 3.0
2016-09-24T11:15:03.810Z
So what is it you want to know? For how to  import data into expressions look here: http://blob.pureandapplied.com.au/using-data-from-an-external-file-to-drive-expressions/
stib
<after-effects><premiere><after-effects-expressions><after-effects-scripting>
Expressions: Data-generated After Effects Graphic using CSV file?
auto
# Expressions: Data-generated After Effects Graphic using CSV file?

(Asked by: username_0 on 2016-09-21)

Is there a way to read a CSV file or spreadsheet containing dates in timecode in one column and data in another column, then use the time/date to pair with footage to display the corresponding data?

Let's say I have a spreadsheet or csv with the number of sales a company has made in one column and in the other column a timestamp by the second or minute of when the sale was made. I then want to create a video showing in "real time" how many sales are being made during the action on screen.

I've seen a tutorial on reading arrays and importing that data into individual comps, but I'm wondering how I can sync data with video

**Tags:** after-effects, premiere, after-effects-expressions, after-effects-scripting

> **Comments:**
> **username_1**: It's a bit unclear what you're asking. When you say "in real time" you don't mean you want it to change as the data changes? If so you're using the wrong ap. I you want to do a graph then yes, you can do it with expressions, but it might be easier to do it in Excel or illustrator and then animate in AE.  
> **username_0**: Not in real time in that way, as if the video is live, but rather to give the impression that the numbers updating correspond with the time within the video.  I am basically looking for a way to username_0 create text based on a spreadsheet, and have it be synced with footage.  
> **username_1**: So what is it you want to know? For how to  import data into expressions look here: http://blob.pureandapplied.com.au/using-data-from-an-external-file-to-drive-expressions/  

---

## 0 answers

