Questions tagged [importxml]
For questions specifically about the Google Sheets function: IMPORTXML()
114
questions
-1
votes
2
answers
843
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
1
answer
8k
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
- 21
2
votes
1
answer
5k
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
votes
1
answer
635
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
0
votes
1
answer
4k
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 ...
- 13
0
votes
1
answer
760
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 ...
2
votes
0
answers
1k
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/...
- 21
1
vote
1
answer
706
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 ...
- 11
1
vote
1
answer
3k
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&...
14
votes
2
answers
26k
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 ...
- 43.4k
0
votes
1
answer
103
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://...
- 21
0
votes
3
answers
2k
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% ...
- 648
1
vote
1
answer
390
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']/...
- 21
-1
votes
1
answer
196
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
1
answer
75
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 = ...
1
vote
1
answer
513
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/...
- 11
0
votes
2
answers
1k
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
-1
votes
2
answers
8k
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?...
2
votes
2
answers
2k
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.
...
Jake Havenridge
1
vote
1
answer
899
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
1
answer
846
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 ...
- 113
1
vote
1
answer
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://...
- 11
2
votes
1
answer
2k
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.
...
- 21
-1
votes
1
answer
874
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?
- 19
-1
votes
1
answer
5k
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
1
answer
685
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
0
answers
80
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 ...
- 111
2
votes
3
answers
2k
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'...
- 35
2
votes
1
answer
2k
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 ...
- 23
2
votes
1
answer
6k
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 ...
- 223
0
votes
2
answers
7k
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=...
- 63
-1
votes
1
answer
546
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,183
4
votes
2
answers
27k
views
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 "...
- 1,183
0
votes
2
answers
11k
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,183
0
votes
1
answer
2k
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 "...
- 1,183
0
votes
1
answer
3k
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 ...
- 225
1
vote
2
answers
6k
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 ...
- 225
3
votes
1
answer
2k
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.
...
- 225
2
votes
2
answers
5k
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-...
- 153
2
votes
1
answer
864
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... |
+--...
user79865
1
vote
1
answer
4k
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 ...
user79865
3
votes
1
answer
5k
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 ...
- 153
2
votes
1
answer
661
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 ...
- 51
2
votes
1
answer
2k
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 ...
- 51
1
vote
0
answers
3k
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 ...
- 51
1
vote
1
answer
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 ...
- 11
3
votes
2
answers
3k
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,004
1
vote
1
answer
7k
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.
...
- 105
3
votes
1
answer
6k
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
1
answer
1k
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:
...