Spotify -> Rekordbox playlist

Create a playlist that I can import into Rekordbox from a Spotify playlist, using audio files that actually exist on my computer.

I will provide:

Spotify playlist URL: [paste URL here]

Rekordbox XML: [attach file or provide its path]

Music and Downloads folders: [specify if needed]

Follow these steps:

Read the playlist name, owner, complete track list, artists, and track order from Spotify. Verify the total track count. Do not assume the playlist is complete just because the embed displays 100 tracks. If there are more, retrieve the remaining tracks from the Spotify website or desktop app.

Read my music library from the XML and match tracks by both title and artist. Carefully distinguish similar titles, different artists, sequels, featured artists, and remix versions. Do not match solely on partial titles or short artist-name substrings.

When multiple versions exist, choose the verified matching version with the highest PlayCount that has an existing local file. DJ edits, intros, clean, dirty, and remix versions are acceptable, but report the exact selected version. Avoid mashups or segues that change the main song. If Spotify specifies a particular remix or song part, verify that version.

Convert each XML Location into a real filesystem path, correctly handling file:// URLs and URL encoding. Verify that every file exists. If the preferred version is missing, look for another matching version with an existing file. Otherwise, mark the track as missing. Never invent file paths.

Preserve Spotify’s track order by default. Do not sort by BPM unless I request it. Do not remove tracks simply because they do not fit the playlist’s title or genre.

Export these files:

A UTF-8 .m3u8 file beginning with #EXTM3U, using absolute paths to existing audio files and #EXTINF entries.

A .txt report covering every Spotify entry, with Rank, Spotify Track, Spotify Artist, Status, BPM, Selected Version, Artist, PlayCount, TrackID, and Path.

A _missing.txt report listing missing tracks and explaining whether no verified library match exists or the XML entry exists but its local file is missing.

Validate the results before delivery:

The number of reviewed entries matches Spotify’s total.

Ready-to-import entries plus missing entries equals the total.

Every path in the .m3u8 points to an existing file.

There are no duplicates caused by incorrect matching. If Spotify itself contains repeated entries, report them and preserve the original order.

Never invent BPM, PlayCount, or TrackID values.

Provide download links for all three files. State the playlist name, total track count, ready-to-import count, missing count, and whether any DJ edits or remixes substitute for Spotify versions.