Jump to content

Help: Youtube Transcript Extractor


Recommended Posts

Hi guys,

Just now getting into coding and got a wild hair and bought Alfred! It's been incredible! 

 

I like to take the youtube transcript from videos and follow along for easier note taking.

I know very little about coding and just made my first workflow to open a pdf search the query (it took all day). In other words, I could really use some help.

 

Here are the steps I use to turn the transcript into a word document:

  1. On chrome, open and copy transcript from youtube 
  2. Paste into excel and apply formula "=MOD(ROW(),2)" in the adjacent column and extend all the way down
  3. Create table with 2 columns and filter the number column to hide the blank spaces
  4. Next I open word and paste the column of the table containing text
  5. Finally In word Find > Replace > Paragraph mark to Space bar to delete extra space

 

 

This is extremely complicated using the mouse, i could not imagine the code needed to do this.

I'm not lazy I swear but this is WAY above my head

Screen Shot 2022-01-07 at 8.05.47 PM.png

Link to comment
1 hour ago, zlc1952 said:

This is extremely complicated using the mouse, i could not imagine the code needed to do this.

 

Mice are for humans, not computers. Do not try to make the computer use the user interface.

 

What is the actual task without all the Excel nonsense? What goes in and what comes out?

Link to comment
9 hours ago, deanishe said:

What goes in and what comes out?


@zlc1952 When you answer this, please make sure to be specific. For example, which format is the transcript in? Also, it will help if you provide one and/or the steps you’re using to extract it.

Link to comment
  • 2 weeks later...
On 1/7/2022 at 9:52 PM, deanishe said:

 

Mice are for humans, not computers. Do not try to make the computer use the user interface.

 

What is the actual task without all the Excel nonsense? What goes in and what comes out?

I double click the first cell (A1) and paste the copied youtube transcript.

 

Column B is a formula that i apply to the entire column to assign a 0 or 1. (this is for filtering later on)

Column C is for directions for column B if I forget the formula.

 

 

 

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...