SRT to Excel — every subtitle line in its own row
Convert an .srt file to an Excel table: number, start, end, duration in seconds and text — for translation, review or counting.
About this conversion
A spreadsheet is the usual way to hand subtitles to a translator or a reviewer, or to count anything about them. Each line becomes a row: its number, start and end, the duration in seconds as a real number you can sort and add up, the speaker when the file names one, and the text without tags in a wide column. The file is a proper .xlsx that opens in Excel, Numbers, LibreOffice and Google Sheets; CSV is in the Save as menu for anything else.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
Fix it before you save it
The file stays open after it is read, so the format is picked at the end: the same subtitles can leave here as VTT, ASS, SBV, SUB (MicroDVD), TTML / DFXP, SAMI (.smi), LRC, TXT, Word or PDF. Before that you can move every line earlier or later, stretch the timing to a different release of the film, remove [DOOR SLAMS] and speaker names, put a second language under the first, and see which lines break the rules studios follow — too long, too fast, overlapping.
Questions
- Can I translate in Excel and turn it back into SRT?
- Not yet — the way back from a table is not built. Edit lines here by clicking them, or merge a finished translation with the original to see both.