Parse 1 or more srt files into a consolidated csv file, for clean use in SQL databases or elsewhere.
- Clone the code to your computer, following the instructions from Github
- Place your .srt files in the
srt_inputfolder - In your terminal, execute the command
node parse.js(requires NodeJS to be installed on your system) - The individual .csv files will be in the
csv_outputfolder! - Optional: use a website like Merge CSV to combine all your .csv files into a single file for easier import and/or editing.
Livestreamers using the OBS Caption Plugin (or other plugins that generate subtitle files) are now fully able to take the folder of subtitle files (srt) and convert them easily to comma-separated values (csv) files. You can then import them into Excel, Google Sheets or more advanced software or databases in order to do various types of analysis.
Credit where credit is due - I had a lot of help building this while live on Twitch and so I owe many thanks to:
- Stoney_Eagle
- Pandapoopums
- Nathnolt
- ExegeteIO