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.
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.
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…