Skip to Content
Export FilesYour Export File

Your export file

Trackify Plus lets you download everything Trackify has recorded about your listening, from Settings → Listening history → Download your listening on the new Trackify. This page explains what is in the CSV and JSON files. The Excel workbook, the same listening as charts and rankings, is described in Your listening workbook.

The file holds your own listening and the public Spotify details needed to read it: names, ids, links and cover art. Nothing about other people, and nothing Trackify works out for itself (popularity, genres, recommendations).

Choosing a file

You make two choices before downloading.

ChoiceOptions
FormatExcel workbook is your listening already worked out: totals, rankings, charts and a calendar, ready to open. It has its own page. CSV is a spreadsheet of your listens, for Excel, Numbers or Google Sheets. JSON is for code and data tools.
Layout (CSV and JSON)One file: one row per listen, with the track, artists and album written into every row. Linked tables: your listens refer to tracks by id, and each track, album and artist is listed once. Much smaller, and nothing is repeated.

The rest of this page is about the CSV and JSON files. CSV defaults to one file, JSON to linked tables. A CSV with linked tables downloads as a .zip with one CSV per table.

You can also limit the file to a range of days (in your own time zone, both days included), and include skips. By default the file holds your plays only. With skips included, every listen Trackify has is there, and each one says whether it counted as a play.

You can download up to 10 exports a day, one at a time.

Listens

Every listen in the file, oldest first. A field Trackify doesn't know for a listen is left out (JSON) or left empty (CSV).

FieldWhat it is
ended_atWhen the listen ended, in UTC (ISO 8601, e.g. 2024-06-01T09:12:03.512Z).
started_atWhen it started, in UTC. Only for listens from your Spotify data files, which record how long you listened.
ms_playedHow long you listened, in milliseconds. For synced listens it is usually the track's length: Spotify mostly tells Trackify that a track was played, not for how long.
is_playWhether the listen counted as a play (you heard at least 80% of the track). Only included when you include skips.
track / track_idThe Spotify id of the track as you played it. Open it at https://open.spotify.com/track/<id>.
sourcesync: Trackify saw it while connected to your Spotify account. import: it came from Spotify data files you uploaded.
context / context_uriWhat you played it from, as a Spotify uri: a playlist (spotify:playlist:…), album or artist. Synced listens only; Spotify's files don't record it.
platformThe device type, as Spotify recorded it (imported listens only).
shuffle, skipped, offline, incognitotrue or false, as Spotify recorded them (imported listens only).
reason_start, reason_endWhy the track started and ended, in Spotify's words (trackdone, fwdbtn, clickrow, …). Imported listens only.

The one file layout adds, on every row:

FieldWhat it is
track_name, duration_ms, track_urlThe track's name, length and Spotify link.
artist_ids, artist_namesEveryone credited, main artist first. In a CSV several are separated by ; (names can contain commas). In JSON, artists is a list of {id, name}.
album_id, album_name, album_image_urlThe track's album and its cover. In JSON these are inside album.
context_nameThe playlist, album or artist name, when Trackify knows it.
local_date, local_timeWhen the listen ended, in your time zone (CSV only).

Tracks, albums, artists and contexts

In the linked tables layout these are listed once each, keyed by Spotify id (contexts by uri). Every id a listen mentions has an entry.

Tracks: name, duration_ms, explicit, isrc (the recording's international code, useful for finding it on other services), album, disc_number, track_number, artists (ids, main artist first) and url. A track Spotify never gave Trackify details for has an entry with no name.

Albums: name, album_type (album, single or compilation), release_date, total_tracks, artists, image_url (the cover) and url.

Artists: name, image_url and url. An artist Trackify only knows from a track's credits has a name but no image.

Contexts: type (playlist, album, artist), name, owner (for playlists) and url.

In the zip, the credits are in their own files: track_artists.csv and album_artists.csv, with a position column (1 is the main artist).

Images and links are Spotify's. Spotify can change or remove an image, so a cover link that works today may not work years from now.

The JSON file

With linked tables, the JSON file is one object:

{ "about": {"kind": "trackify_listening_export", "version": 2, "exported_at": "…", "time_zone": "Europe/London", "listens": "plays", "from": null, "to": null, "format_guide": "…"}, "listens": [ {"ended_at": "2020-03-12T15:41:54Z", "ms_played": 225986, "track": "2pHClPIG7C5v9Qhd1LHS2y", "source": "sync"} ], "tracks": {"2pHClPIG7C5v9Qhd1LHS2y": {"name": "As Long As You're Mine", "album": "2mliDr6sxkiwblGq6yZHHQ", "artists": ["…"], "url": "…"}}, "albums": {"2mliDr6sxkiwblGq6yZHHQ": {"name": "Defying Gravity: Songs from Wicked", "image_url": "…", "url": "…"}}, "artists": {"…": {"name": "Idina Menzel", "image_url": "…", "url": "…"}}, "contexts": {}, "totals": {"listens": 1, "tracks": 1, "albums": 1, "artists": 4, "contexts": 0} }

Each listen, track, album and artist is on its own line, so the file is readable in a text editor. With one file, the JSON is a list of listens, each with its track, artists and album written in.

Opening it

  • Charts and rankings without any work: download the Excel workbook instead.
  • One spreadsheet: open the .csv in Google Sheets (File → Import) or Excel. Large histories can pass a million rows, which is more than Excel shows; use a date range to split them.
  • Linked tables: unzip the file. listens.csv points at tracks.csv by track_id, tracks.csv at albums.csv by album_id, and the credit files join tracks and albums to artists.csv.
  • In Python, for example:
import json data = json.load(open("trackify-export.json")) for listen in data["listens"][:5]: track = data["tracks"][listen["track"]] artist = data["artists"][track["artists"][0]]["name"] if track["artists"] else None print(listen["ended_at"], track["name"], "by", artist)

This page describes the export from the new Trackify. The download on the current trackify.am still uses the older file described in the Export Guide.

Last updated on