Transcribela

SRT to CSV Converter

Convert subtitles into a spreadsheet with start, end and text columns for Excel or Google Sheets.

About this tool

A spreadsheet view makes it easy to review translations, count lines or hand subtitles to a reviewer. Times use the HH:MM:SS.mmm format.

How subtitle files are built

SRT and VTT are plain text files, so you can open them in any text editor. Each subtitle is a block: a time range and one or two lines of text, followed by a blank line.

SRTVTT (WebVTT)
First line of the fileThe number 1The word WEBVTT
Cue numbersRequired, counting from 1Optional
Time format00:01:02,500 (comma before milliseconds)00:01:02.500 (full stop before milliseconds)
Styling and positionBasic tags in some playersCue settings and CSS classes
Used byVideo editors, VLC, YouTubeHTML5 video players, web course platforms, YouTube

Most conversion problems come from three things. Encoding: save subtitle files as UTF-8, or accented letters and non-Latin scripts turn into symbols. Separators: a full stop in an SRT timestamp, or a comma in a VTT one, makes many players skip the cue. Missing blank lines: every cue must be followed by an empty line, including the last one in some players. The tools on this site fix all three automatically.

Timing matters as much as the text. Professional guidelines keep each subtitle on screen between about five sixths of a second and seven seconds, at a reading speed of 17 to 20 characters per second for adults, with a short gap between cues so the eye notices the change. The subtitle checker flags cues that break these rules.

Everything you paste or open in these tools stays in your browser. Nothing is uploaded, so they are safe to use with unreleased or confidential material.

Need a transcript or subtitles from a recording? Transcribe audio or video free, then export SRT, VTT, Word or text.

Questions and answers

Does Excel open it correctly?

Yes. Fields are quoted, so commas inside subtitles are safe.

Is my file uploaded?

No. The tool runs entirely in your browser.

Summarize this page with