Subtitle data
How to Convert SRT Subtitles to CSV
Convert SRT subtitles to CSV rows for spreadsheet review while preserving timestamps, multiline captions, commas, encoding and cue order.
A cue normally becomes a row containing its number, start time, end time and text. A multiline caption must remain a quoted CSV field so its line break does not create a false row.
The key idea
Open the output in a UTF-8-aware spreadsheet and check commas, accents and timestamp formatting. Spreadsheets may automatically reinterpret time-looking values, so preserve timestamps as text when needed.
How subtitle cues become CSV rows
A useful subtitle CSV normally includes cue number, start time, end time and text. One cue must remain one logical row even when its caption contains a line break. Correct CSV quoting protects commas, quotation marks and multiline text from being mistaken for new columns.
id,start,end,text
1,00:00:01.000,00:00:03.500,"Hello, everyone."
2,00:00:04.000,00:00:06.000,"First line / Second line"Prevent timestamp damage
Spreadsheet applications may reinterpret timestamps as dates, times or formulas. Import the CSV as UTF-8 and set timing columns to text. If 00:01:02,500 loses its milliseconds, correct the import settings before editing more rows.
Useful reasons to create subtitle CSV
- Add reviewer comments or speaker labels.
- Filter cues containing a term.
- Compare captions with a script.
- Calculate cue duration and reading speed.
- Assign translation or approval status.
CSV is a review format, not usually the final video caption format. Use the SRT to CSV converter for extraction and preserve the original SRT.
Editing and converting back safely
Do not rename required columns, sort only part of the sheet or let a line break split a cue. Export as UTF-8 CSV and inspect the result in a text editor. For web captions, use the SRT to VTT converter. After any round trip, validate order, overlaps and timestamps against the video.
A practical workflow
CSV is useful for sorting cues, adding review notes and filtering long captions. Use the subtitle-duration and overlap checkers on the caption file after editing.
Checks and limitations
When the review is complete, convert back only if the columns still match the expected format. Keep both the original SRT and edited CSV so changes can be traced.
Check the result in the working tool
Open the SRT to CSV converter with the same values used in the example. Read the labels and units beside the result, then keep the source information until the output has been checked for its intended use.
Quick answers
Frequently asked questions
Can I edit subtitle text in a spreadsheet?
Yes, provided you preserve the expected columns, encoding and timestamp values.
Why are commas breaking my subtitle text?
Text containing commas must be enclosed in CSV quotes, and embedded quote marks must be escaped. Use a parser rather than splitting rows manually.
Can Excel open the result?
Yes. Import it as UTF-8 and protect timestamp columns as text so Excel does not reinterpret or round caption timing.
Does SRT to CSV preserve multiline captions?
It should keep the complete cue in one quoted CSV field. Check a known multiline cue after conversion because spreadsheet display settings can make embedded line breaks difficult to see.
Use the tool