Questions tagged [importxml]

For questions specifically about the Google Sheets function: IMPORTXML()

Filter by
Sorted by
Tagged with
1
vote
2answers
583 views

Using Google Sheets to bulk collect the number of Google Search results for given keywords

I would like to create a Google Sheets that will allow me to paste in a list of 25 or so keywords in column A and would then return the number of search results for each of those terms in column B. ...
1
vote
2answers
56 views

Inserting error (or spacer) when IMPORTXML can't scrape data in Google Sheets

I am using IMPORTXML to create what is essentially a vehicle inventory feed file. My issue arises when a price is not included in our main website. What seemingly is happening is when the price is ...
0
votes
1answer
70 views

Trying to fetch data from shopback.com.au with ImportXML function in google sheet

I am trying to fetch store name and cashback percentage from this website using google sheet's importxml function. Put following commands with no success. Please help =importxml("https://www....
1
vote
1answer
24 views

How to reference the result of a IMPORT function as a defined name in a single cell

Note: The motivation for my question is just formula readability. My sheet is working fine. Let's pretend I have an IMPORTXML function that's currently returning 2 columns and a varying number of ...
-1
votes
1answer
263 views

IMPORTXML error - empty table

I am trying to import a table from the lower part of the following website to Google Sheets: https://vistacapital.com.br/ I used the formula: =IMPORTXML("https://vistacapital.com.br";"//*[@id='sos-...
1
vote
2answers
2k views

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

Google Sheets has several import functions IMPORTDATA IMPORTFEED IMPORTHTML IMPORTXML Sometimes the above functions returns errors like #N/A Imported content is empty and would like to be sure that ...
0
votes
2answers
6k views

Google Sheets importxml() can't fetch from eoddata.com

I'm trying to fetch a piece of data using importxml() but it just fails with "Loading..." and never resolves. Other pages have no such problem at all, just this one and I don't know why. Here is the ...
1
vote
1answer
7k views

Pull information about each game from boardgamegeek.com

I am trying to create a Google Sheet to combine several peoples' board game collections. I want the sheet to pull information about each game from boardgamegeek.com. Example Page: https://...
1
vote
0answers
476 views

Import images from www.smashbros.com

Google sheets is giving me some trouble in retrieving span style attributes. I am trying to scrape a site (actually this) to grab some icon images for my spreadsheet. Below in red is one such example ...
1
vote
1answer
2k views

Extract table from moneycontrol.com

I'm trying to extract data from a table into Google Sheets, from this webpage: http://www.moneycontrol.com/stocks/fno/marketstats/futures/gainers/homebody.php?opttopic=&optinst=allfut&...
1
vote
1answer
33 views

Import the whole table from nextgenstats.nfl.com [closed]

I am trying to import the whole table from this site into a Google Sheet, but I keep getting the imported content empty error. I realize this error is very common and I have done my fair share of ...
-1
votes
1answer
199 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/...
0
votes
1answer
320 views

Import Price from Gamestop Into Google Sheets

I'm trying to obtain a price from a given Gamestop.com URL and have it imported into a Google Sheets document, but I can't seem to make it work. I've tried to use the importXML formula but don't seem ...
0
votes
2answers
34 views

Get translation using Google Sheets and IMPORTXML

I want to scrap the phonetic guide for a translation in Google Translator using Google Sheets. For instance, if you enter the page: https://translate.google.com/#view=home&op=translate&sl=...
0
votes
0answers
11 views

Google Sheets ImportHTML formula not pulling table I need [duplicate]

I have a Google Sheet trying to pull website table using ImportHTML formula to get a table from https://mesowest.utah.edu/cgi-bin/droman/raws_ca_monitor.cgi?state=AZ&rawsflag=3 ImportHTML(https:...
0
votes
2answers
324 views

ImportXML not loading due to number of requests

