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:
Download your sitemap file by doing a “save as” when you are on the page. For instance if your website is http://www.example.com go to http://www.example.com/sitemap.xml and hit “save as”
Open up your sitemap.xml file in Micorosoft Excel or some other spreadsheet program (untested)
Highlight the column of URLS. This is normally the first column.
Paste into notepad or a plain text editor of your choice.
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.
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!
We've wondered this for a long time. I mean, Google does a pretty good job of indexing videos, especially those already on Youtube. The main purpose to a video sitemap is it allows Google to read the meta-content associated with the video. Google can't read a video, kind of like…
If you've ever been involved in making a website "live" then you know this can be an arduous process. Developers get nervous, project managers get finicky, and clients are generally about one step away from pulling their hair out. In an attempt to mitigate some of this stress, we've developed…
Beginning an SEO contract with a customer is the beginning of a trusting relationship. In addition to the fact that your customer has just handed you a wad of cash, they also are handing over the keys to their website. I know for me personally, any time I give out…