Download Spotify Playlist Tracks
If you’re looking to promote your music on Spotify, then playlists can be a great way to do so, as this is how many Spotify users discover new music and artists. Alternatively, you may be interested in tracking how different playlists are performing or investigate the unique composition of certain playlists (e.g. which artists are co-listed in popular playlists together).
Whatever your reason for wanting to better understand certain playlists, the Spotify API will allow you to download all tracks for any publicly available playlist on Spotify (yes, even very large ones). This page provides a form that will query the Spotify API on your behalf for any playlist ID and return back the individual tracks on that playlist in downloadable CSV format. You simply need to provide the Playlist ID (you can get this from the URL of the playlist or other Spotify API endpoints) and your Spotify API key, which is free and easy to get.
The response will contain about 50 individual tracks, complete with title, link to preview the audio, and a popularity score estimating how popular the song currently is doing on Spotify (independent of the playlist). To get the full list, you will need to see the pagination instructions on the following page or see the workflow version of the API endpoint, which will automatically query the Spotify API on your behalf page by page and combine all of the playlist tracks together as a single CSV file you can analyze in Excel or your tool of choice.