Setup Guide

Three ways to get your listening history in. Pick the one you started with and follow it end to end.

What you'll need

A Google account
A Last.fm account with some listening history
A free Last.fm API key — last.fm/api/account/create

Copy the template sheet

Open the template and click Make a copy. It lands in your own Drive — private to you.

Open the template →
Fill in your details

In your copy, open the Settings tab at the bottom and fill in column B.

Column AColumn B — fill these in

Last.fm Username: your_lastfm_username

Last.fm API Key: your_32_character_api_key

Data Tab Name: leave as-is

No API key yet?

Get one free in about two minutes at last.fm/api/account/create. The application name can be anything.
The script is already there
It came with the template — nothing to add. To see it:

Extensions Apps Script

Close that tab and carry on.
Replace the script manually
Paste this into Extensions → Apps Script, replacing everything there. Save with Ctrl+S, then redeploy if you set up a Web App in Step 6.
Start auto-sync

Back in your sheet, a Last.fm menu now sits next to Help.

Last.fm Start Auto-Update (90 min)

New plays arrive every 90 minutes from now on. Want them immediately? Last.fm → Fetch Latest Tracks.

"This app isn't verified"? Normal for personal scripts. Click Advanced → Go to [app name] (unsafe) → Allow. The script only touches your own sheet.

Why 90 minutes?

Some services — Deezer especially — lag before their scrobbles reach Last.fm. A wider window means nothing gets missed.
Connect it to dankcharts.fm

Settings ⚙ Google Sheets paste your sheet URL

Share the sheet first, or the site can't read it: Share → Anyone with the link → Viewer.
Add plays by hand Optional

Only needed for the + Add Play button. Deploy the script as a Web App:

Extensions Apps Script Deploy New deployment

SettingValue

TypeWeb app

Execute asMe

Who has accessAnyone

Hit Deploy, authorise it the same way as in Step 4, and copy the Web App URL. Then paste it into:

Settings ⚙ Enable auto-sync & manual play entry

Troubleshooting

The Last.fm menu doesn't appear in my sheet.

Close and reopen the sheet. The onOpen function runs when the sheet loads — if you had the sheet open right after making your copy, just refresh the page.

No data is being imported.

Check that your Last.fm username (B1) and API key (B2) in the Settings tab are correct and have no extra spaces. You can test by clicking Last.fm → Fetch Latest Tracks and then going to View → Logs in the Apps Script editor.

The site shows "No Google Sheet configured".

Make sure you've pasted the sheet URL in dankcharts.fm Settings and that the sheet is shared as "Anyone with the link can view".

Manual entry gives an error.

The Web App URL must be redeployed after any script change. In Apps Script: Deploy → Manage deployments → edit the existing deployment → Deploy.

Need help?

Can't get it working? Open a support ticket and we'll get back to you.

or email support@dankcharts.fm

What you'll need

A Last.fm account
A free Last.fm API key & shared secret — last.fm/api/account/create
dankcharts.fm loaded with your listening history — either from this guide's API connection, or by uploading a CSV from ghan.nl's Last.fm exporter (see the Upload a File guide)

Create a Last.fm API app

Fill in the form at last.fm/api/account/create — the values can be anything.

FieldWhat to enter

Application nameMy Music Charts

DescriptionPersonal use

Homepagehttps://dankcharts.fm

Callback URLhttps://dankcharts.fm

Copy the API Key and Shared Secret it gives you. Free, instant, no approval.
Paste them into dankcharts.fm

Settings ⚙ Last.fm Scrobble Setup Use custom API credentials

Both fields are required. The Shared Secret signs every request — without it, Connect won't work.
Connect your account

Connect to Last.fm Allow access I've authorized ✓

The status flips to ● Connected as [your username] and you're done.

Where is this stored?

In this browser only. Switch browsers or clear site data and you'll reconnect. Everyone connects their own account — credentials are never shared.
Fix and push scrobbles

Open the Raw Data tab. Every row has a ✎ button — click it, fix the artist, title, album or time, then hit Push to Last.fm.

Last.fm's API can add scrobbles, never delete them. A correction adds a new scrobble beside the old one — delete the original yourself on last.fm under Profile → Scrobbles.

Fixing the same track everywhere?

Tick Apply to all matching entries in the edit panel to correct that artist/track across your whole local history, then push once.

Troubleshooting

The "Push to Last.fm" button doesn't appear in the edit panel.

You need to complete Step 3 first. Open Settings → Last.fm → Scrobble Setup and check that the status shows "Connected".

Clicking "Connect to Last.fm" gives an error.

Make sure both your API Key and Shared Secret are filled in under "Use custom API credentials". The button won't work with just a username.

"Push to Last.fm" shows an error after connecting.

Your session may have expired. Go to Settings → Disconnect, then reconnect following Step 3 again.

The scrobble appears twice on Last.fm.

That's expected — the push added the corrected version but the original is still there. Delete the original manually on the Last.fm website (Profile → Scrobbles).

Need help?

Can't get it working? Open a support ticket and we'll get back to you.

or email support@dankcharts.fm

What you'll need

A data export from your music service — or any spreadsheet of plays
A spreadsheet editor, if your export needs reshaping (Google Sheets, Excel and Numbers all work)
Patience: most services take a few days to send your data

Get your export
Where's your history coming from?
- Spotify.zip · drop it in
  
  Account → Privacy settings → Download your data. Tick Extended streaming history — "Account data" is only the last year.
  
  Arrives by email as a ZIP. Upload it without unpacking.
  
  How long does it take?
  
  A few days for account data, up to 30 for extended history.
