
Choose Replace current sheet, and hit the Import data button. Choose Upload, and select the first of your StreamingHistory CSV files that you just obtained using the conversion site named csvjson.csv. In the newly created Sheets document, navigate to the File menu, and hit Import.Head over to and create a new Google Sheets document using the New button on the top left.Now, you should have all your StreamingHistory files as CSV files in your Downloads folder. Repeat this process for all the files starting with StreamingHistory. Once it’s uploaded (100%), click the Convert button, and then the Download button. Simply head over to /json2csv and click Select a file on the left, navigate to your MyData folder, and select the first file starting with StreamingHistory. 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.


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.
