Can't import a .html URL into Google Sheets?

Question

What I am trying to archive is import the first row (excluding header) from this URL: https://colintalkscrypto.com/cbbi/table.html

IMPORTDATA bring in all the html code and IMPORTHTML doesn't work as it's looking for the actual table from https://colintalkscrypto.com/cbbi/

There is also a JSON URL which is the same data but no luck with that either

https://colintalkscrypto.com/cbbi/data/latest.json

Any help would be great

Answer 1

try:

=INDEX(QUERY(SPLIT(IMPORTDATA("https://colintalkscrypto.com/cbbi/data/latest.json"), ":"), "offset 2", 0))