Exporting your Last.fm listening history to Spotify playlists

  • 25
  • 31
  • Article
  • Updated 2 days ago
  • (Edited)
In the meantime direct playback in the Spotify desktop client of all available Last.fm radio stations or on-demand from any Last.fm page showing tracks has been implemented on the new site and works reliably - most of the time. ;-) The direct playback did not work in Spotify's mobile apps or in their web player in the past, but nowadays you can switch playback from the desktop client to any Spotify Connect app listed under the related icon in the lower right corner next to the volume slider. That includes their web player (if started in parallel to the desktop client), their mobile apps and all other Spotify apps on game consoles, smart TVs, WLAN speakers etc. You can also try the split-screen mode of newer Android devices to open your Last.fm profile in one half and the Spotify Android app in the other half of the screen. All this only works if you have a Spotify Premium account though.

Furthermore having your complete Last.fm listening history available as Spotify playlists is also useful for getting better recommendations within Spotify, because they suddenly know much more about your musical taste than before. For example their new Daily Mix feature with up to six mixtapes from parts of your library benefits from that, but also your Discover Weekly and Release Radar playlists.

In a pinned thread of the old "Last.fm for Spotify" support group I described how to export your complete Last.fm listening history with the online tool Last.fm to csv and import it as one or more large playlists in Spotify with Ivy. The new tool Tune My Music to which the old URL redirects now can be used as a replacement, as it also allows CSV file uploads. With a little extra work you can also use e.g. Playlist Converter, Soundiiz, Stamp, a Windows Powershell script or the textbox of Spotlistr for this conversion.

As there is a 10k tracks limit for single playlists in Spotify, you may have to edit the downloaded CSV file if it is longer than that, e.g. in Excel, LibreOffice Calc or another spreadsheet application. Furthermore you can delete unnecessary data like the album and scrobble date columns as well as duplicate scrobbles and also sort it.

You can listen to your Last.fm library again in Spotify if you play these large playlists from one playlist folder in their desktop client in shuffle mode, their mobile app folders unfortunately do not offer this option since March 2017 anymore. If you need more info or have questions about this method, please ask in this thread.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes

Posted 4 years ago

  • 25
  • 31
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
OK, it looks like Last.fm to csv and Ivy work again, at least most of the time, so it should be possible to convert your complete Last.fm listening history to a Spotify playlist at the moment.

As an example I did this for user Rontambo who has about 24k scrobbles, but after eliminating his duplicate tracks from the CSV file only 2,514 "unique scrobbles" were left, as he seems to be listening to his favorite tracks very often. ;-)

And Ivy found 2,055 tracks in Spotify, so this is the public playlist of his scrobbles now:

https://open.spotify.com/user/1139245365/playlist/72B5c9qcrgJtBOgsZqOSsv

Rontambo, if you want to make this your own, simply highlight all tracks in the Spotify desktop client and copy them to a new playlist on your own account, as it is hosted under my username at the moment. If you enable Shuffle Mode in the Spotify software, it will behave like a random radio station and not play the artists alphabetically.
(Edited)
Photo of Rontambo .

Rontambo .

  • 6 Posts
  • 1 Reply Like
@ Hans-Jurgen,Champion

I thank you very,very,very much__:-)))___Without your help , I would be struggling.
 
Last.fm has given me so much I did not hear elsewhere.  Now ,it has given me U.

  I will , of course , miss the features that have gone since 2010 . But to discover so much at L.fm  and be able to obtain it through Last.fm connection to 7 Digital and Amazon has made music gathering / listening quite fulfilling.

As for copying to new Spotify Playlist . . . I have my work cut out for me_:-)
I am not finish with the " A " names yet.

Re: to favorite tracks . . . Favorites = Love . I want Love everyday ___:-)))))))))

I humbly , thank U a gain . . .

PS. . . . please leave the scrobbles  available until I can finish copying it.

Peace
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Sure, no problem, but you can copy them in one go: click on the first track of that playlist to highlight it, so it is shown with a grey background. Then choose "Select All" from the Edit menu in Spotify, or simply press Ctrl+A on a Windows PC. Then right-click on any highlighted track and choose "Copy to playlist..." in the context menu. You don't have to do this manually for each track.
(Edited)
Photo of Rontambo .

Rontambo .

  • 6 Posts
  • 1 Reply Like
Thank U , sir. Task accomplished !  First , I had to " follow " you then I could access and copy to new playlist ( Rontambo - Lastfm ) You were right - one click___:-)
Photo of Sarah Paine

Sarah Paine

  • 3 Posts
  • 0 Reply Likes
I've tried following this - Ivy falls over with my last.fm playlist (it's 56k scrobbles, and nearly 17k uniques).. So doing it bit by bit..  Ivy copes.. Copied the created file.. and now what?

