Skip to main content

Questions tagged [importxml]

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

Filter by
Sorted by
Tagged with
2 votes
2 answers
2k 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
1 answer
105 views

Splitting siblings by different @class attributes into columns using IMPORTXML formula

I am trying to scrape sample sentences from an online Japanese dictionary using IMPORTXML in a spreadsheet. As shown on the image above, some ul descendants are categorized by 2 different span @...
1 vote
1 answer
736 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
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, ...
-1 votes
1 answer
47 views

Relative cell reference in formula doesn't change as expected when copied to a different cell

I have a working IMPORTXML formula in Google Sheets that includes a relative cell reference. When I copy the formula to another cell, I expect the relative cell reference to update but it does not. ...
0 votes
1 answer
924 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 ...
0 votes
2 answers
345 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 ...
1 vote
1 answer
316 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....
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="...
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 ...
4 votes
2 answers
28k 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 vote
1 answer
596 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/...
15 votes
2 answers
31k 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 ...
1 vote
1 answer
980 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 ...
0 votes
0 answers
70 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 ...
-2 votes
1 answer
60 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 vote
1 answer
849 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 ...
1 vote
1 answer
9k 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
1 answer
981 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 ...
0 votes
2 answers
619 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 ...
0 votes
1 answer
266 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 ...
1 vote
0 answers
333 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 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://...
-1 votes
2 answers
1k 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: ...
0 votes
1 answer
456 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 votes
1 answer
106 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. ...
2 votes
1 answer
918 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", "//") ...
1 vote
1 answer
222 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
138 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 votes
1 answer
534 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 ...
0 votes
2 answers
1k 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-...
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 ...
1 vote
1 answer
869 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 ...
1 vote
0 answers
448 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 (...
1 vote
1 answer
585 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 ...
0 votes
0 answers
80 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 ...
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 ...
2 votes
1 answer
2k 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
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 ...
3 votes
3 answers
8k 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 ...
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
12k 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
1 answer
6k 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 votes
2 answers
321 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
378 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
1 answer
462 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
1 answer
175 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
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 ...
1 vote
1 answer
129 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
1 answer
643 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-...