Google Sheets – IMPORTXML Problem Extracting from Web Page

google sheetsimportxmlxmlxpath

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 out how get those tags in IMPORTXML results. Any idea how?

I read many posts and tried :

 =IMPORTXML("https://www.mycoquebec.org/bas.php?tag=Baorangia%20bicolor", "//*")
 =IMPORTXML("https://www.mycoquebec.org/bas.php?tag=Baorangia%20bicolor", "//script")

But even if I get many results, I do not get the tags I'm looking for !!?

I also tried:

 =IMPORTXML("https://www.mycoquebec.org/bas.php?tag=Baorangia%20bicolor", "//*[@id='Comestibilité']")

Wich returns no result.

Best Answer

Google Sheets built-in funcion IMPORTXML can't access tags created by JavaScript. You could ask for a software recommendation on https://softwarerecs.stackexchange.com or look for related web scrapping programming questions on https://stackoverflow.com.

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

Code

function myGrades(range) {
  var output = [];

  // header
  output.push(["Name", "Score"]);

  // set up the proper matrix
  for(var j=2, jLen=range.length; j<jLen; j++) {
    var name = range[j][0], score = 0;
    for(var l=1, lLen=range[0].length; l<lLen; l++) {
      if(range[j][l] == range[1][l]) {
        score++;
      }
    }    
    // calculate the grade
    var grade = Math.round(score/((range[0].length-1))*100);
    output.push([name, grade + "%"]);    
  }
  return output;        
}

Usage

=myGrades(DATA!A1:E5)

Add the code under Tools > Script editor from the spreadsheet menu. In the script editor, paste the code and press the save button.

Example

I've created an example file for you: Grading Answers

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

This formula worked perfectly for me:

=IMPORTXML("http://www.toysrus.com/product/index.jsp?productId=22360626","//*[@id='price']/ul/li[2]/span")

Best Answer

Related Solutions

Google-sheets – Grading a Google Spreadsheet by answers given in a Google Form

Code

Usage

Example

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

Related Topic