I can "create" a playlist on spotify (it's empty) - but where the heck can I import the Ivy info into? the only options on Spotify under "import playlist" are windows media player and itunes.. neither of which I use - I want to import my last.fm history :)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
You need to create separate CSV files with less than 10k tracks and upload them separately, also adding a first row with "Artist" and "Track" sometimes helps to recognise these two columns in Ivy. Or you simply copy less than 10k tracks in the opened CSV file and paste them directly in Ivy's Copy&Paste tab which sometimes is more reliable than a CSV file upload. And Ivy sometimes stops processing in the middle, so you have to restart the procedure again.

If you have saved Ivy's search result in a text file, you can paste it from your clipboard to a new playlist either with the menu  option "Edit -> Paste" or with Ctrl+V in the Spotify desktop client. Just yesterday I had to use that key combination instead of the menu option in Spotify 1.0.14, as the former would not work and closed the desktop client instead. It takes a few seconds for so many tracks to be added in Spotify, too.
(Edited)
Photo of Sarah Paine

Sarah Paine

  • 3 Posts
  • 0 Reply Likes
there is no option under "import playlist" except to import from iTunes or Windows media player, and there is no "edit > paste" option shpwing in any place I can see.

CtrlV doesn't work anywhere in the desktop version. I've tried pretty much every location in every screen.

I tried with only 100 lines in Ivy to test first, after it fell over 4 times..

either I've got a completely different version of the spotify desktop than anyone else (I only just downloaded it) or there's something missing.
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
@Sarah, I always have to click into the empty space of the newly created playlist first - only then can I paste the data from Ivy (with ctrl+v / cmd+v on Mac). I have no idea why that is, but it's the only way I can get it to work.
So to repeat: try creating a new playlist in Spotify, select it in the sidebar and click somewhere in the empty space where the tracks normally are. Then press ctrl+v and wait - like Hans-Jürgen said, it might take a while until the songs appear.
Photo of Sarah Paine

Sarah Paine

  • 3 Posts
  • 0 Reply Likes
Thanks - I'll give it another try, but the problem seems to be that there is no empty space - there are adverts. If it still doesn't work I'll post a screenshot and see what we can work out perhaps :)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
there is no option under "import playlist" except to import from iTunes or Windows media player, and there is no "edit > paste" option shpwing in any place I can see.
That's right, "import playlist" is the wrong File menu option, as it can only import existing playlist files from iTunes or WMP. You can try it with the Edit dropdown menu and click on "Paste" there after choosing your new playlist in the sidebar. As somepixiessong mentioned, it might be necessary to put the focus into the header of the empty new playlist first before pressing Ctrl+V. And of course it is necessary that the Ivy search result is in your clipboard, i.e. you have to copy it directly from Ivy or a saved text file first. Last but not least it must be below 10k tracks, otherwise the desktop client will not accept the pasted tracks due to the internal limit.

You can also tell me your Last.fm username, then I could try to create these playlists for you.
(Edited)
Photo of SpaceOctopus

SpaceOctopus

  • 3 Posts
  • 0 Reply Likes
I don't understand how you were even getting last.fm in spotify in the first place.... I lost that feature several months ago (was devastated, too) and haven't seen anything like it since then.... :(
Photo of Chad Johnson

Chad Johnson

  • 54 Posts
  • 97 Reply Likes
I share the same sentiments. Last.fm did an incredibly stupid thing. If I was in charge, I would fire the marketing department and bring back the old site.

I am a seasoned web developer (frontend/UI/JavaScript focused, but with plenty backend experience) and am working on recreating the last.fm web player. Last.fm still makes the data feed for your account available, so this new player will consume that data and produce a YouTube player in the same fashion that the original player did. This will be open source via GitHub and free for all. I'll be hosting a copy as well using Amazon S3.

Would you be interested in using this new player?
(Edited)
Photo of Chad Johnson

Chad Johnson

  • 54 Posts
  • 97 Reply Likes
Well, the feed pulls from your stations. So you could select your Mix or Neighborhood radio stations and play from one of those. Those automatically suggest new songs based on your play history.

As for loving and banking tracks, the player would interact with Last.fm's API. Assuming the API is still operational, this should be doable.

Does that answer your questions?

As for tagging, what are you referring to? Are you wanting to tag tracks yourself with your own custom tags? I have never done this...maybe last.fm provided this functionality previously?
Photo of chx

chx

  • 9 Posts
  • 2 Reply Likes
Chad, I am really interested, contact me chx1975 gmail (I am a seasoned backend developer, but I dislike JS alas)
Photo of Chad Johnson

Chad Johnson

  • 54 Posts
  • 97 Reply Likes
I tried sending you an email, but it bounced. So here is what I tried to send. You and everyone else can email me at chad.d.johnson gmail com.

If you'd like to collaborate, I'm down. However, note that I am architecting things such that there will be no backend in this project. This client will interact directly with the last.fm JSON feed, and then ideally it will interact directly with the last.fm API via client side JavaScript.

I am planning to use the following technologies:

* Angular 2
* TypeScript and ES6
* Node.js and NPM
* YQL (for pulling down the feed in a purely client side manner)
* webpack or Gulp
* Material Design

I've selected Angular 2 because I need to learn it for a new job I am starting soon. I've selected TypeScript because Angular 2 requires that (honestly I'd rather stick with standard ES6, but oh well).

If you are (or if anyone else is) interested or have any questions, please let me know.
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
@Hans-Jürgen, after reading your post I did a test-conversion of 3.000 tracks with Ivy and it worked flawlessly for me - it went through in less than 15 minutes :)

Even though the Last.fm radio is back in working condition, I still recommend the Last.fm to CSV method. It looks more complicated than it actually is - once the list is in LibreOffice or Excel, it's basically done and you just have to wait while Ivy does its thing ;)  For me it's great that I have my complete listening history available in Spotify because it's the only way to get my Last.fm Library Radio (sort of) working on my iPhone.

(*) An automated alternative to Last.fm to CSV is SeasonSound, a great tool that creates playlists from specific time periods of a user's listening history.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2182 Posts
  • 1143 Reply Likes
Yes, if Ivy is working correctly, it will take about an hour for a list of 10k tracks which is the limit for Spotify playlists anyhow. But it looks like the CSV upload is still broken, you have to use the Copy&Paste tab of Ivy to upload a plain text list and process it.

This method to recreate your Last.fm library radio on Spotify is also the only way if people cannot use their desktop client and must use their web player for example at work or their mobile apps, as the radio play links on the new Last.fm site do not work there.

To recreate other radios like recommendations or mix, you would have to check the other tools mentioned in the old pinned thread like e.g. Lazify which gives you a list of similar tracks to the one you like on your mobile phone. Maybe Spotibot or other tools like Spotlistr can still give you a list of recommended tracks, so adding their generated playlists to a new playlist folder in Spotify besides your converted listening history would be the way to go.

Last but not least you could also use an IFTTT recipe to automatically update the Spotify playlists representing your Last.fm library, see this recipe for an example.
(Edited)
Photo of beastyfellow

beastyfellow

  • 2 Posts
  • 1 Reply Like
Being fed up with Spotify integration and 3rd party tools I created simple Excel macro that pulls Last.fm radio streams (library, mix, recommended), removes duplicates and creates "spotify:track" list. You can then copy-paste it to new playlist in Spotify. Ta-Da - you get old good radio back again. Feel free to use AS IS if you find it useful. Works well with Spotify 0.9.15.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2182 Posts
  • 1143 Reply Likes
Had only a short look at it with LibreOffice Calc which blocked the execution due to a security warning and settings, but looks promising so far. I assume I can fill in my own username, preferred radio station and length of the playlist (10k tracks would make sense due to Spotify's internal limit) when it works in LibreOffice? Did you try to pull a neighbours or friends or loved tracks radio station with the API as well? That would be very interesting of course, as these are not available yet on the new site.
(Edited)
Photo of beastyfellow

beastyfellow

  • 2 Posts
  • 1 Reply Like
You'd definitely need MS Office (mine's 2013) - I don't think macro will work with LibreOffice. I'm not making a living of programming, just used the tool at hand to solve issue quickly :) There were days when people scared of macros in documents, yet it's no different to flash or java. Macro code is open and feel free to check with antivirus as well ;) I can try to pull other stations as long as somebody gives me URLs which return "spotify:track" IDs. the URL I use (http://beta.last.fm/player/station/user/[username]/[station]
) is kind of a hack, that I found online, no idea how to pull data for neighbours, friends, etc
(Edited)
Photo of Chad Johnson