I am working on this sheet and it has a lot of ImportXML requests between columns N-Q. And because of the high number of requests, it seems like the ImportXML function is not working properly (it ...
0
votes
1answer
31 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
0
votes
0answers
23 views

How to find the original source to get the xPath

I'm trying to get an updating list from a store on Taobao.com I've tried using importxml to get the list using xpath but I keep getting "import content is empty" error. =IMPORTXML("https://...
1
vote
1answer
38 views

ImportXML With Line Breaks Google Sheets

I am using ImportXML to get some data from a website which looks like the following: =ImportXML("https://www.papercall.io/events?cfps-scope=&keywords=uk","//div[@class='panel panel-default']") ...
0
votes
3answers
182 views

IMPORTXML reading decimal separator as thousands separator

When I import this item via IMPORTXML and the spreadsheet locale is US (or other country that uses dot as decimal separator) it works fine: =IMPORTXML("http://bvmf.bmfbovespa.com.br/cias-listadas/...
1
vote
0answers
17 views

Google Sheets' IMPORTXML pulling from the wrong region

I'm using IMPORTXML to get the price of an electronics component from Mouser: If the prices are refreshed as a result of me editing the spreadsheet, it requests from my computer, and results in the ...
-1
votes
1answer
202 views

Retrieve fund price from Vanguard website using importxml in Google Sheets

This was working in Google Sheets but now I get #N/A message: Imported Content is Empty A1: https://institutional.vanguard.com/web/c1/product-details/fund/1680 A2: //*[@id='dailyNavValue'] A3: ...
1
vote
1answer
20 views

I am looking to fetch a table from a website in Google Sheets

I want the first table on this URL https://www.cashbackmonitor.com/cashback-store/amazon/ in my google sheet. When I put this function (below), I can retrieve the first column of the first table e.g....
-1
votes
1answer
73 views

IMPORTHTML - Can't find specific table on WNBA.com

https://www.wnba.com/stats/team-stats-advanced/#?Season=2018 Is the web page. I can't seem to find the table for advanced team rates or opponent.
0
votes
1answer
403 views

How to import data from Investing.com into spreadsheet?

I want to import the live individual stock price in the Google Sheets as highlighted on the image. Is that possible? https://in.investing.com/equities/jagson-airlines-bo
-1
votes
2answers
6k views

Google Sheets, Why won't importxml work on this sheet?

I have a sheet, upon which I'm trying to use importxml() but it just won't work properly. Until moments ago, not a single one of the formulas on this sheet would load at all, they just hung on "...
0
votes
0answers
52 views

How to fetch data in Google sheet using Import XML function with Xpath?

https://www.monito.com/send-money/australia/india/aud/inr/1000 Please open the URL and see what Query should I put to extract following data (=IMPORTXML("https://www.monito.com/send-money/australia/...
0
votes
1answer
324 views

ImportXML not stable in Google Sheets, how can I improve that?

I have ImportXML in my spreadsheet. I am tracking the Alexa ranking of a list of websites. Here is the formula: =HYPERLINK(CONCAT("www.alexa.com/siteinfo/",A4), value(ImportXML(CONCATENATE("http://...
1
vote
1answer
183 views

Goggle Sheets IMPORTXML/REGEXEXTRACT out of date

Alright, so I found my basic answer from these posts, 2-3 years ago. Extract data from Steam Import total hours on Steam Steam has updated its website since then, so I've messed around with it and ...
0
votes
2answers
49 views

Extract Information from Webpage onto Google Sheets

I've been trying to grab some data from this webpage: https://seekingalpha.com/symbol/BZUN. I want to import the follower count (under the add to portfolio button) into a cell on google sheets. For ...
1
vote
1answer
70 views

IMPORTXML not updating for unknown reason

Doing a web scrapping exercise I found that after I was able to view the table in the aim sheet with IMPORTXML the formula stopped pulling/scrapping and an #N/A tag show up in its place.
1
vote
1answer
493 views

Import Bitcoin price in EUR using the IMPORTXML fucntion

Hello does anybody know how to import the Bitcoin price in euro into a Google Sheets document by using the IMPORTXML function? I am as far as I get the Bitcoin USD price - =IMPORTXML("https://...
1
vote
1answer
785 views

Get URL from web page using IMPORTXML

Though I am new to web scraping, but I have a hand on experience of web scraping using VBA (Excel) I am facing the following problem: I have tried all methods (ImportXML, ImportHTMP, ImportData, etc.)...
0
votes
1answer
795 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
1answer
465 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 ...
0
votes
2answers
604 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 ...
3
votes
1answer
3k views

ImportXML with XPath does not return an entry of a table

Using Google Sheets with IMPORTXML to scrape a piece of information from a website via XPath. Here's the site (click here). The specific piece of information I'm trying to extract is the Price/Sales ...
1
vote
0answers
490 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/...
1
vote
1answer
2k views

Prevent importXML from spilling text across multiple columns

When importing chat transcript by importXML, e.g., =IMPORTXML("http://chat.stackexchange.com/transcript/7/2015/8/13", "//div[@class='content']") I find that some messages split across several ...
0
votes
3answers
970 views

How to match XPath for Sheets IMPORTXML formula?

New with IMPORTXML, and having trouble matching the XPath on my URL The URL is https://phlanx.com/engagement-calculator?insta=accelerateokanagan The value I am trying to extract is the orange 4.4% ...
0
votes
1answer
218 views

Unable to importxml from this URL

I am trying to fetch url using =importxml in Google Sheets, but getting error message, could not connect to url. He is the formula which I am using: =IMPORTXML("https://api.exotel.com/v1/Accounts/...
1
vote
1answer
250 views

Try to use importxml to get the GDP data from wiki, but can't make it

I want to get the US GDP data from wiki, with the following code, but can't make it. =importxml("https://en.wikipedia.org/wiki/List_of_countries_by_real_GDP_growth_rate","//*[@id='mw-content-text']/...
-1
votes
2answers
2k views

I got this “Error: Imported content is empty”

I am trying to create a google sheet to combine some information. I want the sheet to pull information h index of my friend this is the code =IMPORTXML("https://www.scopus.com/authid/detail.uri?...
0
votes
1answer
676 views

How to fetch one HTML table from a URL in Google Sheets?

I'm trying to fetch part of a single table from an HTML page into my Google spreadsheet. Been having lots of problems. importhtml() fails quite regularly (but not always) and simply displays "...
2
votes
3answers
640 views

How can I use JOIN in Google Sheets to create HTML body?

I'm using importxml to pull data from websites. So far this portion is working just fine. However, I need to join the text in these cells into one cell in HTML text that I can upload to my website. I'...
3
votes
1answer
3k views

ImportXML data reloading every time I open the sheet

I have a problem with my Google Sheets updating the IMPORTXML data every time I open my sheet. Does importxml function run every time I open Google Sheets? Is there a way of turning off this? I don't ...
8
votes
6answers
14k views

What are the refresh characteristics of the Google Spreadsheet Import functions?

The imported data is not always up to date with the source pages when I load the spreadsheet. When this happens, F5 refresh does not help. Nor does Ctl-F5. Apparently there is some kind of caching ...
-1
votes
1answer
1k views

IMPORTXML is not working properly [closed]

In my Google Spreadsheets I tried to pull out the data from booking.com. I retrieved Hotel name in column but does not work with every column. I referenced the formula correctly but it automatically ...
2
votes
1answer
1k views

Periodically updating a URL in the ImportXML command with a script

I am using importxml to extract prices from multiple websites. My main concern is to be able to refresh the prices whenever I want and not be dependent on Google's hourly update. I am using this ...
-1
votes
1answer
455 views

index(split(ImportXML formula works in a spreadsheet of mine, not in another?

=index(split(ImportXML("http://finance.google.com/finance?q=" & V9, "//td[@data-snapfield='latest_dividend-dividend_yield']/following-sibling::*"), "/"),1,2) / 100 This formula works in a ...