Pull cryptocurrency prices in Google Sheets 2 methods GOOGLEFINANCE

Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices

YouTube video

See another method for pulling crypto prices: https://youtu.be/YKn0mTpxGjk

Learn more about using IMPORTXML: https://www.youtube.com/watch?v=U7XXxtobXcA

In this video I am going to teach you two different ways to pull cryptocurrency prices into Google Sheets. First I will show you how to use the GOOGLEFINANCE function to pull crypto prices, and then I will show you how to use the IMPORTXML function to pull crypto prices into your Google spreadsheet. Check out the video linked above to learn more about using the IMPORTXML function.


Check Also



Hello guys in this video we are going to be talking about the latest update …


  1. Could anyone tell me why am I still getting imported content is empty? what could I be missing?

  2. Illan Arguindegui

    What should I do if I get the error message "Imported content is empty."

  3. Nick Cherkesov


  4. Christopher Kull

    thanks for quick video that i spent hours trying to find. hopefully i can get the updated times but this will work til then. very helpful

  5. You're out here saving lives my good sir.. thank you

  6. Hi Corey and greetings from Grand Rapids, Michigan. Just discovered your YouTube channel – great teaching manner. Followed your instructions and used CoinMarketCap instead of Coinbase as I have some projects not listed in Coinbase. When trying to import price data for ADA…the price cell shows "Loading…" and it just stays there. Something within my formula?…or perhaps my PC? Would appreciate your thoughts. Thanks! Randy

  7. Gabriel Alvarez

    Thanks for the great video. My IMPORTXML were working fine but from yesterday, it looks like all my IMPORTXML are not working anymore in my Google Sheets, even if I try to make simple one from Wikipedia. Would you know what can be the issue and how to fix it please? 🙂

  8. Nothakarn kaewmanee

    I used this method 3 weeks ago it worked very well
    but now it is not update and got Error Loadding

  9. Cashflow Sheets


  10. one of the most valuable vidz I have seen in a long time! much appreciated!

  11. Kenneth Priest

    Great videos Corey. I like the way you take the time to explain things and don't assume the viewer has 10 years experience with spreadsheets. I have two weeks.

    I was able to do the import XML function and get the numbers into the spreadsheet but I cannot get them to update. I have Google Sheets set to update on change or every 1 minute but these numbers that I imported do not update. I have Google Finance and Yahoo finance formulas running on the same page and they do update but only every 20 minutes. I realize that's a Google and Yahoo thing and nothing to do with Google Sheets.

    Is there a way to get the XML imported numbers to update?

  12. Can you also share how to fetch 52 week high/low

  13. It shows an N/A error when i use importxml

  14. Thank you for the video. I copied the full xpath of the Loopring price on Coinbase – but I was still getting an error until I noticed that my xpath html/body/div[1]/div/div[1]/main/div/section[2]/div/div/div[1]/div/div/div/div/div[1]/div[1]/div[1] was ever so slightly different than yours. I was able to get the price only by copying yours 🙂 but I was not able to retrace my steps 🙁 Is it possible that we can have 2 different xpaths for the same price?

  15. J. Steve Correia

    Finally a technique that works consistently without installing some questionable plugin. Thanks!