Export a YouTube Playlist
Download any YouTube or YouTube Music playlist as CSV, JSON or a plain list of links, with titles, durations, dates and stats for every video.
What you can export
CSV for spreadsheets, JSON for scripts and apps, and a .txt list of links for anywhere that takes URLs. All three are free and unlimited.
What a CSV looks like
This is the start of the CSV for Corey Schafer’s Python Tutorials, which has 158 videos. The downloaded file has one row for every video and a few more columns (channel, likes and an unavailable flag), shortened here to fit the page:
position,title,duration_seconds,duration_formatted,published_at,view_count
1,Python Tutorial for Beginners 1: Install and Setup for Mac and Windows,929,15m 29s,2017-05-17T15:30:00Z,4436986
2,Python Tutorial for Beginners 2: Strings - Working with Textual Data,1272,21m 12s,2017-05-17T16:00:04Z,2181032
3,Python Tutorial for Beginners 3: Integers and Floats - Working with Numeric Data,715,11m 55s,2017-05-17T16:30:02Z,1020628
4,"Python Tutorial for Beginners 4: Lists, Tuples, and Sets",1745,29m 5s,2017-05-17T17:00:03Z,1844981
5,Python Tutorial for Beginners 5: Dictionaries - Working with Key-Value Pairs,599,9m 59s,2017-05-17T17:30:01Z,1812948Figures read from YouTube on November 19, 2026. Full breakdown for this course
The columns, explained
- position: the video's place in the playlist, starting at 1.
- duration_seconds and duration_formatted: the length as a plain number you can add up, and as hours, minutes and seconds you can read.
- published_at: the upload date and time in UTC.
- channel_title: the channel that uploaded the video, which differs from the playlist owner in mixed playlists.
- view_count and like_count: counts at the moment you loaded the playlist. A hidden like count is exported as 0.
- unavailable: true for deleted and private videos, which stay in the CSV so positions still match the playlist but are left out of the links list.
Working with the file in a spreadsheet
Open the CSV in Google Sheets, Excel or Numbers. Because duration_seconds is a plain number, the total for a playlist is one formula: sum the column, then divide by 3600 for hours. To see the time at 1.5x, divide the sum by 1.5 first.
Sort by view_count to find the most watched videos, or filter on published_at to see only what was uploaded this year. A column for "watched" turns the file into a course tracker.
Common uses
- Back up a playlist before videos go private or get deleted.
- Build a course tracker in Google Sheets or Notion.
- Compare competitors' playlists in a spreadsheet.
- Hand a clean list of links to a script, a teammate or a student group.
Frequently Asked Questions
How do I export a YouTube playlist to a spreadsheet?
Paste the playlist link, load it, and download the CSV. It opens in Excel, Google Sheets and Numbers with one row per video: title, duration, upload date, channel, views, likes and position.
How do I get all the video links from a playlist?
Choose Video links (.txt). You get one watch URL per line, ready to paste anywhere. Deleted and private videos are left out.
Can I export a YouTube Music playlist?
Yes. Paste the music.youtube.com playlist link; every track is exported the same way as a regular YouTube playlist.
Is there a limit on playlist size?
No fixed limit. Playlists with hundreds of videos export in a few seconds.