Step 1: request your Spotify data (do it now — it takes days)
- On a computer, go to spotify.com, log in and open Account → Account privacy (Privacy settings).
- Under Download your data, tick Extended streaming history — that is the one with every play since you created your account. (Account data only has the last year.)
- Click Request data and confirm the email Spotify sends you.
- Spotify says it can take up to 30 days; it often arrives sooner. You get an email with a link to
my_spotify_data.zip. - Drop that zip onto the box above. Done.
Step 2: convert to CSV or Excel
- Drop
my_spotify_data.zip(or theStreaming_History_Audio_…jsonfiles) on the box above. - Choose All time or a year under Period.
- Click CSV for every play as a row, or Excel for a workbook.
What is in the files
| CSV column | From Spotify's field |
|---|---|
| Time (UTC) | ts — when the play ended |
| Minutes played | ms_played |
| Track, Artist, Album | master_metadata_track_name, …album_artist_name, …album_album_name |
| Podcast, Episode | episode_show_name, episode_name |
| Skipped, Platform | skipped, platform |
The Excel workbook adds sheets with a summary, top 50 artists, songs, albums and podcasts, hours per year and all plays (up to 300,000 rows; use CSV for more). Both open in Excel, Google Sheets and Numbers.
Why not open the JSON directly?
The extended history is split into several JSON files of about 12 MB each, with 20 fields per play. Excel can't open JSON directly, and online JSON-to-CSV converters handle one file at a time and need you to upload your listening history. Here all files are combined, cleaned up and converted in one go, on your own device.
Just want to see the results? The dashboard above shows them right away — see also Spotify all-time stats.
Private by design
Your listening history is analysed in your browser. Nothing is uploaded, there is no login, and we never connect to your Spotify account — so there is nothing to revoke afterwards.
Free Forever Converter is not affiliated with Spotify. Spotify and Spotify Wrapped are trademarks of Spotify AB.
Frequently asked questions
How do I open Spotify streaming history in Excel?
Drop the zip or JSON files here and click Excel; you get a workbook with top lists, yearly totals and every play.
Can I combine all Streaming_History_Audio files?
Yes. Drop the zip or all JSON files at once; they are combined and duplicates are removed.
What time zone are the timestamps?
UTC, as in Spotify’s data. The hour-of-day chart uses your own time zone.
How long does it take to get my Spotify data?
Spotify says up to 30 days for the extended streaming history; it often arrives within a few days. Request it early.
Is my Spotify data uploaded?
No. The zip is read in your browser and never leaves your device. No login and no connection to your Spotify account.
Does it include podcasts?
Yes. Podcast episodes are counted separately, with a top list of shows.