Fetch data from google/wikipedia based on excel fields.

[Niode]

Here's a question to all the codemonkeys out there.

Is there any way to fetch specific data from a site like CDDB or amazon or even google etc, based on the criteria of a couple of cells in an excel (2007) spreadsheet?

IE I have a spread sheet that has 4 columns, song title, artist, year, notes. I want to find out the track year and a short synopsis of the artist to put in the year and notes column.

Is this even possible with excel?

This spreadsheet has litteraly thousands of entries in it, and I really don't fancy inputting the data manually. It seems so much faster to let a computer do it. After all isn't that what computers are for?

[Hatta]

I don't know about Excel, but there are python tools to do that. See:

http://www.josephson.org/projects/pyamazon/
http://cddb-py.sourceforge.net/

If I were you I'd write a python script to fetch the data, output a CSV and import that into Excel. If you really want Excel that is.

[Niode]

It's not for me it's for somebody else. If it was up to me I wouldn't even bother. I'd just use FreeDB or something.