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 — don't have one? Step 2 creates it, takes two minutes

Copy the template sheet

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

Open the template →
Get your free Last.fm API key

The sheet pulls your plays through Last.fm's API, and that needs a key of your own. Free, instant, no approval — sign in to Last.fm and fill in the form at last.fm/api/account/create. The values can be anything:

FieldWhat to enter

Application nameMy Music Charts

DescriptionPersonal use

Homepage (optional)https://dankcharts.fm

Callback URL (optional)https://dankcharts.fm

Copy the API Key it shows you — that's all this path needs. It also shows a Shared Secret; ignore that here, it's only for scrobble pushing.
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

The API key is the one you copied in Step 2 — paste it exactly, no extra spaces.
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 7.
Start auto-sync

Everything is in place — this switches it on. Go back to the browser tab with your sheet: there's now a Last.fm menu in the menu bar at the top, just right of Help.

Don't see a Last.fm menu? Reload the page. That menu is added each time the sheet opens, so a tab you already had open won't have it yet.

Switch it on

Last.fm Start Auto-Update (90 min)

Approve it — one time only

The first time you run anything from that menu, Google asks you to approve the script. It walks you through four screens, and one of them looks scarier than it is:

Screen you'll seeWhat to click

Authorization required Continue / Review permissions

Choose an account your own Google account

Google hasn't verified this app Advanced, then "Go to … (unsafe)"

… wants access to your Google Account Allow

"Unsafe" reads worse than it is. Google shows that screen for every personal script that hasn't gone through its commercial review — including this one, which is your copy sitting in your Drive. It fetches your plays from Last.fm and writes them to this one sheet. Nothing else, and nobody else can run it. Every line is readable under Extensions → Apps Script.

What happens after that

Nothing lands instantly — the first batch of plays arrives about a minute later, then a fresh one every 90 minutes. Each sync resumes from the last play it saved, so nothing is fetched twice.

It runs on Google's servers, so you can close the sheet and the browser entirely. Want the newest plays right now instead of waiting? Last.fm → Fetch Latest Tracks runs the same sync on the spot.

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

Your sheet is filling up with plays — now point the site at it. This is the last step you actually need.

First, let the site read the sheet

dankcharts.fm reads your sheet straight from your browser and never signs in to your Google account, so a private sheet gives it nothing back. Open the Share button at the top right of your sheet and change one setting:

In the Share dialogSet it to

General access Anyone with the link

The role beside it Viewer

This doesn't publish your listening history. "Anyone with the link" means the link is the key — the sheet isn't listed in anyone else's Drive, and nobody stumbles across it. Viewer means even someone holding the link can only read it, never change it.

Copy the link from that same dialog

While you're still in the Share dialog, use its Copy link button — not the URL in your browser's address bar.

The address bar carries a hidden tab pointer. It ends in #gid=…, naming whichever tab you happen to be looking at — and that quietly overrules the tab name you set below. Copy it while the Settings tab is open and the site reads your Settings tab, finds no plays, and shows you empty charts with no error. Copy link gives you a clean URL with no pointer.

Paste it into the site

Settings ⚙ Google Sheets

FieldWhat to put in it

Sheet URL or ID the link you just copied

Tab name leave empty

Leave Tab name empty unless you renamed the data tab in your copy — empty means Full Raw Listening History, which is what the template calls it.

Hit Save & Load. Your plays are read on the spot and your charts appear. That's the setup done — Step 7 is optional, and only worth it if you want to change your listening history from the site rather than in the sheet.
Let the site write back to your sheet Optional
Everything so far is one-way: the site reads your sheet. Skip this step and your charts work perfectly — you just can't change anything from the site. Spend five more minutes here and three things switch on:
- + Add Play — log a play that never scrobbled (a record, a live set, a friend's aux cord)
- Fixing a play sticks — the ✎ button in Raw Data writes the correction into the sheet itself, instead of only tidying what you see in this browser
- Autocorrect rules save — "this misspelling always means that artist" gets remembered and applied to the sheet on every load
Deploy the script as a Web App

The script that's been syncing your plays can also listen for messages from the site — but only once it's published with a URL of its own.

Extensions Apps Script Deploy New deployment

The type isn't a dropdown. In that dialog, click the small gear icon beside "Select type" and choose Web app from it. It's the step most people hunt around for.

SettingValue

Type (the gear icon)Web app

Descriptionanything, or nothing

Execute asMe

Who has accessAnyone

"Anyone" is wider than it sounds, and it's the only setting that works. Your browser calls this script without being signed in to Google, so it has to accept an anonymous request. Execute as: Me keeps it running with your permissions on your sheet and nothing else. The URL is what stands in for a password — it's long and random, but treat it that way: anyone you hand it to could add rows to your sheet.

Press Deploy. Google asks you to authorise it, exactly as in Step 5 — same Advanced → Go to … (unsafe) → Allow path.

Copy the URL it gives you

The deployment finishes on a Web app URL — a long one ending in /exec, like https://script.google.com/macros/s/AKfy…/exec. Copy it, then paste it into the site. It lives one fold down from where you put your sheet link:

Settings ⚙ Google Sheets Enable auto-sync & manual play entry Apps Script Web App URL

Hit Save & Load. Open the Raw Data tab and you'll find + Add Play waiting at the top.

If you ever edit the script, this URL stops matching it until you republish: Deploy → Manage deployments → the pencil icon → Version: New version → Deploy. The URL itself stays the same, so there's nothing to re-paste here.

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".

My charts are empty, but the sheet is full of plays.

Look at the URL you pasted into Settings. If it ends in #gid= followed by a number, it's pointing at one specific tab — whichever one was open when you copied it from the address bar. When that's the Settings tab, the site reads three rows of configuration instead of your listening history and shows empty charts without complaining.

Fix it by deleting everything from #gid= onwards, or by re-copying the link with the Copy link button inside the sheet's Share dialog, which never includes one.

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 ⚙ Data Source Last.fm Account 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 back to the site

Clicking Connect opens Last.fm in a new tab. Approve it there, come back, and the status flips to ● Connected as [your username] on its own.

Until that happens it says ● Waiting for your approval on Last.fm, which is the honest answer: opening the Last.fm tab does not connect anything by itself. If you approved it and the status hasn't caught up, press Check now. Only a verified reply from Last.fm turns it green.

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 → Data Source → Last.fm Account and check that the status shows "Connected". This section sits below the source cards and stays available whichever source you use, so you can connect from Google Sheets or a CSV upload too.

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

Get your free Last.fm API key

Fill in your details

The script is already there

Start auto-sync

Connect it to dankcharts.fm

Let the site write back to your sheet 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