A handy & useful way to backup your playlists

Solved!
Reply

A handy & useful way to backup your playlists

Rollo_
Roadie

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Solution!

watsonbox
Regular

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

Peter__
Community Legend

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!

Xacalet
Newbie

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

jckinnick
Roadie

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

jal278
Regular

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/

inkedwithstars
Newbie

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

jal278
Regular

@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/

Joe
Community Legend

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 🙂

jal278
Regular

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.

gschu
Newbie
Thank you for the great app! We were able to back up ALL of our playlists which includes 100s of songs....
Solution!

watsonbox
Regular

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

Saintnick
Regular

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

 

jckinnick
Roadie

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. 

timothyjhorton
Casual Listener

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

SUGGESTED POSTS