How To extract URLs of Sitemap in Google Sheets?
How to simply get all the URLs of your sitemaps in a Google sheet without any help of a tool.
It's the best SEO hack with Google Sheet you have ever seen.
Now you can extract all the URLs in the sitemap using Google sheet with just a formula.
But How? 🤔🤔
1) Open Google sheets
2) Go-To Tools
3) Go To Script Editor
4) Add A script mentioned below
The script is mentioned in the blog - [ Ссылка ]
5) Run The Script
6) Now go back to the sheet and put the sitemap URL in one tab. eg abc.com/sitemap.xml
7) In another tab use the formula =getsitemap(cell number)
It will automatically extract all the URLs of the sitemap.
If you find this helpful then kindly share and do like and comment.
Do subscribe to my youtube channel!
#searchengineoptimization #seotechniques #seo #seotipsandtricks #seotips #seotips2021
#searchengineoptimizationseo #searchengineoptimizationtips #seotricks #seotricks2021 #seowithexcel #searchengineoptimisationexpert #searchengineoptimisation
![](https://i.ytimg.com/vi/owrXiO78l5s/maxresdefault.jpg)