SRT to CSV converter Review your subtitles in a spreadsheet.
To convert SRT to CSV, paste the subtitles or drop the file and pick a separator. Every caption becomes one row with four columns: index, start, end and text. The file is UTF-8 with a BOM, so Excel, Google Sheets and LibreOffice open it with accents and special characters intact.
Free, no sign-upSecond file
For example, the video name and the version up for approval.
This text has no timings. We will build subtitles from reading speed: each line or sentence becomes a block of up to 2 lines.
The JSON has a time for every word. We cut blocks of up to 2 lines of 42 characters, at sentence ends and pauses.
Subtitle report
- Subtitles
- Duration
- Words
- Average CPS
- Max CPS
- Flagged
| # | Time | Duration | Text | Characters per line | CPS | Flags |
|---|
How to convert SRT to CSV
- 01
Bring in the SRT
Drop the file or paste its content. We detect the encoding, including older subtitles saved as Windows-1252.
- 02
Choose the separator
Comma for Excel set to US English and for Google Sheets, semicolon for Excel set to most European and Latin American regions.
- 03
Download and open it
One caption per row. Check the report for captions that read too fast or run too long before you send the sheet out for review.
Why put subtitles in a spreadsheet
SRT is built for players, not for people reviewing text. In a spreadsheet, every caption sits on its own row, so you can filter, leave a comment on a single cell, highlight what needs fixing and send it to a client who has no subtitle software. Translators work with the text column right next to the source, and QC reviewers can count rows and scan timings at a glance.
CSV is the plainest kind of table: text, one record per line, columns split by a single character. Excel, Google Sheets, LibreOffice Calc and Numbers all open it natively. Here is what changes on the way from SRT.
| In the SRT | In the CSV |
|---|---|
| Cue number | index column |
| 00:00:01,200 --> 00:00:04,000 | start and end columns, with a period |
| Two-line caption | Line break kept inside the cell |
| Any text encoding | UTF-8 with BOM |
| Cues split by blank lines | One row per caption |
The same captions as SRT and as CSV
The header is always index, start, end and text, in that order. Times are written as 00:00:01.200, with a period before the milliseconds so they never clash with a comma separator. When a caption has two lines, the text is wrapped in quotes and the line break stays, visible inside the cell.
SRT
1
00:00:01,200 --> 00:00:04,000
Good morning, church! It's so good
to have you here today.
2
00:00:04,300 --> 00:00:06,100
Open your Bibles to John 3:16.
CSV
index,start,end,text
1,00:00:01.200,00:00:04.000,"Good morning, church! It's so good
to have you here today."
2,00:00:04.300,00:00:06.100,Open your Bibles to John 3:16.Comma or semicolon? And why Excel rewrites your times
Excel splits a CSV using the list separator from your system's regional settings. In the US that is a comma. In countries where the comma is the decimal mark, such as Brazil, Germany or Spain, it is a semicolon, and a comma-separated file lands entirely in column A. Pick the one that matches the machine that will open the file. Google Sheets reads both.
The BOM is an invisible marker at the start of the file that tells Excel the text is UTF-8. Without it, names like "José" turn into "José".
The other surprise is timing. Double-click the CSV and Excel may read 00:00:01.200 as a time of day and display 00:01.2. To keep the text exactly as written:
- Excel: go to Data, From Text/CSV, click Transform Data and set the start and end columns to Text.
- Google Sheets: in File, Import, uncheck the option to convert text to numbers, dates and formulas.
- LibreOffice Calc: in the import dialog, set the time columns to Text before you confirm.
From the spreadsheet back to SRT
Once the review or translation is done, save the sheet as CSV and bring it back to the converter. It reads CSV too: it detects commas, semicolons or tabs, finds the columns by header name or by position, and accepts times like 00:00:01,200 or plain seconds. Pick SRT, VTT or ASS as the output.
On the way back, the report becomes your QC pass. Translations tend to run longer, and the table flags every caption above 17 characters per second or 42 characters per line. If a translator ended up with two captions on the same time, the fix overlaps option trims the earlier one.
More than subtitles in a spreadsheet. Get them straight from your video.
See also
Frequently asked questions
Why does the whole CSV land in one column in Excel?
Because the file's separator is not the one your Excel expects. US English Excel splits on commas; many other regions split on semicolons. Convert again with the other separator, or in Excel use Data, From Text/CSV and choose the delimiter in the import window.
Why does Excel show 00:01.2 instead of the full time?
Excel read 00:00:01.200 as a time of day and applied its own format. To see the value as written, import through Data, From Text/CSV and set the start and end columns to Text. If you save after Excel has reformatted them, the CSV keeps the wrong times.
Can I translate subtitles in the sheet and turn them back into SRT?
Yes. Replace the contents of the text column with the translation, leave the time columns alone and save as CSV. Bring the file back to the converter and choose SRT. The report shows which translated captions ended up too long or too fast to read.
Accents look broken in the spreadsheet. What now?
The CSV we create is UTF-8 with a BOM, and Excel relies on that marker to show accents. If the problem appears after saving in Excel, pick CSV UTF-8 from the file type list instead of plain CSV, which uses an older encoding.
How do I send subtitles to a client for approval?
Upload the CSV to Google Drive and open it with Google Sheets. Your client comments right on the cell of each caption, with no subtitle software to install. An extra status or notes column does not get in the way of the trip back to SRT, because we read columns by name.
How many captions fit in the CSV, and how do I count them?
All of them, one per row, with the header on the first row. The last row number minus one is your total. The converter's report already shows that count, plus the duration, the word count and how many captions have a warning.
Want to review subtitles without building a sheet? We transcribe the video.
Upload the video or paste a YouTube link. We transcribe every line with its timing, you fix it right in the text, and you download SRT, TXT or PDF.
See the result on your own recording before adding a card.