How to import Yoast XML sitemap to google sheets

How to imprt Yoast XML sitemap into 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.

Step:

  1. https://nerodev.com/post-sitemap.xml
  2. Paste the formula where you want the list of posts
    =IMPORTXML(A1,"//*[local-name() ='url']/*[local-name() ='loc']")
  3. Then press enter and see the list as below.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *