 Hi guys, welcome back to my YouTube channel. This is Daniel Rosal here. So I'm a really, really big fan of YouTube. I spend a lot of time every day watching YouTube videos, and I find YouTube a really, really good way to learn about topics as well as reading. So right now I'm learning about sustainability for professional reasons and something I personally do is create a lot of playlists. For the most part, the playlist are public because I don't see the point in them being private. Anyone's free to look at my bundles of videos. Sometimes they're private, but either way, there is a lot of them. So sometimes I think I'm creating all this data in YouTube. It's kind of bewildering because I need to be logged into YouTube in order to log in, in order to access my private playlists. And it's just not, I mean, there's a few ways you can access your own playlist. One of them is through YouTube Studio. You have a tab here for playlists and you can actually search through your own playlist. So if you have a bunch of playlists created, this is one way of narrowing it down a little bit. Another way is by going on to your YouTube channel and clicking on the playlist tab. And it's a bit less powerful because you can filter on a date playlist by date added or last video added. And if you go into the all playlist tab, then you can see your playlist and the playlist that you've saved from other people. But in any event, if you wanted to take that data, that playlist data out of YouTube in order to, let's say, create a blog with your YouTube playlist or just pipe that into a spreadsheet so that you could go through your playlist without having to necessarily navigate to YouTube. So there's a few ways, as always, with data stuff. There's more than more than one way of going about doing that. But I'm going to show in this video one of the ways. So that's as follows. That is creating an export just for the YouTube playlist data. So your starting point is the Google Takeout Engine. And you want to create a new export. And by default, it's selecting the majority of products. So you want to just firstly deselect all. Then you want to scroll down to YouTube. And if you click on this date, this three things here, you'll see that even within each Google product, you have an option of what to export. Now, if you do want to use Google Takeouts for an actual account export, you probably want to get everything and you want to get everything in YouTube. But it's if you just export the playlist, you're going to get it's going to be a lot quicker because the playlist data is pretty light and it's going to be a lot lighter as well. So just deselect everything that YouTube is preparing to bundle up in the Takeout. Just click on Playlist, click OK, and then go through the rest of the export process. You know, you want to take the link via via via email. I always go for a TGZ because I use Linux and it's easy to open that format on this. And it means that I can just get minimal archives. Given that play like data is pretty light, you're probably only going to get one archive. Even if you just use the default zip format. But I'm going to set it to TGZ and I'm going to go ahead now and create this export. OK, so after the download is finished, you're going to get an email or you're going to just get a link in the Takeout Manager. I've gone ahead and extract is that archive. And what the way it delivers your playlist is that you're going to have each playlist you've created as a CSV file. So I'm going to go ahead now and just open one. So every every single playlist you create on YouTube, irrespective of its privacy settings, you're going to get as a CSV. And I'll show you what one play one playlist looks like on the inside. So here's what the data actually looks like on the inside. This is one of those CSV files open for a playlist. Now, one thing to point out is that the URLs are not intact. It's in an internal YouTube format. I'll just explain how to actually make those useful. So at the top here, you have the playlist ID and you can see that it's an alphanumeric string, then you have the channel ID. And again, it's an alphanumeric string. You have a timestamp for when the playlist was created, when it was last updated. The name on YouTube, in this case, it's video blogs, description. This is from my business YouTube channel. And then you have the visibility over here, which is set to public. Then all you have for the actual videos that are contained in the playlist is the video ID. And each video ID is, again, an alphanumeric string. And then you have the time added in universal time coordinated when each video is added to the playlist. So in terms of data liberation, this method of getting data from takeouts, it's not great because, you know, it doesn't contain the video titles in human readable format or those videos, whether they're public or private. You know, you can actually read it. All you're getting is those strings. So if you did want to actually locate any of these videos, what you would need to do is if you take a random video URL on YouTube, and I'm just going to paste one here into the spreadsheet, you can see it's youtube.com forward slash watch, question mark v equals and then a string. So what you could do is just use a, you know, use a formula on your spreadsheet and append that part of the URL into the video ID here. And that would convert between video IDs and actual URLs that you could open on YouTube. So I'm going to do the same thing for a playlist. So I just copy a random playlist into this cell here. Then you can see the string for a playlist is going to be youtube.com forward slash playlist, question mark list equals. And then after that equal sign, you're going to get an alphanumeric ID. That's going to be the ID there. So again, if you do the same spreadsheet substitution, you would just need to basically swap out and add this into this field. And you'd convert between the raw YouTube playlist ID and a URL that you could actually open in a browser. So this is one means of extracting your playlist data from YouTube using Google Takeouts.