Importing sitemap into your google sheets can save a lot of time in terms of copy pasting and processing. Fortunately, in excel you can import your sitemap automatically without any hassles.
Steps to import sitemap into sheets-
- Create a new google sheet.
- Enter the sitemap URL. You can find your sitemap at yourwebsite/sitemap.xml
![[IMPORT XML] | How to import sitemap into Excel or Google sheets 1](https://i0.wp.com/www.aozata.com/wp-content/uploads/2019/11/sitemap.png?resize=598%2C269&ssl=1 "[IMPORT XML] | How to import sitemap into Excel or Google sheets 3")
- Copy one of the pages, or post sitemap URLs into the excel sheet. For example, https://www.aozata.com/post-sitemap.xml and paste it into a cell.
- Paste the following formula into another cell. (this will work if you are using the yoast sitemap).
=IMPORTXML(C4,"//*[local-name() ='url']/*[local-name() ='loc']")
- If your sitemap, URL is in C4, then the above formula will get the sitemap URLs in C5 and the below columns.
- Here is a link to the SITEMAP IMPORT XML feature.
[IMPORT XML] | How to import sitemap into Excel or Google sheets
![[IMPORT XML] | How to import sitemap into Excel or Google sheets 2](https://i1.wp.com/www.aozata.com/wp-content/uploads/2019/07/import-xml-to-google-sheets.png?fit=300%2C162&ssl=1 "[IMPORT XML] | How to import sitemap into Excel or Google sheets 5")
Importing sitemap into your google sheets can save a lot of time in terms of copy pasting and processing. Fortunately, in excel you can import your sitemap automatically without any hassles.
Product In-Stock: Available