Questions tagged [xpath]

XPath is a language for addressing parts of an XML document that can be used by some web apps like Google Sheets to import structured data.

Filter by
Sorted by
Tagged with
0 votes
2 answers
248 views

XPath Query to Retrieve Element Value and Name

Using the IMPORTXML function in Google Sheets, I'm trying to get the 'properties' element values from this link to appear with their element names as column headers. Using the below XPath query ...
Catalyx's user avatar
  • 227
0 votes
2 answers
580 views

Google Sheets IMPORTXML Issue about Currencies

I've used these link and formula on Google Sheets to auto-update currency: =IMPORTXML("https://tr.investing.com/currencies/gau-try";"//*[@id='last_last']") However, it doesn't ...
Caghkan's user avatar
0 votes
0 answers
33 views

Using importXML in in Google Sheets to pull data under a "b class" [duplicate]

Looking at this page: https://www.mycryptobuddy.com/BitcoinMiningCalculator/path?hashrate=110&powerCost=0.059&power=3250&hardwareCost=4050 There is a line that says "Profitable in 10 ...
xylophone's user avatar
0 votes
0 answers
301 views

How to separate direct sibling elements into different columns?

So basically I'm trying to import a list of values from a certain web-page into my spreadsheet and I'm stuck. I want to make a list of names with their corresponding number stages next to them, all ...
Blind City's user avatar
0 votes
1 answer
2k views

ImportXML error: 'imported content is empty' when selecting for text within a list item

I want to scrape a text within this website in google sheets with the IMPORTXML function. Through dev tools by inspecting the text in question, I get the corresponding HTML: <li _ngcontent-udl-c4="...
jlo's user avatar
  • 193
0 votes
2 answers
13k views

ImportXML not loading due to number of requests

I am working on this sheet and it has a lot of ImportXML requests between columns N-Q. And because of the high number of requests, it seems like the ImportXML function is not working properly (it ...
Batman's user avatar
  • 1
-1 votes
1 answer
443 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
James Blake's user avatar
-1 votes
2 answers
310 views

Get translation using Google Sheets and IMPORTXML

I want to scrap the phonetic guide for a translation in Google Translator using Google Sheets. For instance, if you enter the page: https://translate.google.com/#view=home&op=translate&sl=...
Marcos Martínez's user avatar
1 vote
1 answer
49 views

I am looking to fetch a table from a website in Google Sheets

I want the first table on this URL https://www.cashbackmonitor.com/cashback-store/amazon/ in my google sheet. When I put this function (below), I can retrieve the first column of the first table e.g....
Rakesh's user avatar
  • 11
1 vote
2 answers
4k views

Import Bitcoin price in EUR using the IMPORTXML fucntion

Hello does anybody know how to import the Bitcoin price in euro into a Google Sheets document by using the IMPORTXML function? I am as far as I get the Bitcoin USD price - =IMPORTXML("https://...
Mr.Man's user avatar
  • 13
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 ...
Joe Vanni's user avatar
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/...
Mateo Marty's user avatar
1 vote
1 answer
584 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/...
Rohu's user avatar
  • 11
1 vote
1 answer
8k 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://...
atomiczap's user avatar
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 ...
lommaj's user avatar
  • 111
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 ...
JVC's user avatar
  • 1,236
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 ...
Catalyx's user avatar
  • 227
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 ...
Catalyx's user avatar
  • 227
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. ...
Catalyx's user avatar
  • 227
2 votes
1 answer
915 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... | +--...
user avatar
1 vote
1 answer
5k 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 ...
user avatar
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 ...
thanks_in_advance's user avatar
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: ...
thanks_in_advance's user avatar
0 votes
1 answer
431 views

Unable to import pricing info from toysrus.com into a Google Spreadsheet

I'm trying to pull live pricing from a given toysrus.com item into a Google Spreadsheet (one item/price per row), and am having no luck whatsoever. Importxml(url, xpath) does not work (similar to the ...
Shane's user avatar
  • 1
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 ...
jimbobmcgee's user avatar
-1 votes
1 answer
4k views

Google Docs ImportXML can't scrape anymore?

ImportXML lets you get information from filetypes such as xml, html, csv, tsv, as well as RSS and Atom feeds. This example in Google Docs Help for importXml function - =importXml("toysrus.com";; "/...
mvark's user avatar
  • 2,867
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 ...
vitto's user avatar
  • 161