Chad Johnson

  • 54 Posts
  • 97 Reply Likes
Oh wow, interesting. This page still works and returns JSON data.

ALMOST makes me want to create a simple web page to consume this and play videos. Hmmm. I could easily host this on S3+Cloudfront, too. Hmmm.
Photo of Joshua Finks

Joshua Finks

  • 49 Posts
  • 31 Reply Likes
You guys do realize I have made something like this already? It pulls the JSON and parses the track URLs into a format that you can then just copy and paste into the Spotify Desktop app. I'm working on a few more features, but hopefully soon it'll be able to allow always-newly generated playlists based on a certain station:
http://jfinks.netai.net/
Chad if you'd want to help me or want to collaborate, I'd love that. But take a look at what I've got so far.
The thread I keep updated about it is here
https://getsatisfaction.com/lastfm/topics/-app-last-fm-to-csv-generator
Photo of Chad Johnson

Chad Johnson

  • 54 Posts
  • 97 Reply Likes
Nice job, Joshua.

What I'm wanting to build is something that integrates with YouTube instead of Spotify. And, I want to remove any manual steps of repeatedly building playlists and make the software automatically re-pull the feed as needed.
Photo of Joshua Finks

Joshua Finks

  • 49 Posts
  • 31 Reply Likes
Can't help you with the YouTube end. This is actually my first coding project in years. I intend to add Spotify OAuth shortly. I am going to also run a script to fool Last.fm's scrobbler into thinking it's working. Developing this tool I realized the duplicates are often due to scrobbling outside the Last.fm beta player. If you scrobble a few tracks there it will repopulate the list with very few duplicates.

The entire purpose of my tool is to do exactly as you said re-pull the list as necessary. My "ultimate" goal is to have a Spotify playlist that once you've scrobbled through the list it'll repopulate itself with new recommendations on the fly. The idea being allowing you to have an ongoing "radio" of sorts for use on mobile. I think it'll be much easier to do with Spotify. Shoot me an email if you want to work with me on it at all. I'm interested to get your take
fefifochizzle@gmail.com
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
By the way, if you are living in a country where Spotify is not available you might check if Deezer is, because there are tools to convert Spotify playlists to Deezer. The one currently working best is Spotizr, because it automatically splits too large Spotify playlists to 1.9k tracks lists and finds a lot of the Spotify tracks on Deezer, as their catalogues are quite comparable. Soundiiz seems to have problems with large playlists at the moment, Playlist Converter as well. Mooval takes too long, because it analyses your complete Spotify library first before offering to convert a playlist.

Of course you would have to ask someone with a Spotify account first if he would host your converted playlists from Ivy on his account, so you have a Spotify playlist URL to use on these Deezer converters. I did this during the weekend for someone from Georgia, and it is not that much work actually. Last but not least this is the only currently working method for people outside of Spotify land to listen to their Last.fm library radio again besides using VPN services etc. The best way would be a direct conversion of the CSV files fetched with Last.fm to csv to Deezer, but I don't know any converter offering this yet.
(Edited)
Photo of Mauricio Hernandez

