How do I export a YouTube playlist (video names) to Excel or a document?
2 Answers
If the playlist is public you can get atom feed of it with an http request like.
Where the ID is replaced with an actual ID like this.
With that document you will have all the information about the feed and you can further process it using other methods.
-
Thanks for your answer. But on opening first link, I got 404 error like this. 404. That’s an error. The requested URL /feeds/videos.xml?playlist_id=ID was not found on this server. That’s all we know.– MainCommented May 7, 2015 at 19:41
-
2Right, and if you read the sentence right after that you will see me telling you to replace ID with the playlist ID. I even gave you an example. Commented May 7, 2015 at 20:30
-
Thanks for your comment. It works, but it only feeds 15 videos. I have over 300 videos in a playlist. Have you checked on this?– MainCommented May 8, 2015 at 7:22
-
Ack, sorry didn't notice that. I was using a smaller playlist for testing. You certainly can get a full dump of videos in a playlist through the API, but I believe you must authenticate to use it, and you would have to write code. With Google killing off the v2 version of the API a couple weeks back things like this have become far more difficult. Commented May 8, 2015 at 20:20
I wrote a Python-based web application Export YouTube Playlist that extracts YouTube playlist data using their API and exports it in your choice of CSV or Excel (.xlsx) format.