One row per caption segment
The CSV has a header row followed by one row per caption segment, with five columns: Start (Seconds), End (Seconds), Timestamp, Duration (s), and Text. Text that contains commas, quotes, or line breaks is quoted, so it opens cleanly as one cell.
Sample CSV output (original example text, not from a real video)
Start (Seconds),End (Seconds),Timestamp,Duration (s),Text 0.00,4.00,00:00,4.00,"First, write down the question you want the video to answer." 4.00,8.50,00:04,4.50,"Next, search the transcript for a distinctive phrase." 8.50,13.50,00:08,5.00,"Finally, check the matching moment in the source video."
Useful things to do with it in a spreadsheet
- Tag moments: add a column for topic, speaker, or “use in clip”, then filter to build an edit list for a video editor.
- Find long pauses: a formula comparing each row’s Start to the previous row’s End shows where the speaker paused or the captions skipped.
- Count keywords: =COUNTIF(E:E,"*keyword*") counts the segments mentioning a term.
- Build a quote sheet: filter the Text column, copy the rows you want, and keep the Timestamp column as your source reference.
Opening the file correctly
The file is UTF-8. Google Sheets (File → Import) and Numbers read it correctly as-is. In older versions of Excel, use Data → From Text/CSV and choose UTF-8 if accented or non-Latin characters look garbled when you double-click the file.