YouTube playlist is a collection of videos. According to YouTube, anybody can make playlists and share them. Also, anybody can make YouTube playlist from any YouTube channel videos as well.
YouTube or YouTube channel owner does have the permission to alter the videos on Playlist(Modify/delete/Add).
Why do you want to export YouTube Playlist?
You do have favorite music or short-film playlist on other YouTube channel and you might see some frequent changes on the Playlist made by the channel owner.
Sometime you might notice that your favorite songs/albums were not in the YouTube Playlist or altered.
I don’t know whether you come across this problem or not but I did.
To avoid all these consequences, you must export YouTube playlist information such as Title, video URL, etc.,
If you have those exported YouTube playlist you can watch those missed videos directly by navigating to the video URL.
How to export YouTube Playlist to CSV from Google Sheets?
Let’s see how to export YouTube playlist to CSV from Google Sheets in details.
You may think of why Google sheets right?
If you have that metadata information on Google Sheets, you can access it anytime anywhere(mobile, desktop or tablet), since it gets stored on the cloud.
You can also use this tool to backup YouTube playlist from your own channel.
I wrote apps script on Google sheets to export YouTube Playlist metadata information.
Let’s see step by step on how to scrape YouTube Playlist information from Google Sheets.
Open the Google sheets by clicking the download link given at the bottom of this Blog Post.
You can also find additional menu “YouTube Playlist scraper” next to help. Just in case you don’t see the custom menu please refresh the page once.
It’ll look like below image
Now you need to find the Playlist ID to be exported. Let me tell you how to find playlist ID from the URL. Just open your YouTube Playlist in any of the browser.In the address bar, you can find Playlist URL.
Just take the Playlist ID that comes after the keyword “list=”
In the above cases, the Playlist ID is PLe_F6wC3FvdolT54Pmi2Ht9_08kP5fFFQ
PS: Don’t include ‘&’ anything that comes after ‘&’ in case 2
Put the playlist ID in the cell B2 as shown below
Click on the menu “YouTube PlayList Scraper” and select “Run Playlist Scraper” as shown in step 1.
When you are running the script for the very first time, it’ll show a prompt for authentication.
Click on continue and select the email address to proceed further.
You must authenticate the sheets so that it can connect to external services(Youtube API) to retrieve the YouTube Playlist information.
Sometime, you might get the “ThisApp isn’t verified” because of the existing bug on Google Apps as shown below.
In this case, you can just click on the “Advanced” link at the bottom left and click on the “Go to Playlist export” link to scrape the YouTube playlist info.
Note: You need to do this authentication for the very first time and from next time onward it doesn’t show any pop-up.
Script executes and completed in a few seconds. Then, you can find the YouTube playlist URL and other metadata information such as Title, channel name, channel ID and video Published date and time. That’s it.
Now it’s time to export YouTube Playlist to CSV/ Excel.
Click on the “File” -> Download as -> Excel(xlsx) or CSV. YouTube Playlist metadata information will be download and saved on your local computer.
This Google spreadsheet tool is available in two models.
Freemium and Premium version.
In the Freemium model, you can get the top 10 videos information from given YouTube Playlist.(FREE)
Rajan is a web geek-Blogger-Programmer- working in corporate firm as system analyst engineer. Whenever time permits he used to blog on recent trends in technology, monetizing tips, Programming concepts and technical guides to beginners in amarindaz.