Questions tagged [importxml]
For questions specifically about the Google Sheets function: IMPORTXML()
112
questions
0
votes
2
answers
162
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 ...
- 227
0
votes
1
answer
64
views
Google Sheets: Splitting siblings by different @class attributes into columns using IMPORTXML formula
Good day, everyone! ^^
I am still a beginner in Google Sheets formulas and still don't understand many things, but I am trying to scrape sample sentences from an online Japanese dictionary using ...
- 65
0
votes
0
answers
7
views
How to get company details using Importxml from this URL? [duplicate]
I need the list of companies from here https://www.capterra.com/event-management-software/ I am trying to use the Importxml formula but there seems to be an error. Can someone pls help.
The formula I ...
- 1
0
votes
0
answers
5
views
ImportXML simple scrape [duplicate]
Trying to use a simple Google Sheets scrape to pull Google Search Queries and return the title or position of the first results linkedin. Linkedin does not allow scraping but I am wondering if that ...
- 1
0
votes
0
answers
5
views
Importing Tweet Views count into Google Spreadsheet using importXML [duplicate]
I have a Google Spreadsheet with a column of Tweet links. I'm trying to get the view count using the ImportXML formula. Could anyone help me, please?
I don't know how to use the formula precisely to ...
0
votes
0
answers
55
views
Get Ask and Bid Option Prices from Fidelity's Website Using Google Sheets
I was able to get ask/bid option prices for a particular option from Fidelity Brokerage's web site using Google Sheets and importXML - but no longer. I think the site changed.
The website to access ...
- 1
-2
votes
1
answer
56
views
Google Sheets Import XML
I'm trying to import the price from this products website: https://www.mobilesentrix.com/lcd-assembly-with-steel-plate-pre-installed-replacement-for-iphone-xr-aftermarket-aq7
But struggling to use the ...
- 1
1
vote
1
answer
599
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 ...
- 227
0
votes
1
answer
825
views
Using IMPORTXML in Google Sheets: How to Combine XML Data Sources as a Single Set Before Applying XPATH Query
Using the IMPORTXML function on Google Sheets, I've got two XML data sets at two URLs, respectively in cells A1 and A2. I've got the XPATH query in cell H1. I would like to run a single query on the ...
- 227
0
votes
1
answer
255
views
GoogleSheet's Output of IMPORTXML Function Changes Format of Imported ISO Date-Time Text
I have a GoogleSheet that's been working fine using the IMPORTXML function, until recently.
It seems that when the function imports XML data that are in ISO date and time format that it changes the ...
- 227
0
votes
2
answers
470
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 ...
- 3
0
votes
1
answer
659
views
How to use importxml to pull just one of several lists
This site has answers to a game called Spelling Bee which is published daily. I want to use importxml to pull the answers (which is a list of words) into Google Sheets, but I am a novice on this ...
- 137
1
vote
1
answer
263
views
Importing data from Investors.com, getting #N/A (google sheets) [duplicate]
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
1
answer
808
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
0
votes
1
answer
436
views
Google Sheets importxml() showing "Imported Content Empty" [duplicate]
I'm would like to fetch some information(price, address, etc.) from this website: https://www.realtor.ca/on/barrie/real-estate
using importxml function.
I'm getting a message "Imported Content ...
- 1
-1
votes
1
answer
94
views
How should I go about populating a Google Sheet with website metadata?
I am creating a table in Google Sheets that will allow me to aggregate various metrics that are relevant for a web-based company. The website has about 3000 pages, most of which are 1000+ word blogs. ...
- 1
1
vote
1
answer
198
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
votes
1
answer
480
views
How to import ALL tickers from investing.com to Google Sheets?
I waste a lot of time tumbling from one country list of stocks (on investing.com) to another looking for stocks to buy.
How can I aggregate stocks from all countries (and exchanges) to one sheet, with ...
- 1
0
votes
2
answers
951
views
How to split imported table data from web page to Headers in first row, and linked data in second row
When I use =transpose(concatenate(IMPORTXML(A1,F21))) all the table data headers & data) is imported into one cell.
Note: A1 is url:
https://wallmine.com/asx/a2m, and F21 is xPath: //div[@data-...
- 1
0
votes
0
answers
79
views
Google Sheets importxml() can't fetch from http://www.aastocks.com/ [duplicate]
I'm trying to fetch data using importxml() but it just fails with "#N/A". I have tried it on other pages and works fine. But it doesn't work on this site, and I don't know why.
Here is the ...
- 1
0
votes
0
answers
31
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 ...
2
votes
1
answer
895
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
1
vote
1
answer
511
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
0
votes
0
answers
3k
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 ...
5
votes
1
answer
11k
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
-1
votes
1
answer
5k
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","/...
- 1
0
votes
1
answer
1k
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="...
- 163
-1
votes
1
answer
360
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 ...
- 299
0
votes
1
answer
166
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
0
answers
413
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
0
votes
1
answer
1k
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, ...
- 101
1
vote
1
answer
121
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 ...
- 299
1
vote
1
answer
144
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
2
answers
1k
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
1
vote
1
answer
1k
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']")
...
- 23
1
vote
0
answers
306
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 ...
- 111
0
votes
2
answers
12k
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 ...
- 1
-1
votes
1
answer
408
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. ...
-1
votes
2
answers
299
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
1
answer
134
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....
- 11
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....
- 11
-1
votes
1
answer
152
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.
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
884
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 ...
- 37
0
votes
2
answers
121
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
1
answer
708
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.
- 13
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://...
- 13
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
2
answers
966
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
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