I realise that more-and-more researchers are using social media as data sources or training resources, hence it seems useful to be able to extract the text from the video. There are tools out there that will do this, but all you really need are Excel and Word. YouTube provides transcripts of videos for you, but the format isn’t great.
Rather than put my method in detail here, I’ve created a PDF file you can have for reference. Hope it’s useful.