xmlgoogle-sheetsgoogle-sheets-formulabitcoin

importxml formula in Google Sheets adds random cell below it

I want to fetch the bitcoin price through the formula importxml, which it works.

The problem is that it adds a random value to the cell below it. I can't delete it.

This is the formula

=IMPORTXML("https://coinmarketcap.com/currencies/"&D1, "//div[contains(@class, 'priceValue')]")

This is the result (what's that number (0.0668) there?):

enter image description here

Solution

  • Can you try this:

    =IMPORTXML("https://coinmarketcap.com/currencies/"&D1,"//div[@class='priceValue ']")

    enter image description here