Joshua has work experience in manufacturing, distribution, and aerospace. He received his BBA in accounting from Kent State University.
If you have ever wanted to abstract the script out of a YouTube Video so that you can read it in paragraph form without the having to looking at time stamps, you came to the right place. Here I will show you the simple steps to create a transcript in word from a any YouTube video that has a transcript available.
Make the YouTube Transcript Visible
To copy a transcript from a video go to that video and find the three dots beside the save button. Click on those three dots and click on the open transcript option. The transcript will show up on the right side of the video.
Copy the YouTube Transcript
Now you can copy the complete transcript by selecting each line of the transcript from zero seconds to the end, right clicking on that text and selecting copy.
Paste the Text Into Word
Open a Microsoft Word file and paste the transcript into it.
If you don't want to deal with the sloppy looking formatting of the copied transcript, you can clean it up no matter how long it is. As you can see in the illustration above, the transcript looks a little sloppy with the time stamps. What you can do to clean this text up is to create a macro that will remove the time stamp and space the lines properly. More specifically, you can record yourself editing the spacing on one line and save that process. Next, activate the process with a short cut key that you assign that will initiate the process.
Make sure the cursor is on the bottom left-hand corner of the last line of text. Before recording a macro it's a good idea to review the process that you are going to record before starting. The goal is to remove the time stamps and condense the lines of the transcript.
Starting the Macro Recording
To start recording the macro, click on the record macro button in the bottom left-hand corner of the screen.
The Record Macro Button
The record macro window should appear. Name the macro if you wish and create a keyboard shortcut by clicking on the button with the keyboard on it. Create a short short cut by clicking in the short cut box and making a short cut like Ctrl + j. Next, click the assign button followed by the close button to start the recording.
Assigning a Short Cut
The steps to record this macro is very distinct. See the following steps below:
1. Begin with the cursor at the beginning of the last line. The needs to be completed before the macro is recorded.
2. Backspace until the last line meets the next line up.
3. Create a space between the two lines that were merged.
4. Send the cursor to the beginning of the last line by using the home key.
5. Click on the macro stop button (the square shape in the lower left-hand corner).
Repeat the Process by Running the Macro
To clean up the whole transcript place the cursor at the beginning of the last line and use the short cut keys that were assigned to the macro to clear out all the time stamps and spacing line by line. The final result will be one large paragraph like my result in the illustration below.
To make the process faster, I could have recorded myself repeating a the process a few times before I stopped recording.
Saving the Word Document as Macro-Enabled
If you would like to use the macro in this Word document in the future for other transcripts, you will have to save the workbook as a Word macro-enabled document.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2020 Joshua Crowder