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.
| Choice | Options |
|---|---|
| Format | Excel 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).
| Field | What it is |
|---|---|
ended_at | When the listen ended, in UTC (ISO 8601, e.g. 2024-06-01T09:12:03.512Z). |
started_at | When it started, in UTC. Only for listens from your Spotify data files, which record how long you listened. |
ms_played | How 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_play | Whether the listen counted as a play (you heard at least 80% of the track). Only included when you include skips. |
track / track_id | The Spotify id of the track as you played it. Open it at https://open.spotify.com/track/<id>. |
source | sync: Trackify saw it while connected to your Spotify account. import: it came from Spotify data files you uploaded. |
context / context_uri | What 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. |
platform | The device type, as Spotify recorded it (imported listens only). |
shuffle, skipped, offline, incognito | true or false, as Spotify recorded them (imported listens only). |
reason_start, reason_end | Why the track started and ended, in Spotify's words (trackdone, fwdbtn, clickrow, …). Imported listens only. |
The one file layout adds, on every row:
| Field | What it is |
|---|---|
track_name, duration_ms, track_url | The track's name, length and Spotify link. |
artist_ids, artist_names | Everyone 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_url | The track's album and its cover. In JSON these are inside album. |
context_name | The playlist, album or artist name, when Trackify knows it. |
local_date, local_time | When 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
.csvin 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.csvpoints attracks.csvbytrack_id,tracks.csvatalbums.csvbyalbum_id, and the credit files join tracks and albums toartists.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.