This plugin for WordPress will allow you to export the links for all your blogs posts in Excel format.
Get the plugin through the WordPress Plugin Repository by looking for LinkGather, also you can just go to the link below:
LinkGather - WordPress Repository
LinkGather
When you have installed and activated the plugin, you can start using it.
Walkthrough
A new tab on the menu side of your WordPress admin console will appear called LinkGather:
When you hover over this tab option, you will then see a sub-menu with the different pieces available for you:
When you click on the Home title, this will go to the plugins developer page which supplies instructions, similar to these, on how to use the plugin.
Post Links
Hit the Post Links title to move you to the page that will display all of your blogs published posts’ URL. Be aware that for the purposes of these instructions, we are using our blog read more test site with just a few URLs in it.
You should now see a list 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.
Underneath the link table, you will see that LinkGather has also calculated how many post URLs you have.
You then also have the ability to download the posts in Google Spreadsheets design.
Page Links
The above procedure is exactly the same for Page Links, but instead of bringing back published articles, it will bring back published pages instead:
JetPack URLs
The option for JetPack URL's is again exactly the same procedure as those above, but, JetPack ShortLinks are actually built in short links created by the JetPack software. 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 URL.
If you do not have the JetPack short links module enabled, our plugin will just pull back basic post links instead.
Assuming that you have JetPack short links enabled, clicking on our plugins wp.me Links menu will bring back all those JetPack URL's that it has gathered:
Video Demo
If you are still having problems using this plugin, you can view a demo video walkthrough here: