Import all URLs in a sitemap instantly in Google sheet

=IMPORTXML(“https://www.mysite/sitemap.xml”, “//*[local-name() =’url’]/*[local-name() =’loc’]”)

Sublime Google Sheets trick 👌- import all URLs in a sitemap instantly using:

=IMPORTXML("https://www.mysite/sitemap.xml", "//*[local-name() ='url']/*[local-name() ='loc']")#SEO #Analysis

— Steph Whatley (@SEOStephW) August 27, 2020