SEARCH

The How-To Geek Forums Have Migrated to Discourse



Join the Discussion at discuss.howtogeek.com

How-To Geek Forums / Microsoft Office

Importing Web tables in Excel

(2 posts)
  • Started 8 months ago by coolkidz33
  • Latest reply from moreeg
  • Topic Viewed 528 times

coolkidz33
Posts: 1

I have watched several videos of importing web data into Excel. Looks easy enough. My question is, why do some apparently obvious looking tables not have the yellow arrow next to it so you can import them into Excel. I know you can copy them but some update all the time. Here is an example: http://espn.go.com/nfl/statist.....t/passing. I can do all the ads or the whole page but not just the tables with the passing leaders in it. If I import out the whole page and then delete what I do not want, it all comes back when I refresh. Seems like this data is tailor made for importing into Excel.

Thanks. Coolkidz33

Posted 8 months ago #
Top
 
moreeg
moreeg
Posts: 842

Hi Coolkidz33

The appearance of the yellow arrows are based on HTML tags used to construct the page. It seems that this particular Excel capability has not advanced in line with new HTML or other web development techniques and as a result what seems to be an obvious table is not recognised by the data import facility.

There are 2 ways around this problem;

Use the import in a separate worksheet and then access the specific information you want via formulas or
Highlight the data you want on the web page, copy and then paste into your worksheet.

Posted 8 months ago #
Top
 



Topic Closed

This topic has been closed to new replies. Please create a new topic instead.


Create New Topic Return to Forum