Transcript your interviews for free
Did you know Youtube is doing a great job at transcribing your interviews and phone calls? Of course where the law allows you to record, blah blah.
- If you recorded your interview/call on your phone, make a video by adding a few pictures and upload directly from your phone. I use VideoShow but if you found a better app, feel free to share in comments.
- Upload your video to your youtube account as “public” (not listed or private won’t work).
- Go to your video URL, example with a great public video: https://www.youtube.com/watch?v=ziwYbVx_-qg
- Copy the video ID from the URL (ziwYbVx_-qg) and paste it at the end of this url to get the transcript in XML:
http://video.google.com/timedtext?lang=en&v=ziwYbVx_-qg
- Copy paste the XML content in a converter like http://www.becsv.com/xml-csv.php
- You might remove the first line, usually browser doesn’t like XML :)
- Choose your separator and convert to csv
- Copy paste in Excel or save and upload to Google Spreadsheet
- In Excel, select first column only, go to Data menu then “Convert” and choose the right delimiter (separator)
- You get your text with, and without, timestamps:
- Time to modify your text:
- To help you gather all text as one sentence, here’s a Find/Replace process in 2 steps that only works in Developers notepads like Notepad++:
- Find+replace all \r\n (carriage returns and new lines) with “ ” (one space) to get everything on one line.
- Now find/replace \. with .\n for instance and you get one sentence per line
“President Obama still has eight months left in office before his second term is up.
Naturally, this is a time to look back on all he’s accomplished over the past eight years.
You know, I was going to make a joke about this, but I — ”
Ok, here’s the video, you deserve it super user.