I was on last.fm the other day and I noticed a few songs missing from my scrobbles that I knew I’d listened to. I want to manually add them in by uploading my listening history so I requested and downloaded a copy of my data but it came as an Excel spreadsheet and all the guides I can find are catered for Spotify or Apple Music users with JSON coded files. I also have no clue how to navigate the Excel sheet itself as I can’t figure out how to order the column chronologically.
Best answer by bluezzbastardzz
You should only highlight the Date column, not all columns and then sort it “alphabetically” (using the yyyy-mm-dd date format) up- or downwards.
But if you only miss a few scrobbles, maybe this is way too much work, as even if you succeed in importing all your scrobbles, they will get the current date of import, not the original date and kind of ruin your Last.fm library or at least your listening reports then. You could also use a manual scrobbling tool to add the missing ones perhaps, especially if you know why they haven’t been submitted as expected, e.g. due to missing ampersands or using equals or plus signs somewhere. But these manual scrobblers also have to obey the Last.fm rules about a maximum age of 14 days for imported scrobbles, so they would also change it to the current day of import.
+8You should only highlight the Date column, not all columns and then sort it “alphabetically” (using the yyyy-mm-dd date format) up- or downwards.
But if you only miss a few scrobbles, maybe this is way too much work, as even if you succeed in importing all your scrobbles, they will get the current date of import, not the original date and kind of ruin your Last.fm library or at least your listening reports then. You could also use a manual scrobbling tool to add the missing ones perhaps, especially if you know why they haven’t been submitted as expected, e.g. due to missing ampersands or using equals or plus signs somewhere. But these manual scrobblers also have to obey the Last.fm rules about a maximum age of 14 days for imported scrobbles, so they would also change it to the current day of import.
Ah okay thank you, it was only a handful that I missed the other day so I’ll just manually log them instead but that is a little annoying about the date. I think they didn’t go through because I had dodgy connection. Thanks for explaining how to organise the date thing too.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
