Import data from the web in excel mac and pc

[Beni1111]

Hi,
This is what I'm using to import data on mac;

WEB
1

http://www.betexplorer.com/streaks/best-worst-teams/?sport=soccer

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=false
ConsecutiveDelimitersAsOne=false
SingleBlockTextImport=true

It is working fine... but it does not import the odds. When I copy paste this page in excel, the odds are there... not when I import it, there should be a way to import the odds.

It does the same with pc; import from the web.
Someone?

[a4u2fear]

I quickly tried this and arrived at the same conclusion.

I believe the answer is that the team's stats (i.e. GP, P) exist on the page, and the current odds are pulled from another table somewhere else (HTML coding); but do not exist on the page. So when you import using code, you get the team stats but not the odds. But if you copy/paste you are actually copying the data on the page, so you are able to paste it into excel.

Sites use these types of tables so they can constantly update the odds.

I do not know how to code with HTML so I cannot offer any help.