CODEWITHSUNDEEP
web-scrapinggoogle-sheetsarray-formulasgoogle-sheets-formula
Wrestling with Android
Wrestling with Android

Reputation: 127

Google sheet IMPORTHTML function could not find the data

I am trying to get the data table from this site http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/vebitda.html into goole sheets.

I have tried:

=IMPORTHTML("http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/vebitda.html", "table", 1), but this gives me a N/A

What is wrong?

Upvotes: 0

Views: 181

Answers (1)

player0
player0

Reputation: 1

you may try to get it via:

=QUERY(IMPORTDATA("http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/vebitda.html"), 
 "offset 1181")

and try to remove tags with:

=ARRAYFORMULA(IFNA(REGEXREPLACE(A1:A, "</?\S+[^<>]*>", )))

and then use FILTER with MOD to get every n-th value and recreate the whole table

Upvotes: 2

Related Questions