SRT to Excel Converter

The spreadsheet has five columns and one row per subtitle cue. The header row is written in lower case, which matters if you plan to convert the file back to SRT later:

• index - the cue counter. It starts at 0.
• type - the kind of entry. Regular subtitles are marked cue.
• start - when the subtitle appears, as HH:MM:SS,mmm.
• end - when it disappears, in the same format.
• text - the subtitle text. A cue that takes two lines on screen stays in one cell, with the line break kept.

1. Upload your SRT file with the file picker above.
2. Choose the Excel file format - XLSX for Excel 2007 and later, or XLS for the legacy Excel 97-2003 format.
3. Optionally switch on Join multiline text with spaces so each cue occupies a single line. This is the setting to use when you plan to convert the file back to SRT afterwards, or when you are counting characters per cue.
4. Click "Run Conversion".
5. Download the spreadsheet and open it in your spreadsheet software.

Nothing gets installed and no account is needed to try it. The converter also accepts WebVTT files, so a .vtt file produces the same columns.

• Translation workflows: add a column per target language next to the original text and hand the sheet to a translator who has never opened subtitle software. Convert the finished sheet back to SRT per language.
• Bulk text edits: fix a character name, a product name or punctuation across hundreds of cues in one find-and-replace instead of scrolling through a text file.
• Timing and reading-speed checks:subtract start from end to get each cue's duration, divide the character count by it, and flag anything that flashes past too quickly or lingers too long.
• Character-limit QC: most broadcasters cap subtitle lines at around 42 characters. A LEN formula plus conditional formatting turns that from a manual read-through into a coloured column.
• Review and sign-off: add reviewer, status and comment columns beside the dialogue, circulate the file, then convert the approved version back.
• Transcripts and show notes: the text column on its own is a ready-made transcript for accessibility documentation, blog posts or search.

The layout produced here is exactly what the Excel to SRT converter reads, so the round trip needs no renaming or reshaping:

1. Convert your SRT file to Excel on this page.
2. Edit the text column. Leave the index, start, end and text headers spelled as they are.
3. Convert the spreadsheet back to SRT.

Subtitles in the rebuilt file are renumbered from 1 in row order, so you do not need to tidy up the index column by hand. If your workbook has several sheets - one per language, say - each sheet comes back as its own SRT file inside a ZIP archive.

SRT (SubRip Text) is the most widely supported subtitle format. Each entry has three parts: a sequence number, a start and end timecode, and one or more lines of text.

1
00:00:01,000 --> 00:00:04,500
Welcome to our video tutorial.

2
00:00:05,000 --> 00:00:08,250
Today we will look at
file conversions.

3
00:00:09,000 --> 00:00:12,000
Let's get started!

SRT is a de facto standard created by the SubRip software. There is no formal specification, but the format is understood by practically every video player and editing tool.