This plugin for WordPress shows you how to export the URL's for all your blogs articles in Google Spreadsheets design.
You can get the plugin through the WordPress Plugin Repository by searching for LinkGather, alternatively you can just go to the link below:
WordPress Repository
LinkGather WordPress Plugin
Now you have installed and activated the plugin, you can start using it.
Guide
A new tab on the options side of your admin portal will appear called LinkGather:
Hovering over this tab option, you will then see a sub-menu with the different pieces available for you:
If you click on the Home offering, this will go to the plugins home page which supplies instructions, similar to these, on how to use the plugin.
Post Links
Hit the Post Links offering to navigate you to the page that will display all of your websites published posts’ links. Be aware that for the purposes of these instructions, we are using our demo test site with just a few URLs in it.
You should 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.
Underneath the URL list, you will see that LinkGather has also added up how many post URL you have.
You then also have the option to download the posts in Google read more Spreadsheets style.
Page Links
The instructions above is exactly the same for Page Links, but instead of showing back published posts, it will bring back published pages instead:
JetPack URL's
The option for wp.me Links is again exactly the same instructions as those above, but, wp.me Links are actually built in short links created by the JetPack plugin. If you have the JetPack plugin installed, you must more info 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.
Hoping that you have JetPack short links enabled, clicking on our plugins wp.me Links tab will bring back all those JetPack URL's that it has gathered:
YouTube Demo
If you are still having problems using this plugin, you can view a demostration video walkthrough here: