First, I went to the playlist and copied all of the songs.
Then I pasted it into Excel
Each picture is a hyperlink, so I ran some code to extract it
Dim shp As Shape
For Each shp In Sheet1.Shapes
shp.TopLeftCell.Offset(0, 1).Value = shp.Hyperlink.Address
It writes the hyperlink address one cell over then deletes the shape.
To fix the blanks, I selected all of the blank cells in column B, entered =B5, and committed the formula with Control+Enter. That copied all of the cells above the blanks.
Next I sorted on Column A and deleted any row that wasn’t a song.
I split all the song information on spaces so I could extract the city name.
That was a bust, so I just typed the city and state next to each song. I deleted duplicates and the two songs that didn’t really contain city names.
I downloaded the spreadsheet template from batchgeo and pasted my data into it
It processed all of the entries and I got this map