Mauricio Hernandez

  • 7 Posts
  • 4 Reply Likes
There is another workaround, takes too long but you could use youtube to play your music.

  1. Convert your last.fm library to csv http://benjaminbenben.com/lastfm-to-csv/
  2. Open it in excel or google docs and copy like 600 songs
  3. Paste them here, to create a spotify playlist http://spotlistr.herokuapp.com/#/search/textbox
  4. And here http://www.playlistbuddy.com/ you could convert your spotify playlist into youtube playlist (with a 200 songs limit)
I have converted some songs using this method and works very nice

It's a very stupid and annoying thing must do all the above things in order to play music like we did in the previous last.fm design, the redesign lost the website focus which was listening to music, that's a shame.

Right now i stopped using last.fm and now i'm using Deezer and Youtube
Photo of chx

chx

  • 9 Posts
  • 2 Reply Likes
As there is a current problem with the latest Spotify desktop clients 1.0.12 and 1.0.13 playing only one track of a Last.fm radio station or on-demand playback
Oh? That's a known problem? Any ETA on when it'll get fixed? I am on 1.0.16 already and it still happens.
(Edited)
Photo of Donald Price

Donald Price

  • 2 Posts
  • 1 Reply Like
last.fm to csv has stopped working for me.  Something I'm doing wrong?
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2185 Posts
  • 1146 Reply Likes
Same for me, it seems to be broken, as there already is a related new issue on the GitHub project page. Hopefully the developer will see it soon.
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2185 Posts
  • 1146 Reply Likes
Update: fixed by developer.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
It looks like Ivy cannot import CSV files to Spotify playlists anymore, because Spotify has changed its API. See this message from the Ivy developer on his first page:

Ivy is currently being rebuilt.

 After 6 years of support, Spotify finally retired their old API and Ivy can't quite work with the new one yet. This requires a rewrite of many parts of the tool. This will take some time. An ETA can't be given at this moment. I know a lot of people are enjoying Ivy and would like to see it back. It started as a hobby project back in 2010 and has since then grown to become a website where more than 200 people upload their playlists every day."

This might also affect all other available playlist converters like Soundiiz, Stamp or Mooval if it is true. OK, just tested Spotlistr with directly copying & pasting from an open CSV file to its textbox, and it seems to have worked, got a new playlist in Spotify's desktop client with the found tracks after a few seconds. So that method is still available at least, maybe also for other playlist converters.

(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
I just got a reply from the Stamp support that it already can handle CSV files for import, e.g. your exported Last.fm listening history. So that app would be another alternative, although it is not free. It also is one of the few that allows conversion to and from Google Play Music and Apple Music in case you don't like Spotify.
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
By the way, if you want to keep your converted Spotify playlists up-to-date with every new scrobble on Last.fm, you could use an IFTTT recipe for that, e.g. this one where you would have to specify the exact name of your last converted Spotify playlist. It would of course also add duplicates to that list, so you may prefer the original method where you sort all your scrobbles in the CSV file first and then eliminate duplicates with your spreadsheet application.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Some related news from Spotify: they have improved their shuffle algorithm for all users since today, see this posting in a related idea on their community forum.

So this may solve the annoying early repeat issues for mobile users who could not use the last improvement from about a year ago yet, as far as I know. For me the shuffle mode works as fine as it always did in the desktop client when listening to my converted Last.fm library.
(Edited)
Photo of James Joul

James Joul

  • 983 Posts
  • 2014 Reply Likes
Finally, it's about time! I have a Spotify playlist with 1,500 of my current favourite songs and I was still hearing the same ones over and over on shuffle. Can't believe it took them this long.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
 It looks like Playlist Converter can also use CSV files now. A short one just worked, a longer one with 4k tracks froze while searching, but may have been formatted with too many columns (only Artist and Track are used like Ivy), so edit your CSV file accordingly. Another try with a 9k tracks file seems to have worked which took about 2 hours for searching. The site is getting very slow with so many results to display, too.

After search has finished, you can choose between several options what to do with the results, e.g. export to a plain text list, to YouTube, Deezer or Spotify. If you want to create a new playlist in Spotify's desktop client, you have to login, and the playlist will be automatically created there. The service is free like Ivy's, by the way.
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
A Reddit thread about Last.fm recommendations as a Spotify playlist just reminded me that you can still play your personalised recommendations radio from your Last.fm user profile or homepage in their desktop client and e.g. copy what you have heard from the history tab of its play queue to a new playlist if you want to keep the tracks in a list. See this screenshot:



You only have to highlight all music tracks from that list by pressing the Ctrl key and click them with your mouse leaving out the ads, right-click one selected track and choose Add To Playlist and New Playlist from the dropdown menu. If you select all tracks including the listed ad spots, it will not work though, so you have to pick the music tracks from the history first.

Of course this would also work with anything else that you have listened to in Spotify, e.g. your other personal, global tag or similar artists radios or your loved tracks.
(Edited)
Photo of susan starbird

susan starbird

  • 2 Posts
  • 0 Reply Likes
Mr. H-J: please provide a version of the above instructions called "Playlist conversion for dummies." Or "listen to good old Last.FM at last.fm on your desktop." Or "how to listen to your Last.fm custom playlist of 1000+ songs when Spotify doesn't recognize it." I have all these problems. And yes I subscribe to Last .
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
What is your Last.fm username, and what exactly does not work for you?
Photo of susan starbird

susan starbird

  • 2 Posts
  • 0 Reply Likes
K-STARB. I cannot add new songs to my playlist. Spotify does not recognize that I have a playlist. Does this help?
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
I'm not sure what you mean with "your playlist". Checking your account you don't have created any playlists back then on the old site:

http://www.last.fm/user/K-STARB/library/playlists

So I assume that you refer to your library of 1,801 scrobbles which I can play by simply clicking on the "Play your library" button on your user profile. This only works if you have installed and started the Spotify desktop client though.

If you want to add more scrobbles to your library, just fill in your Last.fm login details in the Edit/Preferences menu of the Spotify desktop client (press Ctrl+P to call it), then everything you listen to on Spotify will be scrobbled to your Last.fm profile. See also the new Track My Music page for more details.

Nice blues based music taste, by the way. ;-)
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
There is a new online tool for backing up your listening history to a CSV or XML file:

