I'm working on a google sheet that will import info from Airdna.co but when I try to use the =IMPORTXML I run into a problem because it has double quotes inside.

Here is the formula I'm trying to use:

=IMPORTXML(B2,"//*[@id="app"]/section/div[2]/div/div/div/div/div[2]/div/div[1]/div[1]/div[1]","en-US")

This formula won't work because the starting quotes are ended at "app" but I need the whole XPath contained in " ".

I've tried to use =CONCAT to build the XPath the way I want it but I'm still kinda new to XPATH and haven't found a solution to this yet.

CodePudding user response：

This site https://www.airdna.co/vacation-rental-data/app/us/oregon/portland/overview uses javascript, so you won't be able to use the native function like importxml.

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data

CodePudding user response：

use single-quotes:

=IMPORTXML(B2,"//*[@id='app']/section/div[2]/div/div/div/div/div[2]/div/div[1]/div[1]/div[1]","en-US")