Click the field and paste (ctrl+v) the list. Next, open the following url in your browser: and click on "import your playlist now", go to the copy+paste section. Now select the first track name at the top left, scroll all the way down to the last artist names and shift-click that name. Now you have your data in Excel you need switch the order (tracks and then artists) to artists first, before copying. After that you have all your tracks information in front of you, make sure you see the three columns.
While importing tell the application that the data is deliminated (split) by a tab (make sure that any option for comma is not selected) and click import.
Open your spreadsheet application of choice and import the data in the file (usually something like "Data" and then "Import"). The file will contain one column with the track name, one with the artist and one with the Last.fm-URL for that track. Make sure that you're importing the data as UTF-8 otherwise artist and track names get maimed when they have characters like ë, é or ô.
#Spotify playlist export to excel free#
The export takes some time (tested it on a list with 7455 tracks) but after that you have your list in a format that can be read by Calc (part of the free OpenOffice-suite) or in Excel. The strange thing is that after I had disabled ABP both sites could only "see" the first 700 tracks from large lists.Ī better solution for long lists is to not export the list in Last.fm as a xspf-file but to choose for TSV as the format in the drop-down menu (it's right underneath where it says XSPF). It turned out that because I had enabled AdBlockPlus both sites somehow couldn't trigger the export from Last.fm. So far anything under a thousand tracks on Last.fm gives good results, but when I tried a user with 5064 tracks loved and another with 7455 both came back as either not a valid username or zero results. There is an option to turn this off.īoth services have a problem with searching for tracks if the number of loved-tracks is fairly large. The downside of using Playlistify however is that they have sound effects while searching that are really annoying if you're listening to music.
#Spotify playlist export to excel download#
Playlistify also has an option for adding the url of an xspf-file but no option to upload one, not that handy since you can only download the file from Last.fm but not link to it. I've tested both sites to see what results they give and it turned out that Playlistify gave more results back than Spotibot (20 tracks more of my Loved-list). Playlistify has had some outages but normally they're really stable. These two sites offer an easy way of finding loved tracks based on giving them a username. Standard tools for exporting Loved Tracks 5 iTunes (Mac) - import a XSPF playlist.1 Standard tools for exporting Loved Tracks.
0 kommentar(er)