http://mainstream.ghan.nl/scrobbles.html

It is faster than Last.fm to csv and has more details like the MusicBrainz ID (MBID) for each scrobbled track/album/artist, so the resulting file size is about as twice as big (50mb for a library with more than 270k scrobbles). As mentioned above, you would not need all these details for creating a Spotify playlist from it, but it is "nice to have" of course.

You would have to make sure that you enable double quotation marks as a text divider in the import window of your spreadsheet application, otherwise the shown columns get scrambled. See this screenshot when importing the CSV file in LibreOffice Calc:



Another "nice to have" online tool is Last.fm Backup which provides a ZIP file (36.5mb size for me) with separate JSON files for each year of your listening history. You need to know how to handle this file format though and/or use one of the available online JSON viewers or editors.
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Soundiiz can handle the CSV format now for uploaded files, so it should be able to work as a full replacement for Ivy when converting your Last.fm listening history to Spotify playlists.

And they are asking on their Facebook page which other format options they should offer for their new version:

https://www.facebook.com/Soundiiz/posts/836639409803633

My ideas would be everything from Last.fm and Apple Music. ;-)
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Spotify is rolling out a new Daily Mix feature starting with mobile users, but desktop users will also have these new playlists or mixtapes soon. You get up to six different playlists every day based on parts of your library and sorted by genre. So if you have already added your complete Last.fm listening history to Spotify with large playlists, this new feature can benefit from it and works like a library or mix radio specified by genre which automatically refreshes itself.

At the moment you can only see these Daily Mix playlists in the Spotify Android and iOS apps. You don't have to be a Premium subscriber for that, even sending the currently playing list from your Android device to your Spotify desktop client works with a free account if they are on the same LAN/WLAN, but not the other way around, i.e. connecting your desktop app to mobile.

(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
Hi Hans-Jürgen! Good to see that you are still on the look out for new music tools & services to share with the community! I really hope it won't be too long before Last.fm re-introduces Groups in some form or another, so that we can get a Spotify/Last.fm-tools-Group going again ;)

Anyway, I just checked out the Daily Mix feature today and it is fantastic, I absolutely love it! It seems like Spotify keeps getting better and better at recommendations, they've done some really impressive stuff in the last year or so.

Speaking of music tools: the excellent iOS app Songshift just had a huge update that introduced Last.fm as one of the services (Discogs was added as well). You can now send your loved tracks to Apple Music, Spotify, Deezer and Tidal with one tap. I haven't tried that part of the app as I already have all my loved tracks in Spotify and Apple Music, but I constantly use Songshift to send my Discover Weekly playlists from Spotify to Apple Music and it works flawlessly, at least 95% of tracks are always found, it's blazingly fast and has a beautiful interface. It's only available for iOS though, afaik.
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Right, there still is enough to talk about the Last.fm - Spotify connection (e.g. that Spotify is available in Japan now), and I hope that the content of the old support group can be fully imported in a new user group.

I just noticed that I haven't yet mentioned the new Spotify feature of creating a similar tracks playlist from every playlist in the desktop client. In other words, it works like Lazify for existing playlists including your Discover Weekly, Release Radar and all Daily Mixes, so you can create as many of these personalised playlists as you want directly from the dropdown menu. I think Matthew Ogle got inspired by Last.fm's Mix Radio for the Daily Mixes with the additional option of sorting them by genre. Maybe we will see a similar option of adding a tag to Last.fm's radio stations again sometime in the future, either internally or with an external tool like Combo.fm.

SongShift looks like a nice app to have on Android, too, perhaps the developer is able to compile it for that OS as well.
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
I hope that the content of the old support group can be fully imported in a new user group.
That would be fantastic. There's a lot of information and content in many of the old groups that is still relevant/interesting/entertaining, it would be a shame to leave all of that behind for good...
I just noticed that I haven't yet mentioned the new Spotify feature of creating a similar tracks playlist from every playlist in the desktop client.
Wow, how did I miss that feature??? I just did a quick test on my Loved Tracks playlist and the result seems to have turned out great! Thanks for the heads up :)
(...) with the additional option of sorting them by genre.
Wait, what do you mean by "sorting them by genre"? I have two mixes at the moment but I don't see anything related to genre. Could you elaborate on that?

Combo.fm is not back in working condition yet, right? Do you know if tburny is still interested in making an updated version?
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
I just did a quick test on my Loved Tracks playlist and the result seems to have turned out great!
It seems that the new similar playlists only contain up to 200 tracks from larger playlists like e.g. your converted Last.fm listening history, so that is a little drawback, but still a lot of new music to hear.

