About this SRT to CSV converter
A spreadsheet is the easiest place to review, translate, or analyze subtitles: you can sort by length, spot lines that stay on screen too briefly, or hand a column to a translator. This converter turns every SRT subtitle into a CSV row with index, start, end, duration, and text columns. Times can be decimal seconds, which are easy to calculate with, or the original SRT timestamps. Multi-line subtitles are joined with a space, and values containing commas or quotes are quoted correctly so spreadsheets read them in one cell. The timeline shows where subtitles fall across the video.
How to convert SRT to CSV
- Add the subtitles. Paste the SRT text or open the .srt file, or press an example.
- Pick the columns. Choose decimal seconds or timestamps, and add word and character counts if you need them.
- Convert and open. Press Convert to CSV, download the file, and open it in Excel, Numbers, or Google Sheets.
Frequently asked questions
Which columns does the CSV have?
Every row has index, start, end, duration, and text. With counts turned on, word_count and char_count columns are added at the end.
Should I use decimal seconds or timestamps?
Decimal seconds such as 3.500 are easiest for formulas, charts, and sorting. Timestamps keep the familiar SRT look and are better if the CSV will be converted back to SRT.
How are two-line subtitles stored?
The lines are joined with a space into one text cell, so each subtitle stays on a single spreadsheet row.
Can I convert the CSV back to SRT?
Yes. Keep the start, end, and text columns and use the CSV to SRT converter, which reads both decimal seconds and timestamps.
Why does Excel show strange characters?
The file is UTF-8. If accented letters look wrong, import it with Data → From Text/CSV and choose UTF-8, or open it in Google Sheets.