My URL contains a quote character, and Google Spreadsheets see this as the end of the URL whereas it is not.

https://api.archives-ouvertes.fr/search/?fq=producedDateY_i:[2013 TO 2015]&fq=docType_s:"ART"&rows=0

How can I use an URL with ImportXML() that has a quote character in it?

2 Answers 2


Double the quote character, instead of " use """".

Another alternative is to put the URL alone on cell, lets say A1, then put the cell reference in your formula:


You can also encode your url. %22 is the encoded quotations:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.