This WordPress plugin will allow you to export the URL's for all your blogs posts in Excel format.
You can get the plugin from the WordPress Plugin Repository by looking for LinkGather, alternatively you can just go to the URL below:
WordPress Download Repository
LinkGather WordPress Plugin
Now you have activated the plugin, you can start using it.
How To
A new tab on the left side of your WordPress admin portal will appear called LinkGather:
Hovering over this tab option, you will then see a sub-menu with the different options available to you:
Clicking on the Home link, this will take you to the plugins home page which has instructions, similar to these, on how to use the plugin.
Post Links
Push the Post Links title to navigate you to the page that will reveal all of your blog sites published posts’ URL's. Note that for the purposes of this guide, we are using our demo test site with just a few links in it.
You will now see a table with two columns, one for the title of your posts and another for the links of your posts. However how many posts you have will depend on how long this list will be.
At the bottom of the URL's list, you will website see that LinkGather has also calculated how many post URL you have.
You then also have the option to download the articles in Excel design.
Page Links
The above procedure is exactly the same for Page Links, but instead of showing back published URLs, it will bring back published pages instead:
JetPack ShortLinks
The option for wp.me Links is again exactly the same method as those above, however, JetPack URLs are actually built in short links created by the JetPack plugin. If you have the JetPack plugin installed, you must have the short links option also enabled for our plugin to be able to gather those URLs.
If you do not have the JetPack short links module enabled, our plugin will just pull back basic post links instead.
Hoping that you have JetPack short links enabled, clicking on our plugins wp.me Links tab will bring back all those JetPack URLs that it has gathered:
Video Demonstration
If you are still having problems using this plugin, you can view a demo video walkthrough here: