Tools/Transcripts & subtitles

YouTube Playlist Exporter to CSV

Reads a whole playlist and exports the running order with every video's length, ID and link as CSV. Caption text is not included, because that needs a file per video.

Input

Playlist rows

Paste a playlist link. The running order comes back as rows you can copy.

Pro · needs a video link
Reads public data only
Cached to protect quota

What this does

Reads a playlist through the YouTube API and returns the running order: position, title, length, video ID and link, ready to export as CSV.

It does not include caption text. Reading captions needs a file per video, which the caption tools handle one at a time.

Use cases

01Get a course playlist into a spreadsheet with every lesson length.
02Audit a playlist for videos that have gone private or been deleted.
03Plan a watch schedule from real durations rather than guesses.

Glossary

Captions vs subtitles WebVTT Closed captions

FAQ

Questions, answered.

How many videos does it read?

Up to 200 per playlist, and it tells you when a longer playlist was cut short. Reading more would spend a large share of the daily API quota on one request.

Does it include the transcripts?

No. The name used to promise that and the tool could not deliver it, so it now describes what it actually returns.

Will private videos show up?

They appear as unavailable entries, which is how you find the dead rows in an old playlist.

From the notebook

How to get a transcript from a YouTube playlistA student workflow for 40 hours of lectures in one week, built on playlist export, search and timestamps, including the parts that did not work.How to get a transcript from a YouTube videoThe two-minute version, the three link shapes that trip people up, and what to do when the transcript panel is missing.