Google spreadsheet ImportXML Error:"the XPath query did not return any data"

google sheets importxml error loading data
google sheets to xml
importxml google sheets table
google sheets importxml refresh
importxml range
importxml imported content is empty
googlefinance importxml
google sheets importxml array

I continue to get this error when I try to run this XPath query

//div[@iti='0']

on this link (flight search from google)

https://www.google.com/flights/#search;f=LGW;t=JFK;d=2014-05-22;r=2014-05-26

I get something like this:

=ImportXML("https://www.google.fr/flights/#search;f=jfk;t=lgw;d=2014-02-22;r=2014-02-26";"//div[@iti='0']")

I verified and the XPath is correct (I get the answer wanted using XPath helper, the answer wanted are the data relative to the first flight selected).

I guess that it is a problem of syntax, but I tried more or less all the combinations of lower/uppercase, punctuation (replacing ; , ' ") and I tried to link the URI and the XPath query stored in cells, but nothing works.

Any help will be appreciated.

As a matter of fact, maybe it is a bug on the new google sheets or they have changed how the function works. I've activated mine and when I try to use the ImportXML it simply wont work. Since I have some old sheets here (on the old mechanism) they still work normally. If I copy and paste the script from the old to the new one it simply doesn't get any data.

Here a example:

=ImportXML("http://www.nytimes.com/pages/todayspaper/index.html";"//div[@class='columnGroup first']//h3")

If I run this on the old mechanism it works fine, but if I run the same on the new mechanism, first it will exchange my ";" for a "," and then it will bring a "#N/A" with a warning of "Error: Imported XML content cannot be parsed".

Edit (05/05/2015): I am happy to say that I tested this function again today on the new spreadsheets and they've fixed it. I was checking that every two months and now finally they have solved this issue. The example I've added above is now returning information.

IMPORTXML Error : sheets, IMPORTXML Error. Hello,. I am trying to import data from here onto Google Sheets. I tried the IMPORTHTML way to import the table, but the data is not structured� IMPORTXML Imported Content is Empty error. Attacks with a staff, with a 35% chance to decrease Attack for 2 turns. but it returned Imported Content is Empty error. I've used this formula successfully for other websites in the past so I'm wondering where it went wrong.

I'm sorry, but you won't be able to easily parse Google result pages. The reason your function throws an error is because the content of the page you see in your browser is generated by javascript, and Google spreadsheet doesn't execute js.

Your ImportXML has the right syntax, it doesn't return anything because the node you're looking for isn't there (importXML Parse Error).

You will have to find another source if you want these result in your spreadsheet. For info some libraries already parse the usual result page (http://www.seerinteractive.com/blog/google-scraper-in-google-docs-update for example, if it still works), but I doubt finding one for your special case will be easy.

Google Spreadsheet ImportXML Error: Imported , Incredibly odd, but the general solution for problems regarding the IMPORTXML function in the new version of Google Sheets is - use the older version. Visit the Learning Center. Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

This gives the answer (importXML Parse Error), but it's not entirely obvious.

ImportXML doesn't load Javascript. When you're building ImportXML queries on Google results, make sure you're testing against a version of the page that has Javascript turned off. You can do this using the Chrome DevTools.

(But I agree that ImportXML is fickle, idiosyncratic, and generally rage-inducing).

Why won't importxml work on this sheet?, "Error: Loading data". I didn't found something similar for Google Sheets built-in functions, so it's very I created a custom import function that overcomes all limits of IMPORTXML I have a sheet using this in about 800 cells and it works great. IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. IMPORTRANGE: Imports a range of cells from a specified spreadsheet. IMPORTFEED: Imports a RSS or ATOM feed. IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTXML error - empty table, to Google Sheets: https://vistacapital.com.br/. I used the formula: =IMPORTXML ("https://vistacapital.com.br";"//*[@id='sos-vmf']/td[2]/text()"). Learn about different error types in Google Sheets and how to correct it. Google Sheets returns an error value if formula in a cell has some kind of error.

Use Google Sheets' ImportXML function to display data in Geckoboard, Google Sheets has a built-in function called ImportXML which will import pieces of structured data from a webpage to a Google Sheet. You Google Sheets’ ImportXML function can look for a specific XML dataset and copy the data out of it. So, in the example above, if we wanted to grab all the links on a page, we’d tell our ImportXML function to import all information within the <a></a> tags.

Google Spreadsheet ImportXML Error: Imported XML - html, Google Spreadsheet ImportXML Error: Imported XML content cannot be parsed - xml. I think the problem is with the page itself, but I cannot see what Google is� The IMPORTXML formula in Google Sheets lets us import data from the structured data types like HTML and XML. It also supports data import from CSV, TSV, and RSS and ATOM XML feeds. Syntax. IMPORTXML(url, xpath_query)

Comments
  • Google uses a lot of javascript basically everywhere, and it can obviously modify significantly the base HTML. What are you using to retrieve the page? Did you check the HTML is as expected in whatever context you are trying to apply xpath from? And, btw, what is this context (language/tool...)?
  • well, I tried it with several searches, the -iti='0'- is the best way to identify this item. Anyway i tried also with a similar query from kayak and I get the same problem. I really think the issue is in the syntax of ImportXML. Regarding the context, i'm using Google Spreadsheets and I want to find the best combination of destination/location for a trip.
  • What I mean is, are you sure the HTML you receive in the spreadsheet is the same as the one you used to choose iti='0' for criteria. The output of chrome, after js execution and iframe retrieving, might be different from what the spreadsheet receives. Did you check the full page is as expected after imported in the spreadsheet? The syntax of ImportXML seems functional on other examples.
  • ok, I understand what you mean, I'm exploring the xml seen from the spreadsheet, it's actually quite different, let's see if i find something.
  • Yep I looked into it a little bit myself and it seems that the body of your webpage is almost empty, everything is generated through javascript in your browser (BTW if you're checking in chrome, F12 displays the interpreted HTML and Ctrl+U the raw code). Google doesn't like being parsed. Let me know if you find anything else but this probably is your problem.