This plugin for WordPress shows you how to export the URL's for all your websites posts in Google Spreadsheets format.
Download the plugin through the WordPress Plugin Repository by looking for LinkGather, also you can just go to the link below:
WordPress Repository
LinkGather WordPress Plugin
Once you have installed the plugin, you can start using it.
Instructions
A new menu item on the options side of your WordPress admin portal will appear called LinkGather:
Hover over this menu option, you will then see a sub-menu with the different sections available for you:
If you click on the Home title, this will take you to the plugins home page which supplies instructions, similar to these, on how to use the plugin.
Post Links
Push the Post Links option to take you to the page that will display all of your blog websites published posts’ URL. Be aware that for the purposes of these instructions, we are using our blog test site with just a few URL's in it.
You should now see a list with two columns, one for the title of your posts and another for the links here of your posts. Depending on 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 option to download the posts in Excel format.
Page Links
The instructions is exactly the same for Page Links, but instead of showing website back published URL, it will bring back published pages instead:
JetPack Links
The option for JetPack URLs is again exactly the same method as those above, however, JetPack Links 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 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 wp.me Links that it has gathered:
YouTube Demo
If you are still having problems using this plugin, you can view a demostration video walkthrough here: