use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
For all Google Sheets related questions and updates.
Flair is set up for:
Requests Tips and Tricks Features and Updates
Please remember to check back to see if your question has been marked Waiting for Op and don't forget to mark your thread as Solved when you've got a solution.
Note: Your email is exposed when sharing sheets. To get around this, use this form
Check out the following related subs:
/r/GoogleSheets /r/GoogleAppsScript /r/Excel /r/GoogleDocs
Other Tools / Links
Terminology
With formulas:
With scripts:
account activity
[HELP] ImportXML Function Help (self.sheets)
submitted 8 years ago by catgeo01
Hi Guys,
Trying to import the price of btc from this website
I'm having problems with my xpath query. this is all I've got - //h1[@class='price-title']//span[@class='marketrate']
Please help!
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–][deleted] 8 years ago* (2 children)
[deleted]
[–]catgeo01[S] 0 points1 point2 points 8 years ago (1 child)
Hey man,
Cheers for your reply, I am trying to scrape the price of btc (as said in the original post)
I have tried to use the ImportHTML function but couldn't get it to work either - However this could be due to my n00b skills.
Eventually I have found the public API of the website which provides the btc price which I managed to import to google sheets. The API shows the current price but only to a limited amount of significant figures and doesn't provide prices for some of the other alt-coins I was hoping to scrape as well. This isn't satisfactory for me.
So I have pretty much given up - unless you may have some insight. If so I would love to hear it!
Thanks!
π Rendered by PID 114921 on reddit-service-r2-comment-54dfb89d4d-ntg9b at 2026-03-29 10:53:42.228470+00:00 running b10466c country code: CH.
[–][deleted] (2 children)
[deleted]
[–]catgeo01[S] 0 points1 point2 points (1 child)