Google-sheets – Trying to use Google Sheets importHTML() to import a table. But no content appears

google sheetsgoogle-appshtmlimporthtml

I'm attempting to load the following website into Google Sheets:

https://www.lasvegasadvisor.com/vegas-lines/?sport=ncaafb&period=0

Can anyone help provide a formula that would work in google docs to get this done? This website is updated at random times throughout the day so I want to use google docs to help track that.

I've included two images below of what I currently am doing. Any help/insight is greatly appreciated!!!

Thanks,

strong text

Best Answer

IMPORTHTML doesn't works because the page you are trying to scrape use JavaScript to add the data tables to the page. Google Sheets doesn't have built-in functions that are able to scrape data that is isn't included on the source code.

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

Short Answer

Instead of LEFT() use RIGHT().

Explanation

The LEFT() function returns the leftmost characters, but the OP want to get the rightmost characters.

The following is a simplified version of the final formula, for explanatory purposes:

=RIGHT("Sector: Industrial Goods",16)

The following is the final formula; in order to improve readability, each parameter is inserted in a new line:

 =RIGHT(
   iferror(
     INDEX(
       IMPORTHTML(
         "http://www.thestreet.com/quote/GE/details/company-profile.html",
          "table",
          3
        ),
        8,
        1
     )
   ),
   16
 )

Best Answer

Related Solutions

Google-sheets – how to clean up table data in Google Sheet IMPORTHTML

Google-sheets – Google Sheets LEFT function trim text generated by IMPORTHTML function

Short Answer

Explanation

Related Topic