Desktop (Windows)

[SherlockTAS]

I didn't want to put this in the New Idea section, as I am not really suggesting a new idea.

I started deleting a lot of the mp3s off of my computer in favor of just listening to the same songs over Spotify.  I needed the extra hard drive space because I still have a Windows XP computer.

I have no use for listening to music offline as I only have a desktop computer and can't currently even burn CDs with this lousy PC.  I can't afford Spotify Premium anyway and have no devices to listen to it on.

I wanted to know if there was any way to make a backup of the Spotify playlists.  I was thinking of a simple playlist file that could be exported to your computer as backup.  I have noticed a lot topics on here having to do with playlists accidentally being deleted or disappearing and it has made me nervous.  I don't want that to happen to me now that I have begun migrating to Spotify and away from mp3s.

[Peter__]

Hey! Welcome to the community 🙂 

When Spotify playlists get deleted from accounts, they never really get deleted they just get removed from being displayed on your account. With that in mind, if you save the links to all of your playlists (Right click on playlist name > Copy Spotify URI) and keep them in a text file, if a playlist ever goes missing you can just copy that URI into the main search box and your playlist will appear 😉 

Peter

[SherlockTAS]

Good to know.

Thanks for the info.

[Rollo_]

You can also drag them right into an Excel spreadsheet.  Makes them easy to sort.  No right-clicking or pasting.  Easy and fast.

[dschultznet]

Drag and drop from Spotify app to Excel 2010 does NOT work for me.

[Joe]

I think Rollo meant dragging the tracks within a playlist to excel.

I'm just wondering if this is necessary with playlists you have made public since you can always find them again on spotify. All you might want to do is to save the playlist links themselves. Drag each playlist to a text file in notepad++ or other decent text editor and save it as myplaylists.html or something.

[Rollo_]

jwylot wrote:
I think Rollo meant dragging the tracks within a playlist to excel.

Nope.  Drag the playlist title into an Excel cell.  Excel will show the playlist title, but if you hover your mouse pointer over the cell, you'll see the embadded http link.  Its clickable and Spotify will open it, even if Spotify is not running.  Spotify version 0.8.3 and 0.9.1.57 with Excel 2007, both working.  AFAIK, there is little funcionality difference between Office 2007 and 2010, though I might be able to confirm that.

Be sure to first click on the playlist title so that it's selected, then drag it.  If its not fully selected, it won't drag.

[Joe]

Heh, for some reason it didn't work when I tried quickly but you're right - it does work with Excel 2010 too 🙂

[Rollo_]

I've found this to be the only way to back up the playlist location while still showing the playlist name.  The http link doesn't tell you a thing about the playlist, other than its web address.

I keep all my playlists alphabetized and sorted by genre in Excel, and its simple.  Someone ought to try doing the same thing in Open Office, since its freeware.

[obhayden]

None of these are really solutions for exporting playlists.  What people want is to be able to export all their playlists, each list with all songs/data listed.  HTTP link is useless for importing into another player, program.  Ideal is an XLS export that has playlist names as column headers, and song info in various cells.

Anyone?

[Rollo_]

    obhayden wrote:

    HTTP link is useless for importing into another player, program.

Which player supports streaming Spotify?  Not sure what you're trying to accomplish.

[ach8d]

Here's the solution!

http://www.worldstart.com/spotify-%E2%80%93-back-up-those-playlists/

[jal278]

Another option is an app I threw together that allows you to save playlists as csv (which you can open in excel):

http://joellehman.com/playlist/

[icurate]

Thanks for sharing this jal278. I love it.

[Matol788]

Hm, this doesn't seem to work on playlist folders? Any chance you can share your code so that I can make an improved personal version?

[fassbrause]

Hi, I found this webapp. 

http://netz.kiwi/spotify/backup

Sometimes slow but you can backup all of your spotify playlists.

[hans-jürgen]

Both of the last mentioned export tools do not seem to recognise all of my playlists, only a part of it. I also use nested folders, maybe that is the reason.

[fassbrause]

The first does not show all of my playlists but the second does.

Even though both do not recognize folders.

[hans-jürgen]

I think it might have to do with collaborative playlists, maybe also with secret vs. public playlists. But this should not matter for an export tool, because I created them all. Perhaps it should even export playlists that I only follow and have not created myself. Anyway, an easy backup of a collaborative playlist would be very useful, as these might get destroyed by other Spotify users.

[railsnapraia]

Works like a charm!