How To Convert Sitemap.xml to TXT

From time to time, we as SEO’s need to generate a list of every URL on your site.  Most of the time this is to do some sort of audit on your URLs, paste them into a text editor to work with in some other way, etc.

A lot of people download the sitemap.xml file and aren’t sure what program to open it up with.  If you open it in notepad you have your URL’s surrounded with all sorts of tags that makes it really difficult to work with.  Below we will outline as well as show you in a video, the best way to convert a sitemap.xml file to a plain text document.

Without further delay, here are a few simple steps to convert an xml sitemap to a txt file:

  1. Download your sitemap file by doing a “save as” when you are on the page. For instance if your website is go to and hit “save as”
  2. Open up your sitemap.xml file in Micorosoft Excel or some other spreadsheet program (untested)
  3. Highlight the column of URLS. This is normally the first column.
  4. Paste into notepad or a plain text editor of your choice.
  5. Save, preferably as a TXT document…and you are done!

Doesn’t get much easier than that, does it!

For MAC users, the directions don’t get much different than that other than the small details.

Patrick Coombe
Patrick Coombe is the founder and CEO of Elite Strategies Llc. Patrick takes a hands on approach to managing Elite Strategies and loves to get involved with technical projects relating to clients inbound marketing needs.
Patrick Coombe
Patrick Coombe
Blog Search SEO

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Info

2240 Woolbright Road Suite 206
Boynton Beach, FL 33426

Phone: 561-526-8457
Toll Free: 855-353-8730
Fax: 561-526-8707