<p>I think you want this to be done automatically. But f course you could create 1000 text overlays, each one showing a particular altitude, and place the correct overlay at the correct point in the timeline for the correct duration (1/4 second). That would be a terribly tedious job!</p>

CC BY-SA 3.0
2018-03-02T23:15:57.540Z
Please don't post an answer if you already know that that's not the solution that anyone is looking for.
Hendriks3D
CC BY-SA 3.0
2018-03-03T14:21:02.027Z
I don't know you, so I didn't know if you are a person who minds tedious jobs. Some people don't. You'd just asked whether Sony Vegas _could_ do it, and this will work. Again, the only confusion was that I don't know _you_ so I didn't know how much experience you have with editing. Some newcomers honestly don't know that they can add text over their videos on the frames they want!
BrettFromLA
CC BY-SA 3.0
2018-03-03T15:44:38.370Z
Haha, okay I understand. Sorry. I have done lots of tedious jobs in the past, though I'm not even sure if I Sony Vegas is going to keep up with little over a thousand little text tracks. I'm running an AMD FX 8350 CPU, which isn't all that stable with video editing.
Hendriks3D
CC BY-SA 3.0
2018-03-03T17:39:33.040Z
It sounds like a really cool project though! I hope someone else has an automated solution for you. Maybe FFMPEG can accomplish what you want? I've never used it, but I've seen a lot of questions and answers about it in this community. FFMPEG has command-line features (I think) that can handle some bulk / repetitive tasks.
BrettFromLA
CC BY-SA 3.0
2018-03-02T18:22:19.557Z
2018-03-02T18:22:19.557Z
BrettFromLA
<p>The best way to do it is with Vegas scripting. I have not used it myself but it should be able to accomplish what you're looking for. </p>

<p><a href="https://www.vegascreativesoftware.com/us/downloads/#c24726" rel="nofollow noreferrer">https://www.vegascreativesoftware.com/us/downloads/#c24726</a> </p>

CC BY-SA 4.0
2018-07-03T19:51:34.567Z
2018-07-03T19:51:34.567Z
qwr
<p>If you have Excel, presumably you have PowerPoint? If so, there may be a way to get what you’re looking for that way. The basic idea would be something like this:</p>

<ol>
<li>Construct a chart using the Excel data;</li>
<li>Put that into PowerPoint as a single slide;</li>
<li>Animate the slide, suppressing the visual items you do not want to appear;</li>
<li>Capture the actual running of that animation with something like Screenflow;</li>
<li>Pull the resulting clip into Vegas and stretch it to cover the required time of the rocket flight</li>
<li>Lie down in a dark room to recover from the effort</li>
</ol>

<p>The trick is to choose the most appropriate chart to begin with, with the appropriate chart options, and to then suppress the undesired elements in PP. Done right, you could get anything from as complex as the actual chart series lines, all the way down to nothing but the simple numbers you talk about. I’d do as much as possible of the heavy lifting <em>in</em> Excel, and even prior to creating the chart. Consider things like splitting the data points into series that then all use the same x axis values. That’s the kind of thing that would let you get the consecutive numbers to be located at the same point in your video.  </p>

<p>Dunno. If you’re strong on Excel and on PowerPoint animations, give it a ponder?</p>

CC BY-SA 4.0
2018-10-02T03:16:27.970Z
2018-10-02T17:38:55.580Z
2018-10-02T17:38:55.580Z
tkp
<p>A friend and I recently launched a model rocket. We had installed an altitudemeter that exports all it's data for each quarter second into an Excel document. I want to take the data of the time and height of this document (about 1000 time steps) and use it to have a live altimeter in the top of the screen on the video using Vegas Pro 13. I basically want it to count the height live with the video. Does anyone know if this is possible in Sony Vegas?
The best thing for me would be that it follows a graph so that the text doesn't change every quarter second, but every frame. If this can be done, it would be easier, because then I don't have to use every single step of time from Excel, but every 10 steps or so. It will still be accurate and smooth, though less of an annoying job.</p>

CC BY-SA 3.0
2018-03-03T16:08:15.440Z
You might want to look into using telemetry software, [Dashware](http://www.dashware.net/) for example is free.
Ambo100
<vegas-pro>
Text according to Excel document
Hendriks3D
# Text according to Excel document

(Asked by: username_0 on 2018-03-02)

A friend and I recently launched a model rocket. We had installed an altitudemeter that exports all it's data for each quarter second into an Excel document. I want to take the data of the time and height of this document (about 1000 time steps) and use it to have a live altimeter in the top of the screen on the video using Vegas Pro 13. I basically want it to count the height live with the video. Does anyone know if this is possible in Sony Vegas?
The best thing for me would be that it follows a graph so that the text doesn't change every quarter second, but every frame. If this can be done, it would be easier, because then I don't have to use every single step of time from Excel, but every 10 steps or so. It will still be accurate and smooth, though less of an annoying job.

**Tags:** vegas-pro

> **Comments:**
> **username_1**: You might want to look into using telemetry software, [Dashware](http://www.dashware.net/) for example is free.  

---

## 3 answers

### Answer by username_2 on 2018-03-02. Score: 0

I think you want this to be done automatically. But f course you could create 1000 text overlays, each one showing a particular altitude, and place the correct overlay at the correct point in the timeline for the correct duration (1/4 second). That would be a terribly tedious job!

> **Comments:**
> **username_0**: Please don't post an answer if you already know that that's not the solution that anyone is looking for.  
> **username_2**: I don't know you, so I didn't know if you are a person who minds tedious jobs. Some people don't. You'd just asked whether Sony Vegas _could_ do it, and this will work. Again, the only confusion was that I don't know _you_ so I didn't know how much experience you have with editing. Some newcomers honestly don't know that they can add text over their videos on the frames they want!  
> **username_0**: Haha, okay I understand. Sorry. I have done lots of tedious jobs in the past, though I'm not even sure if I Sony Vegas is going to keep up with little over a thousand little text tracks. I'm running an AMD FX 8350 CPU, which isn't all that stable with video editing.  
> **username_2**: It sounds like a really cool project though! I hope someone else has an automated solution for you. Maybe FFMPEG can accomplish what you want? I've never used it, but I've seen a lot of questions and answers about it in this community. FFMPEG has command-line features (I think) that can handle some bulk / repetitive tasks.  

---

### Answer by username_3 on 2018-07-03. Score: 0

The best way to do it is with Vegas scripting. I have not used it myself but it should be able to accomplish what you're looking for.

<https://www.vegascreativesoftware.com/us/downloads/#c24726>


---

### Answer by username_4 on 2018-10-02. Score: 0

If you have Excel, presumably you have PowerPoint? If so, there may be a way to get what you’re looking for that way. The basic idea would be something like this:

1. Construct a chart using the Excel data;
2. Put that into PowerPoint as a single slide;
3. Animate the slide, suppressing the visual items you do not want to appear;
4. Capture the actual running of that animation with something like Screenflow;
5. Pull the resulting clip into Vegas and stretch it to cover the required time of the rocket flight
6. Lie down in a dark room to recover from the effort

The trick is to choose the most appropriate chart to begin with, with the appropriate chart options, and to then suppress the undesired elements in PP. Done right, you could get anything from as complex as the actual chart series lines, all the way down to nothing but the simple numbers you talk about. I’d do as much as possible of the heavy lifting *in* Excel, and even prior to creating the chart. Consider things like splitting the data points into series that then all use the same x axis values. That’s the kind of thing that would let you get the consecutive numbers to be located at the same point in your video.

Dunno. If you’re strong on Excel and on PowerPoint animations, give it a ponder?


---

