Body: <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>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-09-23T06:14:13.683Z
Comments.Text: 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.
Comments.UserDisplayName: stib
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-09-23T19:36:30.860Z
Comments.Text: 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.
Comments.UserDisplayName: auto
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-09-24T11:15:03.810Z
Comments.Text: 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/
Comments.UserDisplayName: stib
Tags: <after-effects><premiere><after-effects-expressions><after-effects-scripting>
Title: Expressions: Data-generated After Effects Graphic using CSV file?
UserDisplayName: auto
ThreadText: # 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
  
  