Questions tagged [importxml]
For questions specifically about the Google Sheets function: IMPORTXML()
114
questions
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
10
votes
6
answers
30k
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 ...
- 219
6
votes
2
answers
11k
views
How can I use Google's functions in a spreadsheet's script?
When I use a function such as =importXml("http://www.google.com", "//a/@href") in a Google Spreadsheet cell, it works just fine. However, when I try to use the same function in a script, it gives an ...
- 30.4k
5
votes
1
answer
10k
views
How to get first element of split Google Sheets
Within Google Sheets, the function
=SPLIT(IMPORTXML("url here", "//title"),"|")
returns the following:
{"Linear Algebra", "School of Mathematics", "College Name", "City Name"}
which takes up 4 cells ...
- 101
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
3
votes
2
answers
1k
views
importXML strips leading zeros in Google spreadsheet
I extract one number from an XML online file with Google Spreadsheets. Sometimes the number starts with a zero but the spreadsheet removes it. I'm sure the format of the cell is 'plain text' (I press ...
- 63
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 ...
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
3
votes
3
answers
7k
views
Import current price from website to spreadsheet
As you can probably gather from the title, the goal is to plug the current price of this product into a spreadsheet.
Perhaps I'm over-complicating things, but there must be an easy way to do this.
The ...
- 31
3
votes
1
answer
1k
views
In Google Spreadsheets the xPath method with Google Maps don't work anymore?
I've used this query to calculate distance between two locations, now it won't work anymore, and returns the error xPath query didn't get any result (translated from Italian, I don't know if is the ...
- 161
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
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
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
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
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
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
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
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:
...
2
votes
1
answer
864
views
Google Sheets IMPORTXML shows ""Meet Google Drive" one day and "#N/A" the next
I am trying to import a simple xml file into a new Google Sheet, via the importxml function:
importxml("https://drive.google.com/uc?id=1HqnptNBNn3yyjvaEVDNOpEWjegchwMpU", "//")
...
- 31
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
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
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
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.)...
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
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
2
votes
4
answers
15k
views
How to collate data in Google Spreadsheets?
I have two sheets with data in single Google Spreadsheets document:
SheetA:
Date Name CounterA
22.02.2011 Beta 101
22.02.2011 Alpha 2
21.02.2011 Alpha 1
SheetB:
Date Name ...
1
vote
1
answer
416
views
Trying to fetch data from www.csgoempire.com with ImportXML function
I am trying to fetch data from this link using Google Sheets' ImportXML function.
This is a betting site, and the link displays a list of roulette roll IDs on 26 June 2020. I am trying to fetch that ...
- 11
1
vote
1
answer
3k
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: ...
- 25
1
vote
1
answer
823
views
How to create an automatically updating Google spreadsheet with information from Steam?
How would I create an automatically updating Google spreadsheet containing information about Recent Activity in Steam?
Table must look like here:
But the hours column must automatically updating ...
- 25
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
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
2
answers
2k
views
xpath to get non-distinct parent node data for each child node
Google Spreadsheets has an IMPORTXML function, which I am trying to use to maintain a list of TV episodes, based on the API at http://services.tvrage.com/feeds/episode_list.php?sid=3183.
I am trying ...
- 113
1
vote
1
answer
493
views
Google Sheets IMPORTXML and IMPORTFEED and "Could not fetch url" Error
I'm attempting to retrieve information from this XML page into a Google Sheets workbook using the IMPORTXML function.
The following formula, which had worked before, now returns a "Could not ...
- 225
1
vote
1
answer
592
views
Using importxml to parse data from investing.com
I am trying to use the importxml to get the percentage changes data from https://www.investing.com/crypto/bitcoin.
Unfortunately, when I retrieve it with the following formula, it retrieves other ...
- 11
1
vote
1
answer
172
views
How to import Telegram post views to Google Sheet?
I have a list of Telegram post links, and I want to use a formula like IMPORTXML to automatically import their post views to Google Sheet.
I know this formula import the number of subscribers to ...
1
vote
1
answer
111
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 ...
- 11
1
vote
1
answer
2k
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://...
- 25
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
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&...
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
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
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
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
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
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
1
vote
1
answer
228
views
Importing data from Investors.com, getting #N/A (google sheets)
I am attempting to pull from https://research.investors.com/stock-quotes/nasdaq-apple-inc-aapl.htm
I want to get the EPS Rating which is the 305th list item, which I found using
var i = 1; [].forEach....
- 11
1
vote
0
answers
391
views
Getting distance between 2 postcodes using Google Maps in Google Sheets [closed]
This topic has been brought up a few times - but I've tried every option in Google Sheets but it keeps returning "Imported Content is empty" on my function
The code I'm using is below (...
- 11
1
vote
1
answer
104
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 ...
- 289
1
vote
2
answers
926
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 ...
- 25