- Deezer.xlsx · one edit first
  
  Settings → My personal data → request your data.
  
  You get a workbook of several sheets, and only the first one is read. Drag your listening history to the front, save, upload.
- Last.fm.csv · drop it in
  
  No built-in export — use ghan.nl's exporter: username → scrobbles → CSV. No API key, no sign-in, no editing afterwards.
  
  Two things worth knowing
  
  Over 100,000 scrobbles takes a minute or two to build.
  
  It can fetch only what's newer than a previous export — but uploads here replace rather than merge, so keep the full file.
- YouTube Musicconvert first
  
  Google Takeout → deselect everything → YouTube and YouTube Music → limit to history.
  
  Takeout's ZIP isn't a shape we read. Turn its watch-history file into a CSV — Step 3.
- Apple Musicrename headers
  
  privacy.apple.com → Request a copy of your data → Apple Media Services information.
  
  The play-history CSV uses Apple's own column names — rename the header row in Step 3.
- Something elserename headers
  
  Tidal, Amazon Music, SoundCloud, Plex, a DJ set log, a spreadsheet you keep by hand — anything with a track, an artist and a date works. Step 3 has the column names.
Menu doesn't match what you see?

These paths move around. Search your service's help centre for "download my data" — the export itself is what matters, not the route to it.
Can it go straight in?

Three shapes need no editing. If yours is one, skip to Step 4.

FileWhat's read

.zipSpotify streaming history

.xlsx / .xlsfirst sheet only

.csvcolumn names from Step 3

Spotify ZIP

Upload it whole. Plays under 30 seconds are dropped, and so is anything without both a track and an artist — which is how podcasts fall out. A lower total than you expected is usually that, not a failure.

Deezer XLSX

Only the first sheet is read, so move your listening history to the front. English or French headings both work — titre, artiste, album, écoute.

A CSV you already have

If its header row already uses a name from Step 3, it's ready. ghan.nl exports are — their extra MusicBrainz ID columns are simply ignored.
Make it a CSV

The universal path: any export becomes importable once row 1 uses these names.

ColumnHeader — any one of these

Song title (required) song title · title · track · track name · song name

Artist (required) artist · artist name · performer

Date and time (required) date and time · date · datetime · timestamp · time · played at · scrobble time · uts · utc_time

Album (optional) album · album name · release

One row per play — a track you've heard forty times is forty rows.

Format dates as YYYY-MM-DD. 03/04/2024 is read as March 4th, not April 3rd — a day-first export lands a whole year on the wrong days.

What else is accepted?

Extra columns are ignored, capitalisation doesn't matter, and column order is irrelevant. Renaming row 1 is the whole job.

Dates work as 2024-03-09 21:14:05, 2024-03-09, ISO 8601, 03/09/2024 or unix seconds — as long as the year is 2000 or later.

In Google Sheets, reformat a date column with Format → Number → Custom date and time → yyyy-mm-dd hh:mm:ss.

Save it out with File → Download → Comma-separated values (Excel: Save As → CSV UTF-8). Let the spreadsheet write the file and commas inside song titles look after themselves.
Upload it

Settings ⚙ Upload File

Drop the file on the box or click to browse — .csv, .zip, .xlsx, .xls. You'll see ✓ N plays loaded and your charts appear.

Uploading replaces, it doesn't merge. Combining two services? Join them into one CSV first.

Troubleshooting

It says the required columns are missing.

The header row needs a title column, an artist column and a date column, spelled as one of the accepted names in Step 3. Check row 1 specifically — if your export has a title banner or a blank line above the headers, delete those rows so the header row is the very first line of the file.

It says no valid records were found.

Almost always the date column. Every row needs a date that parses to the year 2000 or later — rows without one are skipped, and if that's every row you get this message. Reformat the column to yyyy-mm-dd hh:mm:ss and try again.

My Spotify ZIP imported far fewer plays than I expected.

That's usually correct rather than broken. Plays shorter than 30 seconds are skipped, and podcasts and videos are dropped because they have no artist and track pair. If you got the basic "Account data" export rather than Extended streaming history, it also only covers about the past year.

My Deezer XLSX imported nothing.

Only the first sheet of a workbook is read, and Deezer's export usually opens on a different one. Move the listening-history sheet to the front of the workbook, save, and upload again.

My Google Takeout ZIP does nothing.

Only Spotify's ZIP layout is recognised — Takeout's is different, so nothing inside it is found. Open the watch-history file from the Takeout archive, reshape it into a CSV as described in Step 3, and upload that instead.

My ghan.nl export won't upload.

That tool offers XML, CSV and JSON — only the CSV option can be uploaded here. It also exports loved tracks and events, which aren't play histories; make sure scrobbles is the selected export type.

Everything imported, but the dates are all wrong.

Your export is almost certainly day-first (DD/MM/YYYY), which is read as month-first. Reformat that column to yyyy-mm-dd hh:mm:ss in your spreadsheet, export again, and re-upload.

Need help?

Stuck on a format we haven't covered? Open a ticket with a couple of sample rows and we'll work out the mapping with you.

or email support@dankcharts.fm

What you'll need

Copy the template sheet

Fill in your details

The script is already there

Start auto-sync

Connect it to dankcharts.fm

Add plays by hand Optional

Troubleshooting

What you'll need

Create a Last.fm API app

Paste them into dankcharts.fm

Connect your account

Fix and push scrobbles

Troubleshooting

What you'll need

Get your export

Can it go straight in?

Make it a CSV

Upload it

Troubleshooting