We have to convert each of the files starting with StreamingHistory from a JSON file to a CSV file, to make it ready to be imported into a Google Sheet document.If you’ve got more than one of these files, it means you’ve listened to more than 10,000 songs over the past year, as Spotify splits your listening history per 10,000 plays across files. In the folder, identify all the files starting with StreamingHistory.We’re going to put it in a Google Sheet, so that we can prepare the data a little bit first. For Google Data Studio to be able to read our data, it must be in either in a CSV file or a Google Sheet.A new folder will appear, containing the data files.Unzip the downloaded zip file called my_spotify_data.zip, simply by double-clicking on it.Once you’ve received the email, download your data, and make sure to return to this article to follow the next steps.This won’t be a large file, as it mainly contains textual data. Now, it’s just a matter of waiting a few days to receive an email from Spotify with a link to download your personal data.Scroll down to Download your data and click the Request button below Step 1.Now navigate to Privacy settings using the menu on the left side.Simply go to, log in, hit the top right Profile menu, and then hit Account. Spotify allows you to get a copy of one year of personal data.

So, without further ado, let’s go through the step-by-step process. That might still sound a bit overwhelming, but rest assured, no technical understanding is required - we even have a ready-to-use template for you to make it look badass. Now, what if you don’t want to wait till December to get a new, up-to-date, summary of your listening behavior? Well, look not further… we’ve got you covered! With Spotify’s option to export your personal data, and Google’s free, easy-to-use tool to visualize data called Google Data Studio, we’re going to show you just how to do that. In fact, it was considered so wildly amusing that you couldn’t open Instagram without having to go through a bunch of stories of people’s personal Wrapped.

Watching popular styles and our tastes change over time was both confronting, and amusing. Just before the 2010s ended, Spotify released “Spotify Wrapped”, a visual overview of our personal, changing music listening habits over the past millennium.

How to get spotify stats