Stella
Chats and data exports

See your Spotify listening history, all time

Years of plays from a Spotify data download as top 10s by time and hours per year.

Download StellaFree with the plan you already have.

A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 40 s in real time.

The short answer.

Request Extended streaming history from Spotify's account privacy page. It can take up to 30 days, and arrives as JSON files with one entry per play: when, what, and how many milliseconds you listened. Add up the time per artist and per song across every file, leaving podcasts out, and divide by 3,600,000 for hours. Stella (stella.sh) does that from the zip on your computer and saves the results, ranked by time listened rather than play count.

Stella does this on Windows, Mac and Linux.

What happened.

About 2 minutes. Checked afterwards against an answer key written before the run: the top 10 artists by time in the right order with no podcast among them, the top 10 songs by time in the right order (not by play count, same-name songs kept apart), and hours listened right for each year from 2023 to 2026.

The artists, songs and podcasts are made up, written in the format Spotify documents for its extended history. The work is sped up 9×.

How Stella does it.

  1. Opens my_spotify_data.zip in Downloads and reads all three streaming history files, 18,131 plays from March 2023 to October 2026
  2. Adds up time listened per artist and per song, keeping podcast episodes out of both top 10s
  3. Ranks by time, so a song played thousands of times but skipped after seconds doesn't top the list
  4. Keeps two different songs with the same title by different artists apart
  5. Works out hours per year, all listening and music only, and saves spotify_listening_stats.md next to the zip

The prompt.

I got my full listening history from Spotify, it's the zip in my Downloads. What are my top 10 artists and top 10 songs of all time by time listened, and how many hours did I listen each year? Save it as a file.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  1. Request the extended history

    Sign in at spotify.com, open your account, then Account privacy. Tick Extended streaming history (the basic Account data only covers the last year) and confirm the email. Spotify says it can take up to 30 days.

  2. Load the files into Excel

    Unzip the download. In Excel, Data, Get Data, From File, From Folder, pick the extended history folder and combine the Streaming_History_Audio JSON files. Each row is one play.

  3. Leave podcasts out

    Filter out rows where master_metadata_album_artist_name is empty: those are podcast episodes and audiobooks, which have their own episode fields.

  4. Group by artist and by song

    Use Group By on the artist column with Sum of ms_played, then again on artist plus master_metadata_track_name together, so same-name songs by different artists stay apart. Divide by 3,600,000 for hours and sort.

  5. Hours per year

    Add a column with the year from ts (the time the play ended, in UTC) and sum ms_played per year.

Where it stops.

  • Spotify Wrapped uses its own rules and dates, so these all-time numbers won't match a Wrapped exactly.
  • Times in the history are in UTC, so a play just after midnight can land in the neighbouring day or year.
  • You request the history from Spotify yourself and it can take weeks; Stella doesn't log in to your account.
  • The play history goes to the AI model you use in Stella while it adds up the numbers.
  • Recorded on Linux, where Stella used Python, built in on Mac and Linux. On Windows it may install Python first, which wasn't recorded.

Questions.

How do I see my Spotify listening history from all time?

The app shows only recent plays. For everything since you joined, request Extended streaming history from your account's privacy page and wait for the email.

What's the difference between Account data and Extended streaming history?

Account data covers about the last year with less detail. Extended streaming history goes back to when you started, with one entry per play including how long you listened.

Why rank by time instead of plays?

Skips count as plays. A song you skip every day after three seconds can have more plays than your real favourite. Time listened shows what you actually played.

What else can I get from my data downloads?
Is Stella free for this?

Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

Can I control what Stella changes on my computer?

Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Checked against these sources on 14 November 2026.

Stella