If you are looking for an easy solution on how to import sitemap into google sheets or excel, you are in the right place.
In this guide, you will come to know how to import sitemap into google sheets.
Step by step guide on how to import sitemap into google sheets
Step 1: Create Google sheet or a new sheet in an existing spreadsheet. Then copy and paste the sitemap url in a cell. Below, you can see I have copied the sitemap url of my posts.
Step 2. Now copy and paste the formula given below in another cell. Here I am going to paste the formula in cell B3.
=IMPORTXML(D4,"//*[local-name() ='url']/*[local-name() ='loc']")
Step 3: Now you need to replace the cell no of the formula and it should be the cell no of your sitemap link. Here it is B2. So, I need to replace D4 of the formula to B2. After that, you will find that your sitemap is imported to the Google Sheet.
Need a video tutorial for this process? No worries, we have got you covered.
Read Also: How To Insert Date In Google Sheet