up vote 0 down vote favorite
share [g+] share [fb]

All,

I want to insert some text and number from a given URL into an Excel spreadsheet. Is there a good way to do that?

More specifically, I want to incorporate some of the info in the table "Nutrition Information" from this page:

http://nutritiondata.self.com/facts/beef-products/3271/2

Many thanks,

JDelage

link|improve this question
80% accept rate
What version of Excel? – Alex Feb 22 '11 at 16:33
can you give a little more information about what you are trying to do, perhaps an example of the result you want? – datatoo Feb 22 '11 at 18:39
feedback

1 Answer

up vote 2 down vote accepted

Using Excel 2007

From menu Data/Get External Data/From Web

opens a form:

  • paste address;(eg http://nutritiondata.self.com/facts/beef-products/3271/2)) and click Go
  • web page is displayed (I get a script error, just click Yes, it doesn't seem to matter)
  • scroll down to the table you want
  • select it with the little yellow arrow thingy
  • Click Import

Voila, data is in excel!

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.