TubeToTranscript Logo
TubeToTranscript
Spreadsheet (.csv) Exporter

YouTube Transcript to Excel & CSV

Turn a YouTube video’s captions into a spreadsheet: one row per line, with start and end times, ready for Microsoft Excel, Google Sheets, or data analysis.

How to Export a YouTube Transcript to Excel

Get a video's captions into a spreadsheet in three steps. Free web access, with fair-use limits.

Step 1

Paste the YouTube Link

Paste a youtube.com, youtu.be, or Shorts link into the box above and get the transcript.

Step 2

Download as CSV

Open the Download menu above the transcript and choose CSV. The file is named after the video title.

Step 3

Open in Excel or Sheets

Open the file in Excel, or import it into Google Sheets. Each caption line becomes its own row with its timestamp.

Example: a 20-minute talk in a spreadsheet

A 20-minute talk usually comes out at a few hundred rows, since each caption line is a few seconds long. In Excel, the Text column is column E, so a few simple steps turn the export into something you can work with:

  • Make it readable: select column E, turn on Wrap Text, and widen the column. Freeze the top row so the headers stay visible as you scroll.
  • Find a topic: turn on Filter (Data → Filter), then use Text Filters → Contains on column E to show only the lines that mention it, each with its timestamp.
  • Get the full text in one cell: =TEXTJOIN(" ",TRUE,E2:E500) joins every line into one paragraph. Google Sheets supports the same formula.
  • Link to a moment: with the video’s youtube.com/watch?v= address in cell H1, =H$1&"&t="&INT(A2) builds a link that opens the video at that row’s start time.

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.

CSV Export FAQ

Find answers to common questions about generating and exporting YouTube transcripts.

Paste the video URL, click "Get Transcript", and download the CSV file. Double-click the .csv file to open directly in Microsoft Excel, Apple Numbers, or import it into Google Sheets.