I have two mixes at the moment but I don't see anything related to genre. Could you elaborate on that?
I have five mixtapes on my "new" Samsung Galaxy SII smartphone, and they are roughly sorted by the genres classic rock, german rock music, baroque music, classical music, and soundtracks. This is pretty spot-on, but missing favorite genres would be female vocalists, prog rock and fusion. So I will not stop listening to Last.fm's Mix radio and/or my converted scrobbles directly in Spotify. ;-)

How many mixtapes you get and how they are classified depends on how diverse your music taste is and how much you have listened to Spotify in the last two weeks. See e.g. this interview with Matt Ogle on The Verge where he explains that they chose not to give names to the new playlists in the beta phase. Also interesting his tweet on launch day and the comments as well as other articles about the new feature e.g. on Musically or How To Geek.

Combo.fm is not back in working condition yet, right? Do you know if tburny is still interested in making an updated version?
Not yet, right, but Tobias is definitely still interested in adapting Combo.fm to Spotify and the new Last.fm site. But it would afford much backend work related to RQL, as far as I know.
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
You are right, the similar playlists seem to max out at around 190 tracks for me when the source is a huge list. But I'm not going to complain about that because for the foreseeable future I will only be listening to my Daily Mixes, NOTHING ELSE ;D they are that good. Matthew Ogle must be a freaking genius (assuming he's actually behind developing the "brains" of these features, but it seems he is).

Now that you mentioned it I can see that my mixes are each comprised of a broad genre as well, I had not realized that. But I think it's very smart that they decided against naming the mixes after the genre.
Right, I plan on doing my main music listening with Spotify as well for the next couple of weeks, to get more mixes to show up ;) too bad I'm having issues with the Last.fm radio again lately (god knows why, it was working flawlessly for months).

PS: congrats on the new smartphone! My Apple-fangirl-self will bite its tongue not to say anything about you choosing Android ;-P
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Right, having only two Daily Mixes would hurt my self-respect as well. ;-) I hope Matt's Twitter comments are true, so that they will be available in the desktop client soon, because having to use the smartphone to actually send them there is a bit too complicated. By the way, my sister gave me hers, because she bought a new one, but I think I would not have bought an iPhone myself anyhow, sorry. ;-)

My go-to solution when direct Spotify playback of the Last.fm Mix radio doesn't work is still playing the main "My library" folder in shuffle mode which contains all playlists in the meantime, also Discover Weekly and Release Radar and their IFTTT-archived versions as well as my manually created Followed Artists New Releases playlist, so it is always a fresh listening experience to me.
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
Right, having only two Daily Mixes would hurt my self-respect as well. ;-)
Gosh, thanks, that's EXACTLY what I wanted to hear.... I already feel like I'm a very very bad Spotify user with poor attendance and an F in "diverse taste" ;)

It probably won't be too long before the mixes find their way to the desktop, from the sound of the tweets, but if Spotify's slooooow rollouts from the past are an indication, half of the user base might wait years to get the feature...

My Spotify go-to for the last couple of months has been the Discover Weekly archive - I hardly ever listen to the original list while it's current, so that IFTTT recipe is worth its weight in gold (I think you recommended it, iirc - I owe you for that one ;D). And considering the size the archive has by now I still hear lots of stuff I don't know when I play it on shuffle. I hardly ever listen to my complete Last.fm history lists though - there's too much stuff in there that I don't want to hear on a regular basis. I guess your "put everything into one big folder"-strategy would have the same effect for me.

Do you enjoy the Release Radar lists? I've never tried those. I'm a Generation Xer, I'm suspicious of current music ;-P
Photo of Action Radar

Action Radar

  • 179 Posts
  • 97 Reply Likes
I have six daily mixes, but only two of them match my tastes. Maybe it's because I forget to close Spotify overnight, or I never use the thumbs-up button.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
IFTTT keeps changing the description and title of my recipe to archive Discover Weekly, but it is still used by many people. I wonder why Spotify does not offer an internal option to archive it, that request is one of the most asked questions on their community forums. Talking about slowly moving streaming sites, they have finally added the option to edit your playlist image and description for everyone, it is no longer just a test rollout for a few users.

I don't mind listening to my "old" scrobbles on Spotify (which this thread is about) from a playlist folder, because there is enough new or unknown stuff in it from the other playlists in the same folder. So in a way this is rather my Mix than my Library radio, and I don't have to worry about that 10k tracks limit in Spotify's "Your Music" library anymore. But it's true that the shuffle mode on mobile devices still seems to be broken compared to the desktop version, because I had some boring early repetitions lately when checking this method on my smartphone.

Release Radar is useful for me, but I would have preferred to keep the old feature of the notification bell in the desktop client, because that exclusively listed new releases from followed artists, nothing else like recent releases from recommended artists. That's why I also manually add them to a special playlist from my Spotify email notifications now. For some unknown reason Release Radar has the same issue as Discover Weekly of excluding classical music which is a rather important part of my music taste. So the Daily Mixes is the first new feature which doesn't ignore this part of me.
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
I have six daily mixes, but only two of them match my tastes.
Hm, that's weird! My daily mixes are so perfectly tailored to my taste and so spot on that it's almost scary... granted, I only have two atm ;) and I only play stuff on Spotify that I actually like, so I'm giving the algorithm a relatively small number of artists to work with. 
I don't mind listening to my "old" scrobbles on Spotify (which this thread is about) ...
I am delighted to see that we managed to stay on topic, somehow, kind of ;)

