Linked Questions

0
votes
1answer
36 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
26 views

IMPORTHTML waiting on data [duplicate]

I am fairly new with query language, but I have been looking around the internet to find a solution to this problem without any luck. I'm trying to import data from leaderboards on specific tracks in ...
1
vote
0answers
14 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
9 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-...
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 ...
0
votes
2answers
815 views

Trying to pull data from website into Google Sheet [closed]

I'm trying to pull the data from this website into a Google Sheet https://www.pgatour.com/stats/stat.194.html I've used =importhtml or =importxml in the past for this site, but I can't get it to ...
1
vote
0answers
724 views

My ImportXML with XPath doesn't work

I've got a problem. I'm trying to import data in my google sheet document using =ImportXML with XPath from this page : https://www.boursorama.com/bourse/produits-de-bourse/cours/warrants/...
0
votes
1answer
625 views

Syntax problem in ImportXML function [duplicate]

This is related to an earlier question regarding syntax issues with ImportXML function in Google Sheets relating to data from this providers web site: https://www.asxenergy.com.au/futures_au/N The ...
-1
votes
1answer
366 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","/...
-1
votes
1answer
340 views

Having syntax trouble with IMPORTXML Google Sheets function

I have been studying the various IMPORTXML examples posted however I have not been able to solve for the actual data I wish to pull in to my sheet. The page is here: https://aemo.com.au/Electricity/...
1
vote
1answer
250 views

Trying to use Google Sheets importHTML() to import a table. But no content appears

I'm attempting to load the following website into Google Sheets: https://www.lasvegasadvisor.com/vegas-lines/?sport=ncaafb&period=0 Can anyone help provide a formula that would work in google ...
0
votes
1answer
251 views

Google Sheets: word count for a webpage content (url) for SEO

For SEO analysis, I am using Google Sheets to extract basic data from my own webpages. I am able to access page title, description, <h1> tags, or number of characters via LEN(): =IMPORTXML(A3, ...
0
votes
1answer
208 views

ImportXML error: 'imported content is empty' when selecting for text within a list item

I want to scrape a text within this website in google sheets with the IMPORTXML function. Through dev tools by inspecting the text in question, I get the corresponding HTML: <li _ngcontent-udl-c4="...

15 30 50 per page