Export playlist as text

[Viktolicious]

Hi,

I have used spotify since it's beta and I have basically build my biography on it. I listen to that song when I did that, that song is family vacation for me, etc. And now I want to have it backed up in a google sheet (or Excel) just to have all the songs, in the order I put them there, always available.

However, I do encounter a problem, since my list is from a long time ago it holds currently about 2500 songs, so Importxml doesn't work properly, and all the other apps are closed down or costs money, I was thinking if you have any suggestions on how to go about doing this? I want the title, the artist, the album, and the time I added it to the playlist.

None of the below information is required. However, the more you provide the easier it will be for us to try and help.

Plan

Premium

Country
Sweden

Operating System

Windows 10

My Question or Issue

[kaworu_bloodpaw]

Hi @Viktolicious

On your Spotify account page, you can request a copy of your personal data. One of these options includes your playlist data.

According to this support page,

You will receive these files in JSON format.

Playlist data includes:

1. Name of playlist.
2. Date the playlist was last modified.
3. Names of songs contained within the playlist.
4. Names of artists for each song.
5. Names of albums or episodes (if podcasts).
6. Local track name, if the user uploaded locally saved audio to be played on Spotify service.
7. Any descriptions added by the user to the playlist.
8. The number of followers the playlist has.

Hope this helps!

If my answer was useful, don't forget to give it a 'Like!' If my answer was the solution, don't forget to mark it as the solution! Thanks! 😇

If you need anything else, please reply and ask, or shoot me a Private Message! Feel free to follow my Spotify or Community profiles!  Disclaimer: I am not affiliated with Spotify.

[ldp017]

Plan

Premium

Country

USA

Device

PC

Operating System

Windows 11 Home

My Question or Issue

I would like to create a text list of songs in a playlist. How can this be done?

Thanks!