Reader Casey wanted to make a Spotify playlist based on Billboard's Top 100 Singles of 1993, but didn't want to go through the legwork of finding and adding 100 different songs to a playlist. After a bit of searching Casey's solution was to work a little spreadsheet magic.
Here's how Reader Casey build Spotify playlists from any Wikipedia song List:
*Copy the desired Wikipedia table.
*Paste into an Excel worksheet.
*Remove the Track Number Column, if it copied over.
*Move the Artist Column to the left of the Song Column.
*Do a "Find and Replace"on the Song Column and remove the quotation marks.
*Insert a Row and title the columns "Artist" and "Title"respectively.
*Select the cells and remove the hyperlinks.
*Save as a Tab Delimited Text file.
*In the text file,do a hard return on each line, then re-save it.
Founded in 2010, the industry website, Crowdsourcing.org, is a neutral organization dedicated solely
to crowdsourcing and crowdfunding. As one of the most influential and credible authorities in the crowdsourcing space,
Crowdsourcing.org is recognized worldwide for its intellectual capital, crowdsourcing and crowdfunding
practice expertise and unbiased thought leadership.