I got v.1.0.41 of the Spotify desktop client today and - lo and behold - they really added the option to upload a profile picture! After years and years and years of complaining over on the Spotify forum, that folks without a Facebook account simply cannot have profile pictures, they actually came through... yay! No more boring grey-head-person-avatars.

Re Release Radar: iirc, the notification bell always used to contain old stuff as well - sometimes decades old albums, that were just added to Spotify's catalogue. But from what I can tell my RR-playlist seems to only contain actual new/current music, 2016-releases. Is that how it works?
And yeah, it is definitely weird that classical music would be downright excluded from RR and Discover Weekly - that doesn't make any sense to me.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Changing profile pictures was a big deal for many Spotify users, but as I had my Facebook avatar, it was not that important for me. Being able to edit the playlist description is more useful, e.g. for the repertoire playlists of my bands. They are text-only and can only have max. 300 characters though, so clickable links are not possible.

It's true that the notifications listed everything new in the Spotify catalogue from your followed artists, no matter how old the albums actually were. I think the email notifications still work this way, and that is what I want to know. Release Radar lists re-releases of older albums now and then as well, but also recommendations of new releases from similar artists, and some people like that, others don't. I think there are so many ways of listening to your individual preferences for free on Spotify now including Last.fm's direct playback featire that I don't miss anything.
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
I think there are so many ways of listening to your individual preferences for free on Spotify now including Last.fm's direct playback featire that I don't miss anything.
Agreed! It's amazing how far we've come in the last 5 years, there is so much good recommendation stuff out there. Spotify has really nailed their last couple of features,  this must be related to the Echo Nest-purchase (Matt Ogle came to them from/with Echo Nest, right?). Apple Music has some neat stuff as well though, I still love the human-curated playlists and "My favorites Mix" is also very good (it's almost exactly like the Daily Mixes, but with 25 songs it's WAY shorter and there's just one for every user). 

I tried to make an IFTTT recipe like your Discover Weekly Archive-recipe, only for the Daily Mixes - but that doesn't seem to work, the Mixes simply don't show up (Songshift on the iPhone doesn't see them either) :-/ is there no way to automatically save them?
And speaking of IFTTT: I noticed that there are a lot of trigger errors in the log of the Discover Weekly Archive recipe. I can only see the last 100 entries and these are all from October, so I'm not sure if this has always been the case - do you have these errors as well? The recipe still works, so probably nothing to worry about, but it's pretty weird: on the 10th of October the recipe recorded errors from 4AM until 8AM - then it stopped and tried again 4 days later, on the 14th, from 6AM until 11:30AM on the next day, the 15th! On the 17th and 24th I see lots of errors in the early morning hours and then again in the afternoon. This is definitely weird!
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Matt Ogle came to them from/with Echo Nest, right?
Somehow, and somewhere in between he created This Is My Jam, see his LinkedIn profile or an interview in Musically from last March.

By the way, you can also vote for bringing Daily Mix to the desktop client on Spotify's community.

I'm not sure if it is possible to create IFTTT recipes on a mobile device and/or if they would maybe only work in the Spotify desktop client. I also have these many errors in the recipe log besides others like "Personal Recipe Triggered" several times in a row and "Action skipped", but the tracks get copied correctly each week, also for Release Radar and my other recipe creating my Last.fm weekly top album charts as an image on Twitter and Facebook, so I guess it's some issue with IFTTT and their servers maybe.
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Spotify is rolling out a new Daily Mix feature starting with mobile users, but desktop users will also have these new playlists or mixtapes soon.
The Daily Mixes have finally arrived in the desktop client (latest version was updated yesterday to v1.0.45 for me). You can find them directly under Your Music as a separate tab in the left hand sidebar. It seems that they are not available in the web player though.

I have six endless playlists now which are roughly sorted by genres, i.e. classic rock, classical music, german artists, swing music, female rock vocalists, blues rock. So the soundtrack genre is gone for now, maybe I should listen to more Howard Shore in the future. ;-)
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
Yay!!! Thanks for letting us know, Hans-Jürgen :)

Version 1.0.45 wasn't available for me in "About Spotify" yet, so I went ahead and downloaded the current version from the website - and to my surprise it actually was 1.0.45. When did Spotify start offering new versions on the website before the rollout is complete? I remember discussions about this very subject in the Spotify community from a while back - there was absolutely no way to get an update before it was pushed to you, iirc.

Anyway, great news, very happy the Daily Mixes have arrived on our desktops. The bad news though: I still only have two damned mixes - wth is up with that? Maybe I should listen to more Howard Shore... or anything really ;)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Yes, I also remember that discussion about getting updates of the desktop client in the Spotify community. I already saw my Daily Mixes in 1.0.44 for a short while, but then they disappeared again, so having Daily Mixes might not be directly connected to the desktop version, but rather to your account.

Anyway, these playlists really work great and can be a good alternative to Last.fm's Mix radio. I like that they play well-known artists from a genre, but with tracks I have not listened to much or not at all, so it often surprises me when hearing them. I wish I could share the playlists publically, but there is no option to do that, probably because they are endless and personalised. The "Favorite" and "Remove" buttons in the player is a nice additional feature, so you can influence the direction in which the playlist will develop.
(Edited)
Photo of somepixiessong

somepixiessong

  • 94 Posts
  • 65 Reply Likes
