This plugin for WordPress will allow you to export the URL's for all your blogs posts in Google Spreadsheets style.
Download the plugin through the WordPress Plugin Repository by looking for LinkGather, also you can just go to the address below:
WordPress Download Repository
LinkGather WordPress Plugin
Now you have installed the plugin, you can start using it.
How To Guide
A new link on the options side of your admin console will appear called LinkGather:
Hover over this tab option, you will then see a sub-menu with the different options available to you:
When you click on the Home offering, this will take you to the plugins developer page which includes instructions, similar to these, on how to use the plugin.
Post Links
Hit the Post Links offering to take you to the page that will show all of your blog sites published posts’ URL's. Be aware that for the purposes of these instructions, we are using our demo test site with just a few links in it.
You will 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 should see that LinkGather has also added up how many post links you have.
You then also have the option to download the posts in Google Spreadsheets format.
Page Links
The instructions is exactly the same for Page Links, however instead of supplying back published articles, it will bring back published pages instead:
JetPack URL's
The option for wp.me Links is again exactly the same procedure as those above, however, JetPack Links 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.
Assuming that you have JetPack short links enabled, clicking on click here 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 demostration video walkthrough here: