I recently had an issue with a Wordpress site setup like no other that I've seen. I came in after the Wordpress site was purchased by a client. They were interested in exporting URLs from pages, posts, categories, tags, and for other miscellaneious sections that were added to the site.

Normally, it is an easy enough task from right inside Wordpress under the Tools settings > Export. The output is an XML file, which can be a pain to convert and also gives data that is useless when all you want are the URLs; hence a major cleanup.

Now, you can also use a plugin. Easy, right? On this Wordpress site: wrong. The server was at its max capacity or data limit, and won't allow the directory for the new plugin. (Good thing the owner wants to move it) So, I had to think out of the box.

Solution:

Most sites have a sitemap.xml. If you don't, you should. It is one of those things that helps SEO.

• Open your sitemap. Simple as mydomainname.com/sitemap.xml. For Wordpress, there will be several: post, page, category, tag, other sections that may be in the site.
• Open your spreadsheet application, create the tabs for the section or sections that you require.
• For each opened sitemap, copy from the bottom to top including the header row starting with URL
• Go to your speadsheet, in the top left cell, right-click Paste Special and choose Unformatted Text
• Repeat for each sitemap you need.

In Conclusion

Sometimes it takes just a little bit of ingenuity to get a problem solved! Piece of cake!