Agreed, the Daily Mixes are one of the greatest additions to Spotify's feature set ever. I love their equivalent of Pandora's thumbs up/thumbs down, but I hardly have to use the "Remove" button - the track choices are just too good :) 
I hadn't noticed that sharing those mixes isn't possible - I guess you'd have to work around that with the mobile app, by scrolling waaay down and adding all the tracks to a normal, shareable playlist. This doesn't seem to work on the desktop, as you can't load more tracks without listening to them... 

I still hope I'll get more than two mixes/genres eventually. As it stands now, I only have one Lo-Fi/Indie Mix and one - wait for it - Emo Mix... considering that Emo is nowhere near my top genres, I'm scratching my head as to what happened there.
Photo of voxvocis

voxvocis

  • 5 Posts
  • 0 Reply Likes
This is kind of random but do you know if this exports tracks that were tagged before the redesign but not scrobbled? Like, before you could tag tracks (without scrobbling) and they would be automatically added to your library. There was a ton of music that I did this with because I would listen to them in DJ sets or odd formats or whatever and didn't really have a way to scrobble them. From what I can tell, with the redesign, there's no real "add to library" without scrobbling so I'm wondering if current library is just scrobbles or what.
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2182 Posts
  • 1143 Reply Likes
That's right, your current library only lists your actual listening or scrobbling history, and the available tools to export it to a CSV file also only add your scrobbles, not the music you only have added to your library by tagging. See also this FAQ which mentions that it is still planned to bring those artists, albums and tracks back and make them visible again in your library.

You could export your personal tags on the old site though, so if you did that, you would have a CSV or XSPF file of it and could use that to convert it to a Spotify playlist.

Furthermore you can always manually add scrobbles (without actually listening to the tracks) to your library with the Universal Scrobbler or Last.fm Scrubbler which also offer bulk scrobbling methods from files, local media player or online databases.
(Edited)
Photo of voxvocis

voxvocis

  • 5 Posts
  • 0 Reply Likes
Ah ok thanks. In my usual style, I remember seeing that option back a year ago or so and kept putting it off until they closed the old site down. IIRC there was a way to do it through the old API but that was shut down too ofc. Tags were the main thing I used the site for and now it's just been nonfunctional for over a year and all those tracks are just gone til probably 2020 or something, it's all so depressing. Thanks so much for droppin the knowledge!
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2182 Posts
  • 1143 Reply Likes
As far as I know, the API still offers this request which should allow to get your personal tags from it:

http://www.last.fm/api/show/user.getPersonalTags

But you would have to know which tag you want, it does not give you an overview of all your tags. So maybe this one would help:

http://www.last.fm/api/show/user.getTopTags

Of course having to use the API for this is too complicated for the normal user, so the staff still wants to bring back an overview of your personal tags. 2020 might be a good estimation though. ;-)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
The new version 1.12 of the Windows desktop app Last.fm Scrubbler can also download your complete Last.fm listening history as a CSV file now. Furthermore it has added Paste Your Taste as a new extra feature which lists your top artists in a small text note to share it with others, e.g. on Reddit.
(Edited)
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
Two related Spotify updates: their mobile apps still show the created playlist folders, but there is no way to play them anymore since March 2017, see this community idea to bring that feature back.

A more positive one is the availability of their desktop client as a Windows 10 app in the Microsoft store now. It scrobbles and it also works with the direct playback from Last.fm, furthermore it looks exactly as their usual desktop client. So if you are still having problems with playing something from Last.fm with it you can try the new Windows 10 app as an alternative now. Don't forget to check its Preferences after an update, because it can happen that it forgets your Last.fm login details again besides other changed settings like automatic startup after reboot etc.

The Windows 10 app replaces the usual desktop client during the update, by the way, so you don't have to uninstall it separately. At the moment it does not work on Windows phones or the Xbox, but at least on the new MS Surface tablets with Windows 10 S version.
(Edited)
Photo of Joshua Finks

Joshua Finks

  • 50 Posts
  • 31 Reply Likes
Hey guys, finally making progress on my Android app in development. Be sure to check it out. It will allow mobile radio finally!
https://getsatisfaction.com/lastfm/topics/-app-last-fm-to-spotify-playlist-android
Photo of Hans-Jürgen

Hans-Jürgen, Moderator

  • 2208 Posts
  • 1155 Reply Likes
In the original posting I mentioned the textbox of Spotlistr as one of the available tools for creating Spotify playlists from your Last.fm listening history. The developer released a new version of his website, there are five other options to use with Last.fm via the API: Similar Tracks, Top Tracks Similar, Tag Top Tracks, Top Tracks For Time Period, and Loved Tracks.

 


More news from the relatively new online tool Tune My Music: They offer more Last.fm related options as well, see this screenshot:




Last but not least: Soundiiz added more Last.fm options and tutorial pages for them now including one related to Spotify:

https://soundiiz.com/lastfm

https://soundiiz.com/tutorial/lastfm-to-spotify



Note that most of the advanced features afford a Premium subscription on Soundiiz.
(Edited)
Photo of marvinjohn276

marvinjohn276

  • 1 Post
  • 0 Reply Likes
Thank you Joshua Finks . I hope that all is well now with your App.

Best of luck

Thomas
(Edited)
Photo of Joshua Finks

Joshua Finks

  • 50 Posts
  • 31 Reply Likes
My app was taken down by the Play Store. Apparently Spotify lawyers thought it was copyright infringement. I am no longer developing the app. Maybe some day, but it was a lot of effort to make considering the Spotify Android API was just about the worst thing ever. 
I'm glad it had a following, but I can't continue development until I get more reliable free time