<p>I typed up a transcript of a video, and inserted time stamps at the beginning of each change of speaker, using <a href="https://transcribe.wreally.com/" rel="nofollow noreferrer">https://transcribe.wreally.com/</a>.  Then I put everything into Excel.  I copied the timestamp column and pasted it into a new column to its right, but moving the whole thing up one row.  I figured that would make the segments abut perfectly.  I added an empty additional column where the program would expect to see where each segment ended (where the new one start.</p>

<p>Then I followed the instructions at <a href="https://video.stackexchange.com/a/14518/19609">https://video.stackexchange.com/a/14518/19609</a> and installed <a href="http://www.nikse.dk/SubtitleEdit" rel="nofollow noreferrer">Subtitle Edit</a>.  I tried pasting the columns of data in, and I tried opening the tab-delimited file I had made.  It's giving me nonsense in the second column (which indicates the end timestamp).</p>

<p>What software and method can I use for getting my typed transcript into a properly formatted srt file, so I can publish it with Youtube?</p>

CC BY-SA 3.0
2017-07-29T15:01:00.623Z
Sometimes YouTube will generate subtitles for you. You might be doing work you don't have to do anyway.
user3643
CC BY-SA 3.0
2017-07-30T18:19:16.067Z
Turns out my timestamps were all shifted.  When I corrected them things worked. "Subtitle Edit" (free, open source) was helpful and not as resource-hoggy as Aegisub -- https://en.wikipedia.org/wiki/Subtitle_Edit. // @DigiVisionMedia - as I was fiddling around, I experimented with the automatic captioning.  It worked on a short segment but not on the whole recording, which was quite long.  Also, since there were multiple speakers, less than optimal audio quality, and some overlapping voices, the automatically generated transcript was of limited usefulness.
aparente001
CC BY-SA 3.0
2017-07-30T19:12:23.610Z
Yes, that's been my experience too. I can't seem to find any logic behind YouTube's automatic caption decisions. It seems there's a sweet spot for length and content. It's not too useful to me either (my content is mostly one hour lectures) mostly because it's unpredictable.
user3643
<video><subtitles>
Import Excel file with subtitles and timestamps
aparente001
# Import Excel file with subtitles and timestamps

(Asked by: username_0 on 2017-07-29)

I typed up a transcript of a video, and inserted time stamps at the beginning of each change of speaker, using <https://transcribe.wreally.com/>. Then I put everything into Excel. I copied the timestamp column and pasted it into a new column to its right, but moving the whole thing up one row. I figured that would make the segments abut perfectly. I added an empty additional column where the program would expect to see where each segment ended (where the new one start.

Then I followed the instructions at <https://video.stackexchange.com/a/14518/19609> and installed [Subtitle Edit](http://www.nikse.dk/SubtitleEdit). I tried pasting the columns of data in, and I tried opening the tab-delimited file I had made. It's giving me nonsense in the second column (which indicates the end timestamp).

What software and method can I use for getting my typed transcript into a properly formatted srt file, so I can publish it with Youtube?

**Tags:** video, subtitles

> **Comments:**
> **username_1**: Sometimes YouTube will generate subtitles for you. You might be doing work you don't have to do anyway.  
> **username_0**: Turns out my timestamps were all shifted.  When I corrected them things worked. "Subtitle Edit" (free, open source) was helpful and not as resource-hoggy as Aegisub -- https://en.wikipedia.org/wiki/Subtitle_Edit. // @DigiVisionMedia - as I was fiddling around, I experimented with the automatic captioning.  It worked on a short segment but not on the whole recording, which was quite long.  Also, since there were multiple speakers, less than optimal audio quality, and some overlapping voices, the automatically generated transcript was of limited usefulness.  
> **username_1**: Yes, that's been my experience too. I can't seem to find any logic behind YouTube's automatic caption decisions. It seems there's a sweet spot for length and content. It's not too useful to me either (my content is mostly one hour lectures) mostly because it's unpredictable.  

---

## 0 answers

