Summary
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.

Description
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.

*Browse to SpotMySongs and upload the TXT file.