3 Ways to Extract URLs from Sitemaps

[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:

  1. Google Sheets
  2. Screaming Frog
  3. Terminal

Let’s jump right into it.

1) Extract URLs From XML Sitemaps Online In Google Sheets

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.

Import sitemap urls google sheets

2) Extract URLs From XML Sitemaps with Screaming Frog

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!

Import sitemap urls screaming frog

3) Extract URLs From XML Sitemaps with command line tools

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!

Extract Sitemap URLs with Terminal

I hope you find it useful.

Popular posts like this

SEO Python
Free SEO Tools
1 reply

Comments are closed.