Trying to pull data using importxml

Allister Lobo 0
Viewed 27

I am trying to pull from a website that has a line of text from a <code> line using importxml. It didn't work but here's what I tried:

=importxml("https://www.apqc.org/what-we-do/benchmarking/open-standards-benchmarking/measures/employee-turnover-rate", "//div[@class='c-compute-measure__fx-include']")

Here is the section I'm pulling from:

enter image description here

google-sheets-formula google-sheets
1 Answers

When I view the source the data being put into that div tag is dynamically being calculated and isn't static. I' don't think importxml works for data like that.

frankM_DN0
Related