How to import Yoast XML sitemap to google sheets
In this tutorial, you’re going to learn how to import Yoast XML sitemap into a Google Sheet. This is pretty simple and easy.
- Paste the formula where you want the list of posts
=IMPORTXML(A1,"//*[local-name() ='url']/*[local-name() ='loc']")
- Then press enter and see the list as below.