Import xml sitemap data into Google Sheets

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']")