The How-To Geek Forums Have Migrated to Discourse


How-To Geek Forums / Microsoft Office

Importing Web tables in Excel

(2 posts)
  • Started 3 years ago by coolkidz33
  • Latest reply from moreeg
  • Topic Viewed 775 times

PARTNER SPOTLIGHT

Recommended: Clean Your Mac the Easy Way with CleanMyMac 3

If you want to clean up your Mac the easy way, CleanMyMac is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyMac 3 for Free Today

Posted yesterday 
Top
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 3 years ago
Top
 
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 3 years ago
Top
 



Topic Closed

This topic has been closed to new replies.