Convert SRT to CSV
Export subtitles to CSV for translation, review or QA in a spreadsheet. Proper quoting, timecodes in two forms, and a clean route back to SRT.
A spreadsheet is where subtitle work that involves other people actually happens: sending dialogue to a translator, running a terminology check, letting a client comment line by line. CSV is how a subtitle file gets there. The awkward part is that subtitle text contains exactly the characters CSV treats as structure — commas, quotation marks and line breaks — so a naive export corrupts rows in ways that only surface after someone has done a day of work in them.
Worth knowing
- Every field is quoted when it needs to be, following RFC 4180: commas, double quotes and line breaks inside dialogue survive the round trip instead of splitting a row.
- Timecodes are written with a dot (00:00:01.000) rather than SRT's comma, so a spreadsheet does not have to quote them and a stray comma cannot shift the columns.
- Both spellings of every time are exported: readable timecodes for humans, and startMs/endMs columns for formulas, sorting and scripts.
- Reading a CSV back in maps columns by header name in any order, so a file that has been rearranged in a spreadsheet still imports correctly.
FAQ
How do I get the translated text back into a subtitle file?
Save the sheet as CSV, drop it into any converter here, and pick SRT as the target. As long as the start, end and text columns are still named recognisably, the timing survives and only the dialogue changes.
Excel is mangling my timecodes into dates. What do I do?
Excel guesses types on open. Use Data → From Text/CSV and set the start and end columns to Text before importing, or work with the startMs and endMs columns, which are plain integers Excel cannot misinterpret.