I've Created a FREE CSV Playlist Import Tool

Reply

I've Created a FREE CSV Playlist Import Tool

nick_wanders
Regular

http://nickwanders.com/projects/ng-spotify-importer/

 

Its my first attempt at both Angular and using Spotify's APIs. So its probably buggy. It also desperately needs UI / UX work. A link is provided to my public GitHub repo if you'd like to contribute, or even log bugs 🙂

 

I've tested the tool with 250+ songs and its able to import them in roughly 30 seconds. I suspect it will work with larger playlists. However, I'm not entirely sure what will happen since most processing is done in memory (in the browser). Also, I've only used Chrome, so please let me know how it runs on other browsers.

 

Last but not least, the tool requires that you grant it the ability to modify / create public playlists for your account ("playlist-modify-public" scope, for the techie folk).

 

Enjoy and ride those electro waves!

15 Replies

Boogie_Harrison
Visitor
Hi!

I'm getting the "ERROR: Invalid CSV playlist". I've tried different exporting options to CSV or TXT, both in Google Spreadsheets and Excel and I can't make it work. I'm exporting two columns (A: Title, B: Artist).

What's wrong? Am I missing something? 

AdamDobay
Casual Listener
Hi Boogie,

I had the same thing at first.

So I deleted all other columns and the extraneous first row so TITLE and
ARTIST were the name of columns A and B respectively, with no other column.

This solved it for me, I hope it does for you too!

Adam

AdamDobay
Casual Listener

This is amazing, Nick!

I've recently lost my Shazam playlist after following a guide on how to reset a stuck Shazam playlist that was no longer refreshing (spoiler alert: it just ended up deleting my database of Shazamed songs).

All I found online was paid playlist converters so I was super happy to find your script, which identified 1046 of the 1314 songs from my Shazam export and now I have that playlist back almost in full.

Thanks so much for creating this, you made my day!

Adam

haudankaivajasi
Visitor
Nice job! Is this possible to be ran on docker and host it myself? I'm trying to create an automatic sequence to sync my Plex playlist to Spotify and running it on my own server would make everything so much simpler.

nick_wanders
Regular
Should be doable, its an Angular + Typescript project with no server-side components.

Source code is available here:
https://github.com/NBS-LLC/ng-spotify-importer

Have fun 🙂

G8351427
Newbie

Hey man, this is bad ass.

 

I thought I was pretty scre*ed when GPM finally went offline. I managed to grab my data and put together a script to merge Google's ridiculous CSV format into a single file per playlist, but I couldn't do anything with it because none of the services out there supported any kind of local file import. I waited too long to work on this problem and it was too late to use the transfer tool I had.

 

I was basically scre*ed till I came across your tool. I managed to import 700+ songs and only 100 of them failed due to weirdo naming formats and unusual characters, but the way you have an option to change the search parameters in a popup and refine the query, *and* hear a preview is awesome.

 

I think I got my whole favs playlist sorted thanks to your tool.

 

I owe you a beer.

dangum
Casual Listener

I sadly copied and pasted a list of 7k songs off the internet and it didn't work at all. I made some fixes to the format so I thought I would share it. 

 

so if you find yourself nin a bind make sure the following are being met. 

 

1. You have named two top cells title and artist

2. remove accent marks -unless you know macro there is no easy way to do it just find and replace. (Excel doesn't save CSV files without them unfortunately) - these are "(á, é, í, ó, ú, ü, ñ ..." - band names like motley crue have them in there. 

2a. Fina and replace with nothing. make sure there are no punctuation marks, like ! or . or ' or anything like that. 

3. there are no trail spaces in the title or artist (The space after the last letter), if you find yourself with them - run this code =TRIM(SUBSTITUTE(*CELL*,CHAR(160),CHAR(32))) - *CELL* i.e B3 or A2 is the target cell. This removes the trailing space that is formed when coping and pasting from a table on the net.

 

if it still says invalid, start with testing line by line, you will soon see what it likes or doesn't like. 

 

Once its loaded, it wont find any artists that have 'featuring' or 'and' or 'ft'... so you have to remove everything including and after those works- excel has some excellent formulas for this back on your s/sheet.  (Sorry if you are a hip hop fan)

try this: and put the words inside the " " marks

=LEFT(A1,FIND(" ",A1)-1)

 

*disclaimer you will have to rin the trail space formula again after you are done. 

 

 

 

 

nick_wanders
Regular

Dangum, nice job working around some of the limitations of the tool I wrote 🙂

 

When I find some time I'll see if I can incorporate your workarounds into the tool. Just be aware that my free time is now limited, hence me taking 3 weeks to respond.

shwonline
Casual Listener
Nice. I just did a test using a Billboard Top 100 list. Had to adjust maybe a dozen titles or artists, but it was WAY easier than doing it manually.

dangum
Casual Listener

Hi I've tried to upload a list but it seems to just not like some of the language in it. I tested it with some artists and it would let the csv import only if some of the artist was deleted etc.  Although the idea is awesome, there seems to be a mystery as to what it likes and doesn't like. Could you please shed some light on that? 

 

Cheers 🙂 

nick_wanders
Regular
Another update 🙂

Now when you grant access to your Spotify account (again only to create / modify public playlists) the tool will refresh its access in the background. Effectively allowing you to import and modify playlists for as long as you like. The previous version would time out after 1 hour. This is helpful for those that have numerous playlists, or those that need to make time consuming adjustments prior to importing.

The update does require that you to grant access to Spotify each time you load the tool.

Let me know what you think.

nick_wanders
Regular

I've updated the tool to include a "more" button. When clicked a dialog will appear allowing you to search for related songs. Clicking a related song replaces it in the displayed playlist. The import process will then use the related song.

 

This helps resolve unknown or mismatched songs.

 

Enjoy 🙂

rhrahulhaldar
Composer

Hey nick_wanders,

 

 

Awesome Work.. Nailed It.. 

 

 

Regards,

 

 

Rahul Haldar - Diehard & Loyal Fan Of Music & Spotify

nick_wanders
Regular
Thanks for the support 🙂
Be on the lookout for updates to the tool!

rhrahulhaldar
Composer
Hi nick_wanders ,


Sure Mate.. I Will.. And You Are Always Welcome..


Regards,


Rahul Haldar - Diehard & Loyal Fan Of Spotify
SUGGESTED POSTS