
Copyright © 2021 Mario Lambertucci
[Last update: 12/2020]
If you are wondering how to extract sitemap URLs really fast you are in the right place!
There are different options out there and I selected the best 3 methods:
Let’s jump right into it.
I found a simple sitemap url extractor script that will extract the list of URLs in less than 5 seconds, pretty impressive, isn’t it? Give it a try.
Here the Google Sheet that act as a sitemap url extractor:
1. Make a copy of it
2. Add the sitemap URL in the cell B2 (example: https://www.google.com/sheets/sitemaps.xml)
3. The list of URLs will appear automatically in column D
4. Done! You have just converted your sitemap to a URL list.
For this second method you need to install the SEO software Screaming Frog to convert any sitemap xml to a url list. This method works pretty well also for sitemap index file that are the ones that contain list of sub-sitemaps.
Here the steps:
1. Open Screaming Frog SEO Spider Tool
2. Mode>Select List
3. Upload>Download Sitemap>Add Sitemap xml URL
4. Done!
1. Open your terminal
2. Enter this command (remember to replace the sitemap URL)->
curl -s https://www.google.com/sheets/sitemaps.xml
3. Done!
I hope you find it useful.
Comments are closed.