2
votes
XPath Query to Retrieve Element Value and Name
Things to have in mind about using xPath on IMPORTXML
It supports xPath 1.0. An old version of the IMPORTXML help article mentioned the supported version; the current version points to a third-party ...
2
votes
Accepted
XPath Query to Retrieve Element Value and Name
Alternatives
Here are alternative approaches to get the data in your preferred layout:
IMPORTDATA
=IMPORTDATA(url, delimiter)
Imports from a URL in CSV or TSV format.
=LET(url, "https://home....
- 7,491
2
votes
Unable to importxml from this URL
IMPORTXML only is able to access public web resources but he URL in the formula requires user and password so it couldn't be reached.
1
vote
Pull information about each game from boardgamegeek.com
Some tools that give the xPath are able to read the DOM of the related page after it was modified but IMPORTXML is only able to read the source code of the page. In these cases, you should use another ...
1
vote
ImportXML error: 'imported content is empty' when selecting for text within a list item
Thanks for linking to How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?. For people looking for a quick ...
- 203
1
vote
ImportXML not loading due to number of requests
First thing to do is to remove the formulas that are unnecessary.
Your spreadsheet has a lot of formulas that are using the GOOGLEFINANCE built-in function that aren't necessary because they are ...
1
vote
ImportXML not loading due to number of requests
The easiest solution would be to divide your formulas in 16 spreadsheets each with 50 formulas and then just use IMPORTRANGE 16 times in your Master Spreadsheet.
Also, no need to calculate the "...
- 27.1k
1
vote
Accepted
Google Spreadsheet IMPORTXML problem to extract from a web page
Google Sheets built-in funcion IMPORTXML can't access tags created by JavaScript. You could ask for a software recommendation on https://softwarerecs.stackexchange.com or look for related web ...
Only top scored, non community-wiki answers of a minimum length are eligible