SubtitleMedic

Convert SRT to CSV

Turn SubRip subtitles into a CSV spreadsheet with number, start, end and text columns, for Excel, Google Sheets or a script.

Processed in your browserNo sign-up.srt

How to convert SRT to CSV

  1. Open your .srt file

    Drop a SubRip file into the box above, or click to browse. No file at hand? Use the .srt sample under the box.

  2. Check the rows

    The preview shows the file before and after. Each subtitle becomes one row, and “What changes” lists what the spreadsheet does differently.

  3. Download the .csv file

    The file keeps its name with the new extension: movie.srt becomes movie.csv. Open it in Excel, Google Sheets, Numbers or LibreOffice Calc.

What the spreadsheet looks like

A SubRip file is a list of numbered blocks:

1
00:00:03,120 --> 00:00:05,480
Is this seat taken?

2
00:00:06,010 --> 00:00:08,900
- Only by my coat.
- Sit, please.

The CSV puts each block on a row, with a heading row on top:

#,Start,End,Text
1,"00:00:03,120","00:00:05,480",Is this seat taken?
2,"00:00:06,010","00:00:08,900"," - Only by my coat.
- Sit, please."

The number is the order of the subtitle, from 1. It is there so you can sort the sheet back after filtering it.

Start and End are the subtitle's times, to the millisecond, written exactly as in the .srt.

Text is the subtitle. A line break inside a subtitle stays a line break inside the cell, so a spreadsheet shows two lines in one cell.

The headings are always in English, whichever language this page is in. Scripts and other tools can count on them.

Why put subtitles in a spreadsheet

Translation. Translators and agencies often work in spreadsheets: the original in one column, the translation in the next. The times stay in their own columns where nobody types over them by accident.

Review. A sheet is easy to sort, filter and comment on. You can sort by the length of the text to find lines that are too long, or filter for a name to check every line a character says.

Counting. Word counts for a quote, lines per scene, the longest subtitle: a spreadsheet formula does it in seconds.

Scripts and databases. CSV is the format every programming language and database reads without extra libraries. A subtitle file becomes a table you can query.

What changes, and what doesn't

Every word and every time is kept exactly. The spreadsheet only lays the same information out differently.

Lines that look like formulas. A spreadsheet runs any cell that starts with =, +, - or @ as a formula. That is a problem for subtitles, because dialogue lines often start with a dash. The converter puts a space in front of those cells, and "What changes" says how many. Converting back removes it.

Times as text. The comma before the milliseconds means Excel in English treats the time as text and leaves it alone. Excel set to a language that writes decimals with a comma may turn it into a time and show it as 01:02.3. Convert CSV to SRT still reads it, but if you save the sheet as CSV again, the time is saved as shown, to a tenth of a second. To avoid it entirely, use Convert SRT to Excel, which marks every time as text.

Tips

Sync before you export. If the subtitles are early or late, fix them first with Shift Subtitle Timing. It is easier on the .srt than on a sheet.

Garbled letters in the preview? The .srt is not UTF-8. Pick the right encoding next to the file name, or repair it with Fix Subtitle Encoding. The CSV is always saved as UTF-8.

Keep the times. When you translate, add a column next to Text and leave #, Start and End as they are. Convert CSV to SRT lets you pick which text column becomes the subtitles.

New to SubRip? What is an SRT file? explains every part of a block, and How to edit an SRT file shows other ways to change one.

Frequently asked questions

What does the CSV file look like?

One row per subtitle, under four headings, #, Start, End and Text. The times are written the way SubRip writes them, 00:01:02,345, so nothing is rounded. A subtitle on two lines stays in one cell, with the line break inside it.

Why do some lines start with a space?

A line that starts with -, =, + or @ would be run as a formula by Excel and Google Sheets. A dialogue line such as "- Where to?" shows #NAME? instead of the words, and a hostile file could hide a formula that opens a link. A space in front makes the cell plain text. When you convert the sheet back with CSV to SRT, the space is removed.

Why are the times in quotes?

The times hold a comma before the milliseconds, and a comma also separates the columns. CSV puts such a cell in double quotes so it stays one cell. Excel, Google Sheets, LibreOffice and every CSV library read it that way.

Will Excel show the accents correctly?

Yes. The file is saved as UTF-8 with a byte order mark at the start, which is what Excel looks for before it reads a CSV file as UTF-8. Without it, Excel on Windows shows é as é and Vietnamese or Spanish text as garbage.

Are italics kept?

Yes. Each cell holds the subtitle exactly as SubRip writes it, tags included, so <i>, <b> and position codes such as {\an8} are still there when you turn the sheet back into SRT. If you only want the words, remove the tags first with Remove Formatting.

Should I use CSV or Excel?

CSV is plain text, so it opens anywhere, from Google Sheets to Python or a database import. If you will translate or review in Excel itself, Convert SRT to Excel gives you a real .xlsx with the times kept as text, wide text columns and a frozen heading row.

Are my files uploaded?

No. The file is read and converted by JavaScript in this browser tab. Nothing is sent to a server, and the page keeps working if you go offline after it has loaded.