You can get the app by searching for “Spotistats for Spotify” in your phone or tablet’s app store, or by visiting https://spotistats. app and tapping the link for Google Play or App Store. To see your listening time, you’ll need to request your listening data from Spotify, which can take up to 30 days (though it’s usually quicker than that).
Go to https://support. stats. fm/docs/import/streaming-history in a web browser. Click the green button that says Login with Spotify to fill in automatically, and click Allow when prompted. Click Copy to clipboard below the email template. Compose a new email message to support@spotify. com. For quick results, make sure to compose the message from the email address associated with your Spotify account. Paste the copied message into the body of the email and send the message. It can take several days to receive your information via email from Spotify. Technically, it can take up to 30 days, but it usually arrives within a week. [2] X Research source
You may have to give the app permission to open the Spotify login page to continue.
Once you’re signed in, you’ll need to tap AGREE to give the app permission to view your stats. If you don’t want to keep using the app in the future, you can go to https://spotify. com/account to remove the app’s access to your account.
Tap the gear icon at the top-right corner of Spotistats. Tap Algorithms, import & stream sync. Tap Disabled under “Sync stream history. Tap Enabled. Tap the back button to return to the Spotistats home page.
Tap the Stats icon (it’s the third icon at the bottom). Tap Get Spotistats Plus. Process the one-time payment through the App Store (iPhone/iPad) or Play Store (Android).
Once Spotify processes your request, they’ll send you an email message that contains a link to confirm. Click Confirm on the message, and then click CONFIRM on the resulting webpage to verify your request. The files you need include endsong. json in their titles, and they are inside of the ZIP file you downloaded. You can easily unzip the file on any platform, including Windows, macOS, or on your phone or tablet, to access all of your endsong. json files.
Once Spotify processes your request, they’ll send you an email message that contains a link to confirm. Click Confirm on the message, and then click CONFIRM on the resulting webpage to verify your request. The files you need include endsong. json in their titles, and they are inside of the ZIP file you downloaded. You can easily unzip the file on any platform, including Windows, macOS, or on your phone or tablet, to access all of your endsong. json files.
Go to https://stats. fm/import in a web browser. If prompted, log in to Spotify and/or click Agree to continue. Click Import a new file. Select and upload the first endsong. json file. Once the first upload completes, upload the next file(s). The files must be uploaded individually. Once uploaded Spotistats will process your data by filtering out duplicate streams and making calculations. This can take anywhere from a few minutes to a few hours, depending on how much you stream.
Unfortunately, you won’t be able to use Last. FM to track your listening time until after you’ve signed up and enabled scrobbling. This means your past listening time won’t be available. However, this is a super easy way to track your listening time going forward. You can set up Last. FM to scrobble your Spotify plays on a computer, phone, or tablet.
To disconnect Last. FM from Spotify at any time, hover your mouse cursor over your profile photo in Last. FM (or tap the menu if you’re using a phone or tablet), click Settings, select Applications, and click DISCONNECT.
You’ll need to check out your Wrapped data in December to get the listening data—if you try viewing Spotify Wrapped during another time of the year, you’ll only see playlists containing your top artists and songs.
You can tap or swipe through the presentation if you want to skip certain parts.
Go to https://www. spotify. com/ca-en/account/privacy in a browser. Scroll down and click Request. Spotify says the process can take up to 30 days, but our testers received their data in only 3 days.
If you’ve listened to fewer than 10,000 songs in the last year, you’ll only have one StreamingHistory file. If you’ve listened to more than that, you’ll have multiple files ending with numbers like 0, 1, and 2.
Go to https://csvjson. com/json2csv in your browser. Click Choose File and select your first StreamingHistory file (e. g. , StreamingHistory0. json. Click Convert. Click Download, choose your MyData folder as the location to save to, and save the file as StreamingHistory0. csv. If you have multiple files, you’ll need to convert all of them. Click Choose File again, select the next StreamingHistory file, then convert and download it. Name the next files StreamingHistory1. csv, StreamingHistory2. csv, etc.
Go to https://drive. google. com. Click + New. Click Google Sheets. At the top-left corner of the sheet, type Spotify Data as the file name.
Click File and select Import. Click the Upload tab and choose Select a file from your device. Select your first StreamingHistory CSV file (e. g. , StreamingHistory0. csv and click Open. Select Replace current sheet from the “Import Location” menu and click Import data. If you don’t have any more StreamingHistory CSVs to import, you’re done with this step. If you have another StreamingHistory CSV file to import, return to File > Import > Upload > Select a file from your device, select the second file, and click Open. Select Append to current sheet from the “Import location” menu and choose Import data. Continue appending additional StreamingHistory CSVs until you’ve added them all.
Continue appending additional StreamingHistory CSVs until you’ve added them all.
Continue appending additional StreamingHistory CSVs until you’ve added them all.
First, scroll back up to the top of the sheet. You’ll see that Row 1 contains the column headers “endTime,” “artistName,” “trackName,” and “msPlayed. " The problem here is that if you’ve appended additional data files, you have multiple rows like this when you should only have this one at the top of the sheet. Press Ctrl + F (PC) or Cmd + F (Mac) to open the “Find in Sheet” window. Type endTime. Click the down-arrow until you find a row in the middle of your data that contains endTime. Right-click the row number at the left side of the row and choose Delete row. If you appended more than one sheet, search for the next instance(s) of endTime and remove those as well.
Click cell E1 and type Language. Click cell E2, type =DETECTLANGUAGE(C2), and then press Enter or Return. Once you see a language (such as en) in E2, click the cell—you’ll see a blue square at its bottom-right corner. Double-click the blue square to apply the formula to the rest of the column.
The first time you do this, you might need to select your country, agree to the terms, and then click Continue. You’ll also have to choose some email preferences for Data Studio. If you don’t want to receive emails, just click No for each option and select Continue. After you do this, click the three dots again and choose Make a copy.
The first time you do this, you might need to select your country, agree to the terms, and then click Continue. You’ll also have to choose some email preferences for Data Studio. If you don’t want to receive emails, just click No for each option and select Continue. After you do this, click the three dots again and choose Make a copy.