Google-sheets – Inability to use `IMPORTHTML` in Google sheets

google sheetsimporthtml

I use the website below:

http://score.nowscore.com/odds/match.aspx?id=1396936

to import data from that website to Google sheets but it does NOT work. The formula I use to try to import data is:

 =IMPORTHTML("http://score.nowscore.com/odds/match.aspx?id=1396936","table")

Best Answer

The error shown by Google Sheets is 

#N/A Could not fetch url

which means the problem is that the Google bot cannot access the page. Usually this happens because the server's owners block bots/scrapers from reading their content. A look at their robots.txt file confirms the guess:

User-agent: * 
.....
Disallow: /Odds

So, all robots are blocked from viewing /Odds (and many other pages of that site). Nothing you can do about that.

Related Topic