How to export Spotify playlist tracks to Excel or CSV

If you want to export Spotify playlist tracks to a spreadsheet, for a track list to share, a backup or a move, Spotify's own routes are two: copy the tracks out of the app by hand, or download your Spotify data, which includes your playlists. This guide covers both, then turns the result into an Excel sheet, a CSV file or a plain list of songs.

Not with an export button: the Spotify help pages we read on 27 October 2026 describe no playlist export. What they do describe is Download your data, a copy of your account data that includes a summary of the playlists you created or saved, with their songs. For one short playlist, copying by hand is quicker; for all your playlists, or a long one, the data download is the dependable route.

1. Open the playlist in the Spotify desktop app.
2. Click the first track, then select the rest: Ctrl+A on Windows, Cmd+A on a Mac, or Shift-click the last track.
3. Copy (Ctrl+C or Cmd+C).
4. Paste into column A of an empty sheet, as plain text.

Look at what you pasted. If it's a column of names and artists, you're done. If it's a column of web addresses, one per track, those are the tracks' links: they identify each song, but don't name it, so for a list of titles use the data download below instead. For tidying a paste that comes out messy, our guide to copy and paste it properly covers the common fixes.

1. Sign in to your Spotify account page in a browser.
2. Open the Account Privacy section.
3. Use Download your data to request a copy of your account data, and follow the steps on the page.
4. When it arrives, download it: it is a ZIP file of several files, each holding one kind of data, with a "Read Me First" file that explains them.

Per Spotify, the Playlist part of the download is a summary of the playlists you created or saved, with each playlist's name, its last modified date, the song and artist names, album or episode names, the names of local tracks, the description and the number of followers. The Your Library part lists what you saved there, liked songs included. Both come as JSON files, a format made for software, so the next step is opening it in a spreadsheet.

1. Unzip the download and find the file for playlists.
2. In Excel, choose Data › Get Data › From File › From JSON, select the file and click Open.
3. Power Query opens and flattens the file into a table. If a column still shows List or Record instead of values, click the expand button in its heading to spread it into rows and columns.
4. Keep the columns you need, such as the playlist name, track, artist and album, and choose Close & Load. The table lands in a new sheet.

Microsoft lists the JSON import for Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016. One file holds all your playlists, so filter the playlist name column to the one you want, or keep them all.

Once the playlist is a sheet, File › Save As › CSV gives you a CSV file of it. A CSV holds one sheet, so save from the sheet with your playlist on it, and filter it to one playlist first if the file is for a single one.

For a list like "Song – Artist", one per line, add a column that joins the two, with the track in column B and the artist in C, and fill it down:

=B2 & " – " & C2

Select the column, copy it, and paste it into an email, a note or a text editor. Each track arrives on a line of its own.

Some services connect to your Spotify account to move or export playlists. Check what they can access before you connect one, and revoke its access when you're done.

Tabless is a browser extension that builds what you ask for from the sites you allow; nothing is typed or submitted without your OK. It isn't open yet. An export like this one is the kind of job we're building it for: asking in plain words for "this playlist's tracks, with the artist and album", and getting it as a CSV or XLSX file.

It's designed to read through the session your browser already has, so there are no API keys or passwords to hand over, and to ask before it reads each site. It's for lists you're entitled to see, for your own work, and the site's own rules still apply. You sign in to Tabless with a Wix account.

Spotify's data download covers the playlists you created or saved, so save a public playlist to your library first and it's part of your next download. Copying by hand works on any playlist you can open. Either way, it's a list for your own use.

Yes. Per Spotify, the Your Library part of the download lists the content saved in Your Library as of the date of the request, songs included, and the Playlist part includes any songs saved.

Not yet. Tabless isn't open, and exports like this one are among the jobs we're building it for. Join the waitlist, and we'll let you know when you can try Tabless.