Questions tagged [importxml]

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

0
votes
1answer
12 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
1answer
9 views

Trying to fetch data from this website 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
13 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....
0
votes
1answer
31 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
0answers
29 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
78 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
89 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
38 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
35 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
261 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://...
0
votes
1answer
83 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/...
0
votes
1answer
94 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: ...
0
votes
1answer
191 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
vote
1answer
425 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.)...
1
vote
0answers
350 views

IMPORTXML to import attribute = “Error: Imported content is empty”

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 ...
0
votes
1answer
200 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-...
0
votes
1answer
463 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
249 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
1answer
128 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
0answers
372 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
230 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 ...
1
vote
1answer
2k views

IMPORTHTML - Error, Imported content is empty

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&...
0
votes
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
1answer
46 views

Getting GDP info by using importXML from IMF webpage

I'm going to get the updated GDP info by using importXML from IMF webpage. I type in the following in the spreadsheet, but it return "N/A" Is there anything wrong with my input? =importxml("http://...
0
votes
3answers
775 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% ...
1
vote
1answer
195 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
1answer
105 views

Importxml convert content only

I am getting the price value from the website. I would like to make the value as static(remove formulas) to prevent auto refresh in sheet due to that the price values will change-- I don't want it. ...
-1
votes
1answer
47 views

Imporxml is not price the data getting syntax error

importxml is working fine with manual insert but while updating with funtions getting syntax error. Kindly help me.. how to convert string to actual query. function Getdata() { var Technicals = ...
0
votes
1answer
178 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/...
0
votes
2answers
470 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
votes
2answers
1k 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?...
1
vote
2answers
474 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
1answer
541 views

Import table using IMPORTXML

I am trying to import a table from the lower part of following website to Google Sheets: http://www.etnet.com.hk/www/tc/warrants/search_cbbc_hsi.php I used the formula: =IMPORTXML("http://www.etnet....
1
vote
1answer
331 views

ImportXML with Google Sheets is not returning the value I would like

My goal is to retrieve the "Clôture de la veille" number (90,050 €) from this webpage : https://www.easybourse.com/action-cours/renault/intraday/FR0000131906-25 In Google Sheets, when using the ...
1
vote
1answer
6k views

Error: Imported Content is Empty

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://...
2
votes
1answer
848 views

How can I IMPORTXML YouTube video count to Google Sheets?

I'm doing a Google Sheets training video on using XPATH and IMPORTXML on YouTube but YouTube seems to have updated their site and now the import option won't work for extracting total video views. ...
-1
votes
1answer
478 views

How to quote formula result?

I have a function which returns a URL from hyperlink as a first parameter to IMPORTXML function. For the function to work I need to put the output of that function in quotes, how do I do it?
-1
votes
1answer
2k views

IMPORTXML shows “array result was not expanded because it would overwrite data in the C4” error

I am able to fetch data from multiple URL's listed in a single column in Google Sheets using IMPORTHTML/IMPORTXML formula. However, when I drag the column with the formula it overwrites the existing ...
-1
votes
1answer
383 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 ...
1
vote
0answers
72 views

Function always parses column in first row but would like it to repeat

I am trying to make a function that repeats in each row of a column that fetches the URL in the first column, does an xpath query and gets an image. Currently its all working other than the fact it ...
2
votes
3answers
492 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'...
2
votes
1answer
823 views

Import a JSON query from investing.com

I've trying this for several days and I'm not able to load the data displayed below the graph in https://es.investing.com/equities/facebook-inc IMPORTHTML does not work because these fields are the ...
1
vote
1answer
2k views

Google Sheets: How can I combine multiple ImportXML results for multiple URLs into a single column? [duplicate]

I want to grab some lists of data from various pages on the web and I'm using IMPORTXML to do it. Assume I have a list of URLs in column D. Depending on the URL, the length of the results can be ...
0
votes
2answers
2k views

How to insert quote character (") as an element of URL in importXML function?

My URL contains a quote character, and Google Spreadsheets see this as the end of the URL whereas it is not. https://api.archives-ouvertes.fr/search/?fq=producedDateY_i:[2013 TO 2015]&fq=...
-1
votes
1answer
375 views

Various incorrect errors when using import functions

I'm using various import functions to pull stock data from several places. I'm using importhtml, importxml, and even some scripting with UrlFetchApp. Out of the blue, all my imports are now failing ...
-1
votes
2answers
4k 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
2answers
5k views

Google Sheets importxml() can't fetch from this URL

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 ...
0
votes
1answer
568 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 "...
0
votes
1answer
1k views

Query to Import HTML / XML Data Into Google Spreadsheets

I'm using Google Spreadsheets to retrieve a data table ('id=idp6855942304') from this site. The full sets of tables can be viewed by clicking on "All Reports" from the menus on the left side of the ...
1
vote
2answers
4k views

How to Determine the Xpath Query to a Datapoint in a Table for Use with IMPORTXML?

I'm looking to retrieve the most recent financial figure for a single data point from a table using IMPORTXML. The target page displays three sets of financial figures for a company on quarterly and ...