Questions tagged [importxml]

For questions specifically about the Google Sheets function: IMPORTXML()

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Pull “Fair Value” from Yahoo Finance to Google Sheet using XPath?

Currently, I am using xPath to grab Ex-Div date, Dividends, etc but I cannot seem to be able to grab the Fair Value "Undervalue" rating from Yahoo Finance. I want the "Undervalue" to be specific but ...
2
votes
1answer
1k 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 ...
0
votes
1answer
432 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 ...
0
votes
0answers
26 views

Loop through array from importxl in google sheets?

I want to scrape this website[1] for dividend payouts and payout dates (called "utdelningar") in the right lower part. Using the following importxml[2] i get the entire list of dates etc that i want ...
0
votes
2answers
8k views

Google Sheets, 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 "...
0
votes
2answers
1k 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 ...
3
votes
3answers
4k 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. ...
0
votes
1answer
148 views

Google Sheets: word count for a webpage content (url) for SEO

For SEO analysis, I am using Google Sheets to extract basic data from my own webpages. I am able to access page title, description, <h1> tags, or number of characters via LEN(): =IMPORTXML(A3, ...
0
votes
0answers
35 views

Extracting the price from an external page using IMPORTXML on Google Sheets?

I am running a Google Sheet and I want to extract the price of Bitcoin from a site called CoinMarketCap. The site is quite simple as is mainly a listing, and have a table full of different ...
0
votes
1answer
123 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 ...
-1
votes
1answer
97 views

Google Sheets ImportXML //div[@class= is not working

I am trying to scrape the div "tech-name" from this website https://www.whatruns.com/website/bestbuy.com with the following formula =index(importxml("https://www.whatruns.com/website/bestbuy.com","/...
0
votes
0answers
27 views

xPath_query from IMPORTXML in Google sheets ends up empty

So, in these covid19-infested days I want to update our digital signage with the current situation. Want to use google sheets and IMPORTXML to fetch data from a website that is frequently updated with ...
0
votes
1answer
63 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="...
0
votes
0answers
22 views

Creating a Table in Google Sheets from XML Output with Multiple Children Levels

How to create a table in Google Sheets from an XML output with multiple children levels? I'm trying to create a table in Google Sheets with data sourced from an XML output. The XML source is here. ...
1
vote
2answers
952 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. ...
0
votes
1answer
107 views

Trying to fetch data from shopback.com.au with ImportXML function in google sheet

I am trying to fetch store name and cashback percentage from this website using google sheet's importxml function. Put following commands with no success. Please help =importxml("https://www....
1
vote
2answers
834 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://...
-1
votes
2answers
103 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=...
-1
votes
1answer
49 views

Web App get url not working from IMPORTXML

My goal is to get data into my spreadsheet from my script that mimicks the way IMPORTXML works. I want to return html from my script and consume it with IMPORTXML. It's disabled now, but at the time ...
-1
votes
1answer
92 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. ...
0
votes
1answer
23 views

IMPORTXML not working [duplicate]

I’m trying to scrap prices from various e-commerce site. However the IMPOrtxml function is not working For instance, https://shopee.sg/Ice-Silk-2019-Men-Underwear-Cool-Breathable-Comfortable-Sport-...
1
vote
2answers
116 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 ...
1
vote
1answer
31 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 ...
-1
votes
1answer
414 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-...
2
votes
2answers
5k 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 ...
0
votes
2answers
7k 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
vote
1answer
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://...
1
vote
1answer
2k 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
1answer
45 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 ...
-1
votes
1answer
300 views

Having syntax trouble with IMPORTXML Google Sheets function

I have been studying the various IMPORTXML examples posted however I have not been able to solve for the actual data I wish to pull in to my sheet. The page is here: https://aemo.com.au/Electricity/...
0
votes
0answers
29 views

Google Sheets ImportHTML formula not pulling table I need [duplicate]

I have a Google Sheet trying to pull website table using ImportHTML formula to get a table from https://mesowest.utah.edu/cgi-bin/droman/raws_ca_monitor.cgi?state=AZ&rawsflag=3 ImportHTML(https:...
0
votes
0answers
31 views

How to find the original source to get the xPath

I'm trying to get an updating list from a store on Taobao.com I've tried using importxml to get the list using xpath but I keep getting "import content is empty" error. =IMPORTXML("https://...
1
vote
1answer
177 views

ImportXML With Line Breaks Google Sheets

I am using ImportXML to get some data from a website which looks like the following: =ImportXML("https://www.papercall.io/events?cfps-scope=&keywords=uk","//div[@class='panel panel-default']") ...
0
votes
3answers
453 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/...
1
vote
0answers
34 views

Google Sheets' IMPORTXML pulling from the wrong region

I'm using IMPORTXML to get the price of an electronics component from Mouser: If the prices are refreshed as a result of me editing the spreadsheet, it requests from my computer, and results in the ...
-1
votes
1answer
320 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
1answer
36 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....
-1
votes
1answer
93 views

IMPORTHTML - Can't find specific table on WNBA.com

https://www.wnba.com/stats/team-stats-advanced/#?Season=2018 Is the web page. I can't seem to find the table for advanced team rates or opponent.
0
votes
1answer
1k 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
0
votes
0answers
71 views

How to fetch data in Google sheet using Import XML function with Xpath?

https://www.monito.com/send-money/australia/india/aud/inr/1000 Please open the URL and see what Query should I put to extract following data (=IMPORTXML("https://www.monito.com/send-money/australia/...
0
votes
1answer
614 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://...
1
vote
1answer
319 views

Goggle Sheets IMPORTXML/REGEXEXTRACT out of date

Alright, so I found my basic answer from these posts, 2-3 years ago. Extract data from Steam Import total hours on Steam Steam has updated its website since then, so I've messed around with it and ...
0
votes
2answers
60 views

Extract Information from Webpage onto Google Sheets

I've been trying to grab some data from this webpage: https://seekingalpha.com/symbol/BZUN. I want to import the follower count (under the add to portfolio button) into a cell on google sheets. For ...
1
vote
1answer
160 views

IMPORTXML not updating for unknown reason

Doing a web scrapping exercise I found that after I was able to view the table in the aim sheet with IMPORTXML the formula stopped pulling/scrapping and an #N/A tag show up in its place.
2
votes
1answer
2k 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.)...
0
votes
1answer
1k 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 ...
0
votes
1answer
584 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 ...
0
votes
2answers
740 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 ...
3
votes
1answer
4k 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 ...
1
vote
0answers
656 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/...