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 readA 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.
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.
The manual method (and where it breaks)
Open the playlist on the web
Scroll to the bottom
Select and copy the list
Clean up the paste
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.
Export to CSV, then open it in Excel
Copy the playlist link
Paste it into the exporter
Download the CSV
Open it in Excel and save as .xlsx
Why the CSV opens cleanly
What each Excel column means
| Column | What's in it |
|---|---|
| track_number | Position in the playlist — sort by this to restore the original order |
| title / cleaned_title | The video title as uploaded, and a version with clutter like "(Official Video)" removed |
| artist / album | Artist name with the "- Topic" suffix stripped; album filled in when the playlist is an album |
| duration / duration_seconds | Readable length, and the same value in seconds so Excel can sum it |
| views / likes / published_at | Public counts and the upload date of each song's video |
| video_url / yt_music_url | Links that open the song on YouTube or in YouTube Music |
| channel / channel_url | The uploading channel and a link to it |
| topic / media_type / is_music | Genre-style topic, and whether a row looks like an audio track or a music video |
| note | Flags a row that's unavailable — private, deleted or a YouTube Music exclusive |
Useful things to do once it's in Excel
- Total the runtime. Sum
duration_secondsand 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.
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.
Troubleshooting
| Symptom | Likely cause | Fix |
|---|---|---|
| Everything is in one column | Excel is using a different list separator for your region | Data → Text to Columns → Delimited → Comma |
| Weird characters in titles | File opened with the wrong encoding | Data → From Text/CSV → File Origin: UTF-8 |
| Views show as 1.2E+07 | Excel converted a long number to scientific notation | Format the column as Number with 0 decimals |
| Some rows say "Unavailable" | Song is private, deleted or a YouTube Music exclusive | Check the note column; see recovering deleted song titles |
| Only about half the songs are there | Free plan returns the first half of tracks (max 1,000) | Upgrade for the full playlist |
| "Private playlist" error | Playlist isn't public or unlisted | Use 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.