CODEWITHSUNDEEP
xpathweb-scrapinggoogle-sheetsgoogle-sheets-formula
Michael M
Michael M

Reputation: 57

Receiving Error "imported content is empty" when using ImportHTML

I'm using the following formula (have tried using a bunch of different table numbers) and am receiving the "imported content is empty" error. Any ideas as to why or possible solutions?

importhtml("https://www.sportsbookreview.com/betting-odds/nba-basketball/pointspread/1st-quarter/",
           "table",
           1)

Upvotes: 1

Views: 406

Answers (1)

player0
player0

Reputation: 1

only what you see in the picture can be scraped

use IMPORTXML

find data you need with INDEX -ing 

=IMPORTXML("https://www.sportsbookreview.com/betting-odds/nba-basketball/pointspread/1st-quarter/";
 "//*")

or point to specific div like:

=IMPORTXML("https://www.sportsbookreview.com/betting-odds/nba-basketball/pointspread/1st-quarter/";
 "//div")

Upvotes: 1

Related Questions