Convert YouTube playlists to spreadsheets

Converting a YouTube playlist to a spreadsheet involves extracting video metadata (like title, URL, duration, upload date, channel name, etc.) from the playlist and organizing it into a structured table. Here’s a step-by-step guide to do it manually or with tools:

Method 1: Use Online Tools (No Code)

Several online services can help convert YouTube playlists into spreadsheets:

1. Export YouTube Playlist

• Website: https://exportify.net or search for “YouTube playlist to CSV” tools.

• Steps:

  • Copy your playlist URL from YouTube.

  • Paste the URL into the tool.

  • Choose export format (CSV or XLSX).

  • Download the spreadsheet file.

2. Use Google Sheets with a Script

You can use Google Apps Script to extract data.

• Open a new Google Sheet.

• Go to Extensions > Apps Script, then paste the following script:

javascript
CopyEdit
function getYouTubePlaylistData() {
  var playlistId = 'YOUR_PLAYLIST_ID';
  var apiKey = 'YOUR_YOUTUBE_API_KEY';
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  sheet.appendRow(['Title', 'Video ID', 'URL', 'Channel Title', 'Published At']);

  var pageToken = '';
  do {
    var response = UrlFetchApp.fetch(`https://www.googleapis.com/youtube/v3/playlistItems?part=snippet&maxResults=50&playlistId=${playlistId}&key=${apiKey}&pageToken=${pageToken}`);
    var data = JSON.parse(response.getContentText());

    data.items.forEach(function(item) {
      var snippet = item.snippet;
      var videoId = snippet.resourceId.videoId;
      var title = snippet.title;
      var url = 'https://www.youtube.com/watch?v=' + videoId;
      var channelTitle = snippet.videoOwnerChannelTitle;
      var publishedAt = snippet.publishedAt;
      sheet.appendRow([title, videoId, url, channelTitle, publishedAt]);
    });

    pageToken = data.nextPageToken;
  } while (pageToken);
}

• Replace YOUR_PLAYLIST_ID and YOUR_YOUTUBE_API_KEY.

• Run the script, authorize permissions, and your spreadsheet will populate with video data.

Method 2: Use Python Script (Advanced)

If you’re comfortable with Python:

python
CopyEdit
from googleapiclient.discovery import build
import pandas as pd

api_key = 'YOUR_YOUTUBE_API_KEY'
playlist_id = 'YOUR_PLAYLIST_ID'

youtube = build('youtube', 'v3', developerKey=api_key)
videos = []
next_page_token = None

while True:
    res = youtube.playlistItems().list(
        part='snippet',
        playlistId=playlist_id,
        maxResults=50,
        pageToken=next_page_token
    ).execute()

    for item in res['items']:
        video_id = item['snippet']['resourceId']['videoId']
        title = item['snippet']['title']
        url = f'https://www.youtube.com/watch?v={video_id}'
        published_at = item['snippet']['publishedAt']
        channel_title = item['snippet']['videoOwnerChannelTitle']
        videos.append({
            'Title': title,
            'Video ID': video_id,
            'URL': url,
            'Channel': channel_title,
            'Published At': published_at
        })

    next_page_token = res.get('nextPageToken')
    if not next_page_token:
        break

df = pd.DataFrame(videos)
df.to_csv('youtube_playlist.csv', index=False)

Data You Can Include in Spreadsheet

• Video Title

• URL

• Video ID

• Channel Name

• Upload Date

• Duration (if using YouTube Data API v3 with video details)

• View Count, Like Count (optional with videos().list method)

Tips

• Always check for playlist privacy settings.

• For large playlists, expect some API rate limits unless using OAuth2 authorization.

• Use browser extensions like “Export YouTube Playlist to CSV” from Chrome Web Store for a quick, no-code solution.

Let me know if you need help with a specific playlist or want a ready-to-use Google Sheet template or script.