SRT to CSV converter
Put subtitles into a spreadsheet to translate, review or count them. Each caption becomes one row with its number, start and end time, duration in seconds and text, so you can sort, filter and add your own columns.
Convert your subtitle file
Drop subtitle files here
SRT, VTT, ASS, SBV, TTML, SUB, SMI, LRC and more · up to 100 files
Or paste subtitle text
Your file is read by this page in your browser. It is not uploaded anywhere.
Letters look wrong? Choose the language group the file was made for.
MicroDVD and Spruce STL files count video frames. Choose the frame rate of the video the subtitles belong to.
Your result
The preview shows the beginning of the file. The download contains everything.
How to use it
Open the SRT file
Drop the .srt file, or several to get one CSV file for each.
Check the CSV preview
CSV is already selected. The first row reads Number,Start,End,Duration,Text.
Open it in your spreadsheet
Download the .csv file and open or import it in Excel, Google Sheets or LibreOffice Calc.
The columns
The first row holds the headings Number, Start, End, Duration and Text. Times are written as hours, minutes, seconds and milliseconds with a dot, such as 00:01:02.500, and the duration in seconds with three decimals, such as 2.500.
The Text column has the words without formatting. A caption with several lines keeps its line breaks inside one cell, and text with a comma, a quote or a line break is wrapped in double quotes, so every caption stays in its own row.
Before and after
Two SRT captions as CSV. The italic tags are removed, the duration is worked out from start and end, and the caption with a comma and a line break is wrapped in double quotes so it stays in one cell.
1
00:00:01,000 --> 00:00:03,500
<i>Where were you last night?</i>
2
00:00:04,000 --> 00:00:06,250
At the station,
waiting for you & the kids.Number,Start,End,Duration,Text
1,00:00:01.000,00:00:03.500,2.500,Where were you last night?
2,00:00:04.000,00:00:06.250,2.250,"At the station,
waiting for you & the kids."Opening it in a spreadsheet
The file is saved as UTF-8, which Google Sheets and LibreOffice read without help. Excel can show accented or non-Latin letters wrongly when you double-click a CSV file; import it with Data, From Text/CSV and choose UTF-8 instead.
Spreadsheets may turn the times into their own time format. To keep them exactly as written, set the Start and End columns to text when you import the file.
Translating and converting back
Type the translation into the Text column, or rename your own translation column to Text and remove the original, then save as CSV again. The CSV to SRT converter reads the Start, End and Text headings and ignores Number, Duration and any other column.
Need it the other way round? Use the CSV to SRT converter. More about these formats: Subtitle file formats explained, from SRT to Spruce STL
Questions and answers
Are italics kept in the CSV file?
No. CSV holds plain text, so formatting tags are removed. Convert the original SRT file again if you need them.
Can I get semicolons instead of commas?
This page always writes commas. If your spreadsheet expects semicolons, import the file and choose comma as the separator.
Can I check reading speed in the sheet?
Yes: divide the length of the text by the Duration column. The subtitle checker does this for you and lists the captions above your limit.