MYFRESHTOOLS
50% OFF
YouTube Music › Spreadsheets

Export a YouTube Music Playlist to Excel

YouTube Music won't hand you a spreadsheet. Here's the quickest way to get one, what's inside it, and what to do with it once it's open.

Updated 30 September 2026 · 7 min read
Quick answer
YouTube Music has no export button, so the route to Excel is a CSV file. Paste the playlist link into YouTube Music Playlist Export, download the CSV, and double-click it — Excel opens it as a spreadsheet with one row per song, ready to save as .xlsx.

A playlist you've built over years is a small database: hundreds of songs, artists you keep returning to, a rough sense of how long a session runs. In the app it's a scrolling list you can't sort, filter or count. In Excel it's a table you can do real work with — find duplicate artists, total the runtime, share a clean list with a friend, or keep a copy outside YouTube.

This guide covers how to get there, the columns you'll receive, and the small Excel-specific snags that catch people out.

The gap

Why YouTube Music has no Excel export

Open a playlist in YouTube Music and you'll find share, save, download-for-offline and shuffle. There is no export, no "download as spreadsheet", and no menu item that produces a file of the track list. The same is true in the YouTube app for regular playlists.

The information itself is available — every song in a playlist is a YouTube video with a title, uploader, duration and view count. It just isn't packaged for you. So "export to Excel" really means two steps: read the playlist's data, then write it to a file Excel understands. CSV is the format that does that most reliably.

Doing it by hand

The manual method (and where it breaks)

Open the playlist on the web

Use music.youtube.com in a desktop browser so you can see the whole track list.

Scroll to the bottom

Long playlists load in chunks. Keep scrolling until the last song appears, or you'll copy only the part that has rendered.

Select and copy the list

Drag from the first song to the last and copy. Paste into Excel.

Clean up the paste

Expect title, artist, album and duration to land in one messy column or with interleaved blank rows, and expect to remove them by hand.

This works for a 20-song playlist. It falls apart past a couple of hundred songs: the page virtualises long lists, so a select-all misses tracks; links to the individual songs don't come along with the paste; and view counts aren't on the page at all.

The reliable route

Export to CSV, then open it in Excel

Copy the playlist link

In YouTube Music, open the playlist, choose Share, and copy the link. A link from the browser address bar works too.

Paste it into the exporter

The tool detects whether it's a music playlist and starts on its own once the link is valid. Sign in with a free account if you haven't.

Download the CSV

The file downloads as soon as the export finishes.

Open it in Excel and save as .xlsx

Double-click the CSV, then File → Save As → Excel Workbook (.xlsx) if you want to add formatting, filters or formulas that a CSV can't store.

Why the CSV opens cleanly

Every value is quoted and the file is UTF-8 with a byte-order mark. That means song titles containing commas or quotes stay in one cell, and accented or non-Latin characters display properly instead of turning into garbage.
What you get

What each Excel column means

ColumnWhat's in it
track_numberPosition in the playlist — sort by this to restore the original order
title / cleaned_titleThe video title as uploaded, and a version with clutter like "(Official Video)" removed
artist / albumArtist name with the "- Topic" suffix stripped; album filled in when the playlist is an album
duration / duration_secondsReadable length, and the same value in seconds so Excel can sum it
views / likes / published_atPublic counts and the upload date of each song's video
video_url / yt_music_urlLinks that open the song on YouTube or in YouTube Music
channel / channel_urlThe uploading channel and a link to it
topic / media_type / is_musicGenre-style topic, and whether a row looks like an audio track or a music video
noteFlags a row that's unavailable — private, deleted or a YouTube Music exclusive
Putting it to work

Useful things to do once it's in Excel

  • Total the runtime. Sum duration_seconds and divide by 3,600 for hours — handy for road trips and event sets.
  • Find your top artists. Insert a PivotTable with artist as the row label and a count of track_number as the value.
  • Spot duplicates. Conditional formatting → Highlight duplicate values on cleaned_title. There's a dedicated walkthrough in finding duplicate songs in a YouTube Music playlist.
  • Sort by anything. The app can't sort by views or duration; a spreadsheet can, as covered in sorting a YouTube Music playlist.
  • Keep a copy. A dated .xlsx in your own storage is a backup that survives a deleted playlist or an account problem.

The tool

How MyFreshTools Helps

What the tool does

YouTube Music Playlist Export reads a YouTube Music playlist and writes every track to a CSV with the columns above. It detects music playlists automatically and adds genre-style insight for them.

Who it's for

  • Anyone who wants to sort, count or analyse a playlist outside the app.
  • People keeping a spreadsheet backup of a library they've spent years building.
  • Anyone sharing a clean track list with someone who doesn't use YouTube Music.

How to use it

  • Paste a playlist link — or Connect YouTube to pick from your own playlists.
  • The export runs automatically once the link is valid.
  • Open the downloaded CSV in Excel, or Google Sheets, Numbers or LibreOffice.

Requirements and limits

  • A free MyFreshTools account. No card; free credits on signup.
  • The download is a CSV, not a native .xlsx. Excel opens it directly and can save it as .xlsx.
  • Free plan exports the first half of the tracks (up to 1,000), with an upgrade row at the end. Paid plans export every track.
  • Private playlists need Connect YouTube, which is read-only — the tool never changes your playlists.
  • Metadata only. The file contains titles and links, not audio.
When it goes wrong

Troubleshooting

SymptomLikely causeFix
Everything is in one columnExcel is using a different list separator for your regionData → Text to Columns → Delimited → Comma
Weird characters in titlesFile opened with the wrong encodingData → From Text/CSV → File Origin: UTF-8
Views show as 1.2E+07Excel converted a long number to scientific notationFormat the column as Number with 0 decimals
Some rows say "Unavailable"Song is private, deleted or a YouTube Music exclusiveCheck the note column; see recovering deleted song titles
Only about half the songs are thereFree plan returns the first half of tracks (max 1,000)Upgrade for the full playlist
"Private playlist" errorPlaylist isn't public or unlistedUse Connect YouTube (read-only), or temporarily set it to unlisted

Frequently asked questions

No. YouTube Music has no export button of any kind. The practical route is to export the playlist to a CSV file, which Excel opens as a normal spreadsheet, and save it as .xlsx from there if you want the Excel format.

The YouTube Music Playlist Export tool downloads a CSV. Excel, Google Sheets, Numbers and LibreOffice all open CSV natively, and File → Save As gives you .xlsx in one step. The CSV is UTF-8 with a byte-order mark, so accented artist names and non-Latin titles display correctly in Excel.

That is an encoding problem, and it usually comes from a CSV that lacks a byte-order mark. The MyFreshTools export includes one, so double-clicking the file works. If you built the CSV some other way, use Data → From Text/CSV and choose UTF-8 as the file origin.

Yes. Every row carries a track_number column matching the playlist position, so you can sort the sheet however you like and always restore the original order by sorting that column ascending.

Yes, after you use Connect YouTube, which is read-only. Public and unlisted playlists can be exported by pasting the link, with no connection needed.

A free account includes free credits, and a free export returns the first half of the playlist's tracks (up to 1,000) with an upgrade row appended. Paid plans export every track.

The takeaway

YouTube Music has no Excel export, but a CSV gets you there in a minute. Export it, double-click it, save as .xlsx — and a playlist that was locked inside the app becomes something you can sort, count and keep.

Related MyFreshTools tools