SRT to Excel Converter

How to convert SRT to Excel

1. Drop the .srt or .vtt file into the box above. The file card shows the number of subtitles and when the last one ends.
2. Under "Save as", choose "Excel workbook (.xlsx)" or "CSV for Excel or Sheets (.csv)".
3. Check the first subtitles in the preview panel.
4. Press "Convert and download" and open the file in Excel, Google Sheets, LibreOffice Calc or Numbers.

What each row contains

Number

3, counted in time order (rows are renumbered 1, 2, 3 even if the SRT's numbers had gaps)

Start

00:00:07,200, written exactly as in SRT

End

00:00:10,050

Duration (s)

2.85, a real number you can calculate with

Text

both lines in one cell, with the line break kept

The workbook has one sheet called Subtitles, with a narrow Number column and a wide Text column so long lines are readable without resizing.

XLSX or CSV

In the .xlsx file, Start and End are stored as text. That matters: if Excel sees something that looks like a time, it can convert it to its own time format and change how it is displayed, which is the last thing you want in a file that has to go back to SRT. Duration is stored as a number, so formulas work on it straight away. Choose XLSX if you will edit in Excel.

The CSV is comma-separated, saved as UTF-8 with a byte order mark so Excel recognises accented and non-Latin letters instead of showing garbled characters. Any cell that contains a comma, a double quote, a semicolon or a line break is wrapped in double quotes, and quotes inside the text are doubled, following the usual CSV convention described in RFC 4180. Because every SRT time contains a comma, the Start and End cells are always quoted. Choose CSV for Google Sheets, scripts, databases or translation tools that import CSV.

Two CSV caveats. When you open a CSV by double-clicking it, Excel decides on its own how to read each cell, so check the Start and End columns before saving. And if your Excel uses the semicolon as its list separator, which is common in parts of Europe, a comma-separated file may land in a single column; open the XLSX instead, or use Excel's import-from-text option and choose comma.

Quality-check columns worth adding

The sheet is a good place to catch problems before a subtitle file goes out. With the default layout (Duration in D, Text in E), add these in the first free columns and fill them down:

• Characters per second: =LEN(E2)/D2. The subtitle editor warns above 21, so use conditional formatting to highlight anything over that. LEN counts the line break as one character, so two-line subtitles read about one character high.
• First line length: =IFERROR(FIND(CHAR(10),E2)-1,LEN(E2))
• Second line length: =IFERROR(LEN(E2)-FIND(CHAR(10),E2),0). Many style guides cap lines at 42 characters, which is also where the editor warns.
• Very short subtitles: =D2<0.8 flags anything on screen for under 0.8 seconds.

Start and End are text, so you can't subtract them directly; use the Duration column for arithmetic, and filter or sort by Start (text sorts correctly because every time has the same fixed width).

Translating in the spreadsheet

The exported sheet has no translation column; add one yourself. Put the heading in F1, for example "Translation", and let the translator fill each row next to the original. Timings stay in the same row, so the translated subtitles keep the original timing when you convert back. The converter doesn't translate anything itself. If you need machine subtitles in another language rather than a human translation, the video translator creates them from the video's audio.

Turning the sheet back into SRT

The subtitle converters on this site read CSV. Save the sheet as CSV (Excel offers a "CSV UTF-8" type; Google Sheets has File, Download, Comma-separated values). The reader then works like this:

• The separator is detected from the first row: comma, semicolon or tab all work, so European Excel exports are fine.
• The start column is the first heading that begins with Start, In, Begin or From; the end column begins with End, Out, Stop or To.
• The text column is the leftmost heading that begins with Text, Subtitle, Caption, Line or Translation. If you added a Translation column and want the SRT in that language, rename the original Text heading (to "Original", say) or delete that column; otherwise Text, which comes first, is used.
• Time cells can be SRT style (00:00:07,200), VTT style (00:00:07.200), minutes and seconds (0:07.2) or plain seconds (7.2).
• Number and Duration are ignored. To change how long a subtitle stays up, edit End, not Duration.
• Rows missing a start, an end or text are skipped and counted in a note. A file with no header row still works if its first two time-like columns are start and end.

This page writes only XLSX and CSV, so do the return trip on a converter whose output is SRT, such as SBV to SRT or TTML to SRT: drag the .csv onto the drop box (their file pickers suggest other file types, but the file is recognised by its .csv extension). XLSX files are not read, so always save as CSV first.

What is kept and what is lost

Kept

Text, start and end times to the millisecond, line breaks inside a subtitle

Removed when the file is read

Italic, bold and colour tags, position tags, VTT cue settings, cue identifiers, NOTE and STYLE blocks

Changed

Cue numbers, which are renumbered in time order

Limits

• One file at a time; files over 20 MB are refused. Text-based subtitles only.
• Files that are not UTF-8 or UTF-16 are read as Windows-1252 and a note says so. Check accented letters in the preview before converting.
• Need a document for a reviewer who doesn't use spreadsheets? SRT to Word makes the same table as a .docx.