I've been using =ImportHTML() but it seems a bit limited to what it can import from websites, from what I've seen it looks like you can only import from a site that has the data in a table or a list, but maybe there's something I'm overlooking?


For example, let's say I'm trying to update my sheet based on the interest rates on this site: https://celsius.network/rates/

I'm unable to grab the info because it's in a div stylized as a table.


1 Answer 1


You can use =IMPORTXML() which support xpath_query. In your use case, the query would be something like:

=IMPORTXML("https://celsius.network/rates/", "//div[@id='ETH']")

Here's the spreadsheet that I've used to make sure it's working. You can make a copy by clicking here.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.