This plugin for WordPress will allow you to export the URLs for all your websites posts in Google Spreadsheets design.
You can download the plugin from the WordPress Plugin Repository by looking for LinkGather, alternatively you can just go to the link below:
LinkGather - WordPress Repository
LinkGather WordPress Plugin
When you have installed the plugin, you can go ahead and use it.
Step by Step Guide
A new tab on the left side of your WordPress admin console will appear called LinkGather:
When you hover over this title option, you will then see a sub-menu with the different options available for you:
Click on the Home offering, this will take you to the plugins home page which includes instructions, similar to these, on how to use the plugin.
Post Links
Click the Post Links option to move you to the page that will reveal all of your websites published posts’ links. Be aware that for the purposes of this instruction, we are using our WordPress test site with just a few URL's in read more 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.
At the export JetPack shortlinks bottom of the URL table, you should see that LinkGather has also added up how many post URLs you have.
You then also have the option to download the articles in Google Spreadsheets design.
Page Links
The above procedure is exactly the same for Page Links, however instead of showing back published links, it will bring back published pages instead:
JetPack URL's
The option for JetPack URL's is again exactly the same instructions as those above, however, JetPack URL's 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 links.
If you do not have the JetPack short links click here 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 option will bring back all those JetPack ShortLinks that it has gathered:
Video Demonstration
If you are still having problems using this plugin, you can view a demostration video walkthrough here: