Convert Excel to SRT
Turn an Excel sheet (.xlsx) of start times and subtitle text into a SubRip (.srt) file any player can show.
How to convert Excel to SRT
Open your .xlsx file
Drop the workbook into the box above, or click to browse. A .csv works too. No file at hand? The .xlsx 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.xlsxbecomesmovie.srt. It plays in VLC, on TVs and on every site that takes subtitles.
How to lay out the sheet
Put each subtitle on its own row, with headings in the first row:
| # | 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. |
Start is required. End is optional. Text and Translation can be any number of columns of words: the converter offers each one. Other columns, such as notes or a reviewer's name, can stay: they are offered too, but only used if you pick them. A column with only numbers that aren't times is left out.
The headings can be in English, Spanish, Vietnamese or Indonesian, and the usual alternatives work, like Start Time, In and Out, Subtitle or Dialogue. A sheet without headings works too: the first column of times is the start, the next one the end.
To write a two-line subtitle, press Alt+Enter (Option+Enter on a Mac) inside the cell. The line break becomes a line break in the subtitle.
How times are read
Excel stores a time you type, such as 0:01:02.345, as a fraction of a day and shows it with a time format. The converter reads that number and turns it back into milliseconds, so 01:02.3 on screen still gives the exact time underneath.
Times saved as text, like the ones Convert SRT to Excel writes, are read as they are: 00:01:02,345, 00:01:02.345 or 1:02:03. Under a Start heading, a plain number is seconds, and under Start (ms) it is milliseconds.
Rows are sorted by start time, so it doesn't matter if the sheet was sorted by speaker or filtered while you worked. A row whose start can't be read is skipped, and a note above the preview names it.
A translation workflow
- Turn the subtitles into a workbook with Convert SRT to Excel.
- Add a Translation column and translate line by line, leaving the times alone.
- Open the workbook here. The Translation column is picked for you, and any line not yet translated keeps the original, so you can check a half-finished file against the video.
- Check reading speed and line length with the Subtitle Checker. Translations are often longer than the original.
Tips
The subtitles are all early or late? Fix the whole file at once with Shift Subtitle Timing after converting.
Accents look broken? That only happens with CSV files saved in an old encoding. An .xlsx is always read as Unicode.
Prefer plain text? Convert CSV to SRT reads the same layouts from a .csv file. What is an SRT file? explains the subtitle format you get, and How to add subtitles to a video shows what to do with it next.
Frequently asked questions
What does my Excel sheet need?
A column of start times and at least one column of text, on the first sheet of the workbook. An End column is optional, and so is a heading row. Times can be text such as 00:01:02,345 or real Excel times shown as 1:02:03 or 01:02.3. Both are read to the millisecond.
My sheet has the original and a translation. Which one is used?
The Translation column, when it has any text. When the sheet has two or more columns of words, a "Text column" choice appears above the Download button, so you can pick the original, the translation or any other column. A row left empty in the chosen column keeps its original text.
Which sheet is read?
The first sheet of the workbook, the one furthest to the left. If the subtitles are on another sheet, drag that tab to the front in Excel and save, or copy the rows to the first sheet.
Can I open an old .xls or a LibreOffice .ods file?
Not directly. Open it in Excel, Google Sheets or LibreOffice and choose Save As → Excel Workbook (.xlsx) or CSV, then open the new file here. From Google Sheets, use File → Download → Microsoft Excel (.xlsx).
What if there is no End column?
Each subtitle stays on screen until the next one starts, for at most 10 seconds, and the last one stays 4 seconds. A Duration column, when there is one, is used instead. "What changes" says how many end times were worked out.
Are formulas read?
The value Excel last calculated is read, the same thing you see in the cell. A cell that shows #N/A or another error is read as that text, so check the preview if your sheet builds the times with formulas.
Are my files uploaded?
No. The workbook is unpacked and read 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 Excel
Turn SubRip subtitles into an Excel workbook (.xlsx), one row per line, ready to translate, review or count.
Open toolConvert CSV to SRT
Turn a CSV spreadsheet of times and text, from Excel, Google Sheets or a script, into a SubRip (.srt) file.
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