I built an extension for Google Sheets that allows you to import your sitemap and sitemap indexes to Google Sheet documents directly. Probably SEO executives will love this extension because they are working with sitemaps often.
If you do not want to know technical stuff you can get a copy from this link.
How to Import Sitemap?
You can see a screenshot on the right that shows you a menu in Google Sheets. When you add this extension to your google sheets workplace, you are going to be able to import sitemaps or sitemap indexes to your sheet.
It’s really simple, you will click the Load Sitemap menu item then you will see a prompt that is asking you an URL for sitemap or sitemap index.
Paste Sitemap URL
When you paste the URL you need to click the OK button. Then Google Sheet starts to process your sitemap to append the active sheet.
Wait Until Process Complete
You can see an alert that gives you information about the process. You will see this when the process is completed.
Enjoy the results
As you can see all results came from the sitemap file. These results are from my blog’s sitemap.
How to Install Sitemap Import Extension?
When you create a Google Sheet document you need to follow these steps:
Time needed: 1 minute.
How to install Google Sheets Sitemap Import Extension?
- Create a document
Create a document or open your available document.
- Find Tools Menu
Then Tools->Script Editor
Then you will see a code editor screen.
- Paste the code to the editor
You need to copy all code that I wrote below. Then paste it into the editor area in the script editor.
You can delete myFunction code block.
- Apply the changes
You can save all changes/codes with the save button. Then you’re ready to go!
The Code That You Need
I hope you enjoy this post!
See you in the next tutorial!