Home > Software engineering >  IMPORTXML returning #NA [resource at url not found] and #NA [imported content is empty] in Google sh
IMPORTXML returning #NA [resource at url not found] and #NA [imported content is empty] in Google sh

Time:07-20

I've been working on a google sheet that uses IMPORTXML to extract multiple data from different URLs in column N of same sheet. most of the data are imported correctly in the required cells but some cells are returning #NA [resource at url not found] and some are returning #NA [imported content is empty] I've tried all I can to no avail.

This is one of the formulas returning #NA [resource at url not found]. It is supposed to import kategoria from enter image description here

  • In this case, when the value of kategoria is not found, the empty value is returned.

Note:

  • In this sample formula, your provided URLs are used. So, when you use other URLs, this sample formula might not be able to be used. Please be careful about this.

  • From your question of It is supposed to import kategoria from URL, this sample formula retrieves the value of kategoria. So, when you want to retrieve other values, please post it as a new question.

Reference:

  • Related