topic Re: Export Playlist / Backup in Desktop (Windows)

Export Playlist / Backup

SherlockTAS — Thu, 18 Apr 2013 02:49:52 GMT

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.

Re: Export Playlist / Backup

Peter__ — Thu, 18 Apr 2013 20:26:20 GMT

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

Re: Export Playlist / Backup

SherlockTAS — Thu, 18 Apr 2013 22:06:33 GMT

Good to know.

Thanks for the info.

Re: Export Playlist / Backup

Rollo_ — Fri, 19 Apr 2013 00:10:32 GMT

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

Re: Export Playlist / Backup

dschultznet — Mon, 22 Jul 2013 15:01:49 GMT

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

Re: Export Playlist / Backup

Joe — Mon, 22 Jul 2013 15:10:36 GMT

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.

Re: Export Playlist / Backup

Rollo_ — Tue, 23 Jul 2013 11:45:34 GMT

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.

Re: Export Playlist / Backup

Joe — Tue, 23 Jul 2013 14:07:31 GMT

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

Re: Export Playlist / Backup

Rollo_ — Tue, 23 Jul 2013 15:22:03 GMT

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.

Re: Export Playlist / Backup

obhayden — Sat, 16 Nov 2013 15:43:39 GMT

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?

Re: Export Playlist / Backup

Rollo_ — Sat, 16 Nov 2013 18:31:13 GMT

    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.

Re: Export Playlist / Backup

ach8d — Wed, 22 Jan 2014 02:11:41 GMT

Here's the solution!

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

Re: Export Playlist / Backup

jal278 — Tue, 17 Jun 2014 19:42:11 GMT

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/

Re: Export Playlist / Backup

icurate — Wed, 02 Jul 2014 18:40:57 GMT

Thanks for sharing this jal278. I love it.

Re: Export Playlist / Backup

Matol788 — Sun, 14 Sep 2014 19:14:45 GMT

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?

Re: Export Playlist / Backup

fassbrause — Fri, 21 Nov 2014 18:09:15 GMT

Hi, I found this webapp.

http://netz.kiwi/spotify/backup

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

Re: Export Playlist / Backup

hans-jürgen — Fri, 21 Nov 2014 18:23:17 GMT

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.

Re: Export Playlist / Backup

fassbrause — Fri, 21 Nov 2014 18:25:46 GMT

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

Even though both do not recognize folders.

Re: Export Playlist / Backup

hans-jürgen — Fri, 21 Nov 2014 18:52:49 GMT

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.

Re: Export Playlist / Backup

railsnapraia — Wed, 25 Feb 2015 17:32:43 GMT

Works like a charm!