Questions tagged [importxml]
For questions specifically about the Google Sheets function: IMPORTXML()
17
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3
answers
2k
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/...
- 101
-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. ...
