Google Sheets – Import Data from a
Element

google sheetshtmlimport

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?

https://support.google.com/docs/answer/3093339?hl=en

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.

Best Answer

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.

Related Topic