Spotify Streaming History to CSV & Excel

Your Spotify data comes as JSON files. Turn them into a CSV with every play, or an Excel workbook with top lists and yearly totals.

Drop your Spotify data here my_spotify_data.zip — or the Streaming_History_Audio_… .json files inside it · analysed on your device, never uploaded

a made-up Spotify download — made up, nothing of yours

Step 1: request your Spotify data (do it now — it takes days)

  1. On a computer, go to spotify.com, log in and open Account → Account privacy (Privacy settings).
  2. 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.)
  3. Click Request data and confirm the email Spotify sends you.
  4. 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.
  5. Drop that zip onto the box above. Done.

Step 2: convert to CSV or Excel

  1. Drop my_spotify_data.zip (or the Streaming_History_Audio_…json files) on the box above.
  2. Choose All time or a year under Period.
  3. Click CSV for every play as a row, or Excel for a workbook.

What is in the files

CSV columnFrom Spotify's field
Time (UTC)ts — when the play ended
Minutes playedms_played
Track, Artist, Albummaster_metadata_track_name, …album_artist_name, …album_album_name
Podcast, Episodeepisode_show_name, episode_name
Skipped, Platformskipped, 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.

Runs entirely in your browser, powered by a Spotify streaming-history analyser built for this site. Built and tested by Diego Callegari · how we test · updated 19 October 2026.