Announcements
The Spotify Stars Program: Celebrating Values Week!

Help Wizard

Step 1

NEXT STEP

A handy & useful way to backup your playlists

Solved!

A handy & useful way to backup your playlists

We've read all the posts about lost playlists, and its very frustrating when it happens.  Here's a simple way to back them up.

 

Using a Microsoft  Excel spreadsheet, just drag each playlist into a cell.  You not only see the original playlist name [sortable in Excel], each cell has the link embedded so you can click on it to open the playlist.

 

Other programs like Wordpad will save the links, but not the title.

Reply

Accepted Solutions
Marked as solution

I've also written a simple tool to make this easier:

 

https://github.com/watsonbox/exportify

 

It uses the Spotify Web API to export playlists to CSV format and will not store any private data (or any data at all in fact).

View solution in original post

13 Replies

Handy information @Rollo_ ! 

 

Thanks for sharing!

 

Peter

Peter
Spotify Community Mentor and Troubleshooter

Spotify Last.FM Twitter LinkedIn Meet Peter Rock Star Jam 2014


If this post was helpful, please add kudos below!

Man, I adore you, a thousand thanks for sharing this trick!

That sounds like it will take forever. I have thousands of playlists. 

With spotify's new api it is possible to automate some of this, I threw together an app so you can download playlists in csv (which you can import into excel):

 

http://joellehman.com/playlist/

@jai278-  This is a great feature- however, it only saves up to 100 songs 😕

@inkedwithstars - thanks, glad you enjoy it! if you hit the 'more' button at the end of the list, it should load 100 more songs (and you can keep on hitting more until all the songs are loaded); also, after you load all the songs that way, the playlist download should include all of them as well.

 

At some point I plan on automating that (so it fetches all the songs all at once); and also perhaps a way for you to automatically download all of your playlists at once/

This sounds like a great idea @jal278  but I'd feel more comfortable if I could just paste a playlist URI rather than logging into spotify through a third party site 🙂

I can understand the concern, @jwylot -- that would be better. But as far as I know in order to access playlists through the spotify API you have to log in. There may be an unofficial way to 'scrape' a playlist from just a URI, but it would be more fragile because the code might have to change every time spotify does an update on how they display playlists.

Thank you for the great app! We were able to back up ALL of our playlists which includes 100s of songs....
Marked as solution

I've also written a simple tool to make this easier:

 

https://github.com/watsonbox/exportify

 

It uses the Spotify Web API to export playlists to CSV format and will not store any private data (or any data at all in fact).

So far, from need of backupping my years of playlist work, this is by far the most satisfying solution.

 

Suggestions for improvement:

 

  1. Create one single CSV for all playlists with a Playlist column.
  2. Create one single Excel .XSLX, or each playlist in its own tab
  3. Allow to choose columns such as play length, spotify ID, etc.

Keep the good work going! Hope to hear form you soon at https://github.com/watsonbox/exportify

 

How many playlists do you have though, I have thousands upon thousands and Im wondering if this will work. Other methods I have tried always time out. 

http://joellehman.com/playlist/ is much easier, you can easily change your password afterward if that's a concern.

Suggested posts