Sabha
Sabha

Reputation: 619

Unable to import data from webpage to google sheets

I know how to use the importhtml function of google spreadsheets but there is one webpage which refuses to load the table. Link given below.

https://www.dream11.com/cricket/fantasy-scorecard/1027/14047

I even tried the below code in google developer console to check the table index but this also did not solve var i = 1; [].forEach.call(document.getElementsByTagName("table"), function(x) { console.log(i++, x); });

Please help

Upvotes: 0

Views: 1000

Answers (1)

Joel Reid
Joel Reid

Reputation: 993

To test whether a site is able to be used with IMPORTHTML, turn off javascript and load the page. If the content isn't there anymore, it's not actually part of the html and so it's not compatible with IMPORTHTML.

This is the case with your link—sorry. That table is populated after the fact and so it cannot be seen by Sheets.

Find a new source for that data.

Related: Google Sheets ImportHTML can't find table?

Upvotes: 1

Related Questions