SRT to CSV Converter
Work out CSV rows from SRT cues from the text in the box. Index,start,end,text per cue; a text cell is quoted when it contains a comma or a quote, and the page prints the substitution so the result can be checked by hand.
SRT to CSV Converter
Work out CSV rows from SRT cues from the text in the box. Index,start,end,text per cue; a text cell is quoted when it contains a comma or a quote, and the page prints the substitution so the result can be checked by hand.
How this page computes
Index,start,end,text per cue; a text cell is quoted when it contains a comma or a quote
A cue text that contains a comma, a quote or a line break is quoted and its quotes doubled, which is the RFC 4180 form every spreadsheet reads.
A cue with two lines becomes one CSV row with the break replaced by a space, because a CSV row cannot hold one unquoted.
The calculation runs entirely in this browser tab; nothing is uploaded.
SRT to CSV Converter computes CSV rows from SRT cues. Index,start,end,text per cue; a text cell is quoted when it contains a comma or a quote. The page prints the rule, the numbers substituted into it and the result, so the arithmetic can be checked by hand.
A cue text that contains a comma, a quote or a line break is quoted and its quotes doubled, which is the RFC 4180 form every spreadsheet reads. Pressed with the sample text, it answers: 1,00:00:01,000,00:00:03,500,"Hello, world"
How to use SRT to CSV Converter
Paste the input into the box, then press Run: the page evaluates CSV rows from SRT cues and prints every line of the working. Typed input is read exactly as written, and a blank field is refused with its name.
Read the first line as the answer and the lines below it as the substitution. If a value is out of range the page refuses it by field and reason instead of printing a number.
With the sample text, the answer is 1,00:00:01,000,00:00:03,500,"Hello, world".
Quoting is conditional
A cue text that contains a comma, a quote or a line break is quoted and its quotes doubled, which is the RFC 4180 form every spreadsheet reads.
A cue with two lines becomes one CSV row with the break replaced by a space, because a CSV row cannot hold one unquoted.
What to Expect
Best for
- Working out CSV rows from SRT cues without a spreadsheet
- Checking a figure someone else quoted
- Seeing the formula behind an answer
Not ideal for
- A block with no time line is refused with its block number, because a dropped cue is a silent edit.
- A quantity the page cannot compute, which it refuses instead of estimating
- Rounding an answer that has an exact form
What this tool keeps
- Index,start,end,text per cue; a text cell is quoted when it contains a comma or a quote
- Every input exactly as typed
What may need cleanup
- Nothing: the printed answer is the final output
- A unit conversion, if the inputs were entered in different units
Common errors
- A block with no time line is refused with its block number, because a dropped cue is a silent edit.
- An empty field is refused with the field's name
Example use cases
- Work out CSV rows from SRT cues for one set of inputs
- Check the result against the formula by hand
- See which input the answer is most sensitive to
Sample input
SRT to CSV Converter: the sample text
Sample output
1,00:00:01,000,00:00:03,500,"Hello, world" — 2,00:00:04,000,00:00:05,000,Second cue
Who this is for
- Students checking a formula
- Anyone who needs the number and the working
Frequently asked questions
What formula does this page use?
Index,start,end,text per cue; a text cell is quoted when it contains a comma or a quote. The page prints the substitution as well, so the answer can be checked against the rule.
What does SRT to CSV Converter refuse?
A block with no time line is refused with its block number, because a dropped cue is a silent edit.
What does the default example give?
The sample text gives 1,00:00:01,000,00:00:03,500,"Hello, world". Every line below that restates the same arithmetic.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.