I’ve been thinking about ways to watch a program in Spanish and then have it transcribed and then put it into a spreadsheet with English translation so I can upload it into a flash card app and study sentence by sentence (opposed to word by word.)
I do know how to get the transcription via an app by recording the audio. But the next step of putting the manuscript into a two column spreadsheet translated automatically sentence by sentence is so far elusive for me. I could do it manually but the magnitude of even one transcription would be too time-consuming. And learning Python or something similar to automate would mean learning Python instead of Spanish.
Does anyone know a solution? Thank you for any help or suggestions.