As seen on - https://stackoverflow.com/questions/66755936/xpath-to-get-urls-in-google-sheet-from-xml //*[local-name()='loc'] =IMPORTXML("https://www.mangoblogger.com/wp-sitemap-posts-post-1.xml&q...
As seen on - https://stackoverflow.com/questions/66755936/xpath-to-get-urls-in-google-sheet-from-xml
//*[local-name()='loc'] =IMPORTXML("https://www.mangoblogger.com/wp-sitemap-posts-post-1.xml","//*[local-name()='loc']")