I am easy to work with, communicative, and almost always give all-5-star review.
Open the attached "format_about_featured.csv". I want to make this type of format using musicbrainz data.
Musicbrainz.org is a music data website, and each artist, label, release, recording has their own MBID (musicbrainz identifier)
I will make an excel spreadsheet "artists.csv" containing a list of artists.
Suppose the artists.csv contains only one artist "Rihanna"
I want a program to get the list of songs (=recordings) that Rihanna participated as a "featuring" or "guest" artist rather than as a "main" artist.
The result will look like the "format_about_featured.csv" that I attached.
However, don't include songs that are in compilation or remix album.
Go to http://musicbrainz.org/doc/MusicBrainz_Database/Download and http://ftp.musicbrainz.org/pub/musicbrainz/data/fullexport/
You can download the entire musicbrainz data dump in xml.
A crude schema is at http://musicbrainz.org/doc/MusicBrainz_Database/Schema .
If you are stuck, you can even ask questions on musicbrainz forum at http://forums.musicbrainz.org/
======I will tell you more details once you post a message.=======