Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [importxml]

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

0
votes
1answer
24 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
35 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
0answers
156 views

“Imported content is empty” error when using IMPORTXML for loading an auto-refresh list to Google Sheets

I'm trying to import data from a table that shows the most recent active calls made to the Orange County Sheriff's Office. The table refreshes every 60 seconds. The table: https://www.ocso.com/calls-...
1
vote
0answers
47 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
74 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
522 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
1answer
588 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
21 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
368 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
79 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
39 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
40 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
75 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
326 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
571 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
0answers
154 views

importxml on coinmarketcap is empty?

I cannot get importxml to work with Circulating Supply, I receive an error "Imported content is empty" =IMPORTXML("https://coinmarketcap.com/currencies/xplay/" , "/html/body/div[4]/div/div[1]/div[4]...
1
vote
1answer
294 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....
0
votes
0answers
20 views

Problems to extract some data [duplicate]

I'd don't understand why I can extract some data, using Google =IMPORTXML function, but I cannot some other data. Probably the Xpath address is not totally correct. I don't know. This is the URL of ...
1
vote
1answer
160 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
3k 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
457 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
178 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
1k 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
186 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
59 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
236 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
559 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
1k 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
717 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
295 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
2k 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
3k 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
415 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
2k 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 ...
3
votes
1answer
634 views

Using Google Spreasheet's IMPORTXML Function to Download Selected Multiple Columns

I use Excel's XML mapping to download RSS feeds and select elements to display in column. I'm currently using Google Spreadsheet's IMPORTXML functions and trying to recreate my below Excel results. ...
2
votes
2answers
2k views

Using ImportXML to pull HTML tags along with data

Can ImportXML be used to pull the HTML tags along with the data? For example: importxml(A1,"//div[@id='qlist-wrapper']") on stackoverflow.com will pull all the data in the div with the id qlist-...
2
votes
1answer
251 views

Present importXML output in reverse order

How to reverse the order of the output of imporxml? For example, =importxml("http://example.com","//p") outputs +---+---------------------+ | 1 | This domain is ... | | 2 | More information... | +--...
1
vote
1answer
1k 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 ...
2
votes
1answer
1k 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 ...
1
vote
1answer
280 views

How can I extract the price using importxml from an AngularJS site?

I need to extract the price from this website using importXML on Google Spreadsheets. Here is a product https://en-sa.wadi.com/apple-iphone-6s-16-gb-4g-rose-gold-with-facetime-61616.html The issue ...
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
vote
0answers
1k views

How can I decrease IMPORTXML refresh interval to 10 mins?

I have a couple of IMPORTXML’s fetching the prices for products, and I want the sheet to update the prices every 10 mins. I tried now() and a functions script but to no avail. What is the best way to ...
1
vote
1answer
1k views

ImportXML formula no longer working

Here is the formula: =ImportXML("http://www.bloomberg.com/quote/7501:JP", "//div[@class='price-container down']//div[@class='price']") As of several days ago, this formula stopped working. Why could ...
2
votes
2answers
182 views

How to recombine text into one line in Google Sheets

=index(ImportXml("https://www.google.com/finance?q=ibm", "//div[@class = 'companySummary']" ),0,1) Put that anywhere in a Google sheet and it will give you a cell with a block of text. This text is ...
1
vote
1answer
2k views

IMPORTXML Google Spreadsheet Amazon review numbers

I am making a spreadsheet which requires me to have the number of amazon reviews of a product. I looked up how to dynamically update the reviews as more came in and came across the IMPORTXML formula. ...
0
votes
0answers
62 views

Import site URLs to Google Sheet (and add new row each time)

I am trying to make a list of site pages that will automatically update in Google Sheets, while keeping the full history rather than overwriting older rows with new ones. I see two possible ways of ...
3
votes
1answer
2k 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 ...
2
votes
1answer
513 views

Extracting GICS codes from Fidelity website

This is the website: https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols=aapl&type=o-NavBar I'm trying to pull out the following two pieces of data into a Google Sheet: ...
1
vote
1answer
1k views

How to create an auto updating Google spreadsheet with information from Steam?

How would I create an automatically updating Google spreadsheet containing information about Recently Played in Steam? Table must look like here: A2 taking information about account name from here: ...