Using excel for pantry inventory

I am trying to create a simple log or database of my wife's VERY large pantry.

The whole idea started with a handheld laser scaer I bought. thinking if I scaed the UPC I could link it to one of the UPClookup.com to populate the spreadsheet with the retuing info.

But I know very little on how I would start this jouey. I have read some of these sites offer an API but how does one use it in excel, OR is there a better way to do this,