Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
    
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
add comment

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!

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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