Export a YouTube playlist to CSV and Excel
Paste the link of a public YouTube playlist and we build a spreadsheet with one row per video: link, title, description, thumbnail, tags, upload date and duration. The data comes from the official YouTube API and the CSV opens straight in Excel, Google Sheets or LibreOffice. Walking the whole playlist and downloading the CSV is on the Basic plan; without it you can try single videos and see what each row holds.
No account, no card · YouTube · Vimeo · Dailymotion · WordPress · OpenGraph · nearly 70 players
Columns in the CSV
- url: each video's link (youtube.com/watch?v=…).
- titulo and descripcion: title and description as the channel wrote them (the description up to 2,000 characters).
- portada: the largest thumbnail the video has.
- generos: the video's tags, separated by semicolons.
- fecha: the video's upload date and time, in ISO format (2024-11-07T16:07:20Z).
- duracion: duration in seconds, ready to add up or filter.
- servidor1: the player to embed it (youtube.com/embed/…).
What it does not include
No views, likes or comments: this tool does not ask for them. Not the date each video was added to the playlist either, nor the channel's private analytics, which only the owner can see.
What it is for
- Keep the inventory of a channel or a course in a spreadsheet, to sort, filter or share it.
- Build the list of videos to add to your site, with title, thumbnail and player on each row.
- Compare durations, dates and tags across the videos of one playlist.
- Save a copy of the titles and links in case the playlist changes or a video is removed.
How to export it
- Open the playlist on YouTube and copy its address: the one that starts with youtube.com/playlist?list=.
- Paste it in the box above and press Extract: the list comes first, then each video.
- When it finishes, tap CSV and open the file in Excel, Google Sheets or LibreOffice.
Long playlists, channels and edge cases
YouTube returns playlists 50 videos at a time. If yours has more, when the first batch ends we give you the link to the next one: paste it and keep going. Each batch downloads its own CSV, which you then combine in the spreadsheet.
If you copied the link from a video playing inside the playlist (watch?v=…&list=…), you only get that video. For the whole list, use the playlist's address.
A channel link (youtube.com/@channel) works too: you get the list of videos it uploaded, 50 at a time, newest first.
Private or deleted videos still in the list show up as a row with the link and no title. YouTube's automatic mixes (Mix) cannot be read: the API does not return them.
The whole playlist, with the Basic plan
The Basic plan walks the full playlist, batch by batch, and unlocks CSV: 1,000 extractions per month for US$ 7. With Premium, each video can also land as a draft in your WordPress or come out through the API.
See plansFrequently asked questions
- Is it free?
- The whole playlist and the CSV are on the Basic plan. Without a paid plan you can paste single videos, one per line (2 per day without an account and 5 with a free account), and see on screen the same data each row gets; with an account you can also download it as JSON.
- How many videos can I export?
- As many as the playlist has, 50 per batch, which is what YouTube returns. Each video uses one extraction and reading each batch of the list uses one more: a 120-video playlist uses 123 of the 1,000 the Basic plan includes per month.
- Does it open correctly in Excel?
- Yes: the file is UTF-8 with the byte order mark Excel uses to detect it, so accented characters show up right. If everything lands in one column (it happens when Windows uses a comma for decimals and separates lists with semicolons), open it from Data › From Text/CSV and pick comma as the delimiter. Google Sheets splits it on its own.
- Does it work with private playlists?
- No: a private playlist is only visible to its owner and YouTube does not hand it to anyone else. Unlisted ones do work if you have the link, and so do public playlists from any channel.
More free tools
- YouTube metadataTitle, description, tags, upload date and duration of a YouTube video.
- YouTube thumbnailA video's thumbnail at the highest resolution, ready to open and save.
- Vimeo metadataTitle, description, upload date, thumbnail and embed code of a Vimeo video.
- Embed code generatorReady-to-paste iframe code for YouTube, Vimeo, Dailymotion or a page with a player.