Linked Questions

0
votes
1answer
54 views

IMPORTXML not working [duplicate]

I’m trying to scrap prices from various e-commerce site. However the IMPOrtxml function is not working For instance, https://shopee.sg/Ice-Silk-2019-Men-Underwear-Cool-Breathable-Comfortable-Sport-...
0
votes
0answers
23 views

Google Sheet Importhtml from website but I could not get a data [duplicate]

I would like to get NAV from a website below but I could not get a data. https://www.bblam.co.th/en/products/mutual-funds =importhtml("bblam.co.th/en/products/mutual-funds/","table"...
0
votes
0answers
19 views

Google Sheets importxml() can't fetch from http://www.aastocks.com/ [duplicate]

I'm trying to fetch data using importxml() but it just fails with "#N/A". I have tried it on other pages and works fine. But it doesn't work on this site, and I don't know why. Here is the ...
0
votes
0answers
15 views

Using importXML in in Google Sheets to pull data under a “b class” [duplicate]

Looking at this page: https://www.mycryptobuddy.com/BitcoinMiningCalculator/path?hashrate=110&powerCost=0.059&power=3250&hardwareCost=4050 There is a line that says "Profitable in 10 ...
0
votes
0answers
15 views

Getting web data into Google Sheets - from formatted chart [duplicate]

Edited: this question was associated with another question. I read that answer, appreciate it. Since importxml not working, I wonder what the format would be to read this in another way like ...
0
votes
0answers
12 views

Trying to fetch data from https://ark.intel.com/ with Google Sheet functions [duplicate]

I'm trying to read the datasheet at this page inside a google sheet. However, both IMPORTXML (1) and IMPORTHTML (2) return #N/A. Whats's wrong? (1) IMPORTXML(A1,"//div[contains(@class, 'specs-...
0
votes
0answers
11 views

Google Sheets importxml help [duplicate]

I am trying to scrape the number of photos statistic from a Facebook Group (currently 432,780) at: https://m.facebook.com/groups/553511078046085?view=info I have copied the relevant xpath and used the ...
0
votes
0answers
9 views

Import XML intermittently doesnt work but sometimes does on Google Sheets (currencies/shares etc)..Image attached [duplicate]

I have a spreadsheet monitoring my Stocks and cryptos etc on Google Sheets. I have a formula which 50% works and auto updates and 50% doesnt work and comes up with 'N/A : Could not fetch URL'...when ...
0
votes
0answers
7 views

Import data from Investing.com or other sites into spreadsheet not possible anymore? [duplicate]

I wanted to import from the section of historic data high/low prices in weekly ranges. For example from this site: https://www.investing.com/indices/us-30-historical-data I tried =INDEX(IMPORTHTML(&...
0
votes
0answers
7 views

Sheets - Import XML pulling specific table values not working [duplicate]

I have been trying to pull specific values from the "on-ice" chart and applying this to many players at once but I cannot seem to string together the correct path to achieve this. Here is ...
0
votes
0answers
7 views

Finding xPath to a price value on a website and import value to Google Sheet [duplicate]

All my attempts for importing the values of "BTC/CAD BUY Price" and "BTC/CAD SELL Price" from this page into Google Sheet failed. I was trying to use IMPORTXML() function. I also ...
3
votes
2answers
7k views

Google Sheets column limit?

I have 137 columns (EG). I cannot scroll to the right of column EG. I have many rows, but only 37 used rows. Reading what I can find via searches, it seems I should not be facing this restriction....
0
votes
1answer
2k views

Inability to use `IMPORTHTML` in Google sheets

I use the website below: http://score.nowscore.com/odds/match.aspx?id=1396936 to import data from that website to Google sheets but it does NOT work. The formula I use to try to import data is: =...
0
votes
1answer
2k views

Google Spreadsheet IMPORTXML problem to extract from a web page

I'm trying to extract the "Comestibilité" and "Remarques" parts from a page using IMPORTXML in my Google Spreadsheet but I just can't get to them, they are generated by JavaScript but I cannot figure ...
-1
votes
1answer
2k views

Google Sheets ImportXML //div[@class= is not working

I am trying to scrape the div "tech-name" from this website https://www.whatruns.com/website/bestbuy.com with the following formula =index(importxml("https://www.whatruns.com/website/bestbuy.com","/...

15 30 50 per page