Convert CSV to SRT
Turn a CSV spreadsheet of times and text, from Excel, Google Sheets or a script, into a SubRip (.srt) file.
How to convert CSV to SRT
Open your .csv file
Drop the spreadsheet into the box above, or click to browse. No file at hand? The .csv sample under the box is a film with its English lines and a Vietnamese translation.
Pick the text column
If the sheet has more than one column of words, choose the one the subtitles take their text from. The preview updates as you choose.
Download the .srt file
The file keeps its name with the new extension:
movie.csvbecomesmovie.srt. It plays in VLC, on TVs and on every site that takes subtitles.
What a subtitle spreadsheet looks like
The simplest sheet has a row per subtitle:
#,Start,End,Text,Translation
1,"00:00:03,120","00:00:05,480",Is this seat taken?,¿Está ocupado este asiento?
2,"00:00:06,010","00:00:08,900",Only by my coat.,Solo mi abrigo.
Each row becomes one subtitle block in the .srt:
1
00:00:03,120 --> 00:00:05,480
¿Está ocupado este asiento?
The # column is ignored: the .srt is numbered from 1 in time order, even if the rows were sorted differently. Columns that hold only numbers, such as a score, are left out too. A column of words, such as notes, is offered as a text column but only used if you pick it.
A line break inside a cell becomes a line break in the subtitle. That is how a two-line subtitle is written in a sheet.
How the converter reads your sheet
The separator. Commas, semicolons and tabs all work. The converter tries each on the first rows and keeps the one that splits them into the same number of cells.
The headings. If the first row has no times in it, it is read as headings. Start, End, Text and Translation are recognised in four languages, along with common alternatives like In and Out, Subtitle, Dialogue or Duration. Start (ms) and End (ms) are read as milliseconds.
No headings. The first column where most cells are times is the start, the next one the end. Every column with words in it is a text column.
The times. SubRip times (00:01:02,345), WebVTT times (00:01:02.345), times without milliseconds (1:02:03) and Excel's short form (01:02.3) are all read. Under a Start heading, a plain number is seconds.
The order. Rows are sorted by start time, so a sheet filtered or sorted by something else still makes a correct file.
Common problems
"No column of times found". The sheet has words but no column where the times can be read. Check that each row has a start time, and that the column isn't mixed with notes.
Times shown as 01:02.3 in Excel. Excel turned the text into a clock time, and the CSV it saves holds only what the cell shows: the time still reads correctly, but only to the tenth of a second. To keep the milliseconds, save the sheet as an Excel workbook (.xlsx) instead and open it in Convert Excel to SRT, which reads the full time Excel stored.
Accents look broken. The CSV was saved in an old encoding. Save it again as "CSV UTF-8", or pick the right encoding next to the file name.
After converting
Check the result with the Subtitle Checker: it finds lines that overlap, are too long or go by too fast, which happens easily when a translation is longer than the original. If the whole file is early or late, Shift Subtitle Timing moves every line at once. Going the other way? Convert SRT to CSV makes the sheet from a subtitle file, and What is an SRT file? explains the format you get.
Frequently asked questions
What does my CSV file need?
A column of start times and at least one column of text. An End column is useful but optional, and so is a heading row. Times can be written 00:01:02,345, 00:01:02.345, 1:02:03 or 01:02.3, the way Excel shows a time it has reformatted.
Which headings does it understand?
Start, End, Text and Translation, and the usual alternatives such as Start Time, In, Out, Subtitle, Dialogue or Duration, in English, Spanish, Vietnamese and Indonesian. A sheet without headings works too. The first column of times is the start, the next one the end, and every column of words is text.
My sheet has the original and a translation. Which one is used?
The Translation column, when it has any text. A "Text column" choice appears above the Download button whenever the sheet has two or more columns of words, so you can pick the original, the translation or any other column. A row left empty in the chosen column keeps its original text, so an unfinished translation loses no line.
What if there is no End column?
Each subtitle stays on screen until the next one starts, for at most 10 seconds. The last one stays 4 seconds. "What changes" says how many end times were worked out. A Duration column, when the sheet has one, is used instead.
My file uses semicolons, not commas. Does it work?
Yes. Excel in many countries saves CSV with semicolons, because the comma is their decimal mark. The converter looks at the first rows and picks the separator that fits. It can be a comma, a semicolon or a tab.
Why was a row skipped?
Its start time couldn't be read, for example a cell that says "TBD" or a time with seconds above 59. A note above the preview gives its row number. Rows with no text at all are left out without a note.
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.
Related tools
Shift Subtitle Timing
Subtitles too early or too late? Move every line by any number of seconds.
Open toolConvert SRT to CSV
Turn SubRip subtitles into a CSV spreadsheet with number, start, end and text columns, for Excel, Google Sheets or a script.
Open toolConvert Excel to SRT
Turn an Excel sheet (.xlsx) of start times and subtitle text into a SubRip (.srt) file any player can show.
Open toolSubtitle Checker
Check an SRT, VTT or ASS file for overlaps, lines too fast to read, too short, too long or over 42 characters, and fix them.
Open tool