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
Hello I'm Patrick Coombe and I'm the CEO and Founder of Elite Strategies, an agency I started in 2009. One of the main reasons I love blogging about SEO is the research it takes to come up with the posts. It allows me to not only write about what I love, but to learn more about the industry in the process. I hope you enjoyed this post, if you did consider sharing it or even better linking to it!
Blog Search SEO

Leave a Reply

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

Contact Info

2240 Woolbright Road Suite 404
Boynton Beach, FL 33426

Phone: 561-526-8457
Fax: 561-526-8707