Convert a Spotify export zip to a SQLite database
Install this library using pip
:
$ pip install spotify-to-sqlite
Convert a Spotify export zip to a SQLite database
spotify-to-sqlite convert my_spotify_data.zip spotify.db
You can use Spotify's Web API to retrieve audio features tracks in your streaming_history
and your_library_tracks
tables.
You will need a CLIENT_ID
and a CLIENT_SECRET
which you can get when you register an application the Spotify Developer's site. You can export those as SPOTIPY_CLIENT_ID
and SPOTIPY_CLIENT_SECRET
(notice it's SPOTIPY not SPOTIFY).
You can also save those on a .env
file on your working directory as such:
# .env example
SPOTIPY_CLIENT_ID=adfgahjklsdf73932bcdlavsd7892dgfasd
SPOTIPY_CLIENT_SECRET=dabjgsd77507davsd12344dhgvafsdl
# when your converting export
spotify-to-sqlite --audio-features my_spotify_data.zip spotify.db
# if you already had converted your export you can pass a "-"
spotify-to-sqlite --audio-features - spotify.db
To contribute to this library, first checkout the code. Then create a new virtual environment:
cd spotify-to-sqlite
python -m venv venv
source venv/bin/activate
Or if you are using pipenv
:
pipenv shell
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests:
pytest