Spotify Metadata Extraction Utility

Job ID: 40352007

Budget: $250 – $750 USD

Project Description
I need a simple Windows desktop utility that will read a pipe-delimited text file containin Spotify Web API, and create a new pipe-delimited output file containing the original input data plus the Spotify metadata returned for the matched track.

This is a batch-processing tool for track research. It needs to be easy to use by a non-programmer.

What the utility must do

Run on Windows as a desktop utility
Import a pipe-delimited text file
Each row will contain track-identifying information such as artist, title, album, ISRC, release year, or other source fields
Query the Spotify API for each track
Match the correct Spotify track as accurately as possible
Export a new pipe-delimited text file
Preserve the original row order
Preserve the original fields from the source file
Add new Spotify fields as appended columns in the output file
Include a status field showing whether the row was matched, not matched, or matched with ambiguity
Handle large files reliably

Input / Output requirements

Input: pipe-delimited text file
Output: new pipe-delimited text file
Output should reference the original file by keeping the original columns and adding Spotify columns to the right
Utility should not overwrite the original file unless that is an optional setting

Spotify fields desired
At minimum, I want the ability to return as many of these fields as are available for the matched track:

Spotify track ID
Spotify track URL
Spotify URI
Track name
Primary artist
All artists
Album name
Album type
Release date
Track number
Disc number
Duration in milliseconds
Explicit flag
ISRC
Popularity
Preview URL if available
Market/playability fields if available
Match confidence or match notes

Matching logic
The utility should support matching based on one or more of the following when present in the input file:

ISRC
Artist + title
Artist + title + album
Artist + title + release year

I want thoughtful matching logic, not just a raw keyword search.
Please include a way to:

flag ambiguous matches
flag no-match rows
optionally output the top candidate match details for review

User interface
The UI can be simple, but should include:

File picker for input file
Option to choose output location
Mapping for which input columns contain artist, title, album, ISRC, etc.
Start button
Progress indicator
Error log or results summary
Basic settings screen if needed

Technical expectations

Windows executable preferred
Clean, stable code
Reasonable speed for batch processing
Good error handling
Clear instructions for setup and use
Source code included

Deliverables

Working Windows utility
Source code
Simple user guide
Sample input and sample output
Clear instructions for entering Spotify API credentials