Building a database of audio features

[ajaske]

Plan

Premium

Country

USA

Device

Desktop

Operating System

Windows 10

My Question or Issue

I am trying to build a database of the features of the top Billboard songs over time. I can pull the data for one or a few tracks, but it requires several steps.
1. Find the track on Spotify
2. Go to share and click Ctrl to get to Copy Spotify URL
3. Paste Spotify URL in Get Audio Features screen and the cut the Spotify Track portion at the beginning
4. Do this for a lot of tracks - then run and get a screen print
5. Cut and paste the screen print into something else - Excel for now - clean up using text to data and then do a Paste Values Transpose to get data where I want
It's really the beginning of this process that is painful. Is there anyway to access a whole bunch of Spotify tracks in a database format without going to every single track via search?

[serkansulun3]

I would automate everything with a Python script. The "Spotipy" library would allow that.

[ajaske]

Very new to this so did not know about Spotipy. Looks like a great resource. Will try that. Thanks!