This plugin for WordPress will allow you to export the links for all your blogs articles in Google Spreadsheets style.
Get the plugin through the WordPress Plugin Repository by searching for LinkGather, also you can just go to the address below:
WordPress Repository
LinkGather
Once you have installed and activated the plugin, you are ready to start using it.
Guide
A new tab on the left side of your WordPress admin console will appear called LinkGather:
Hovering over this menu option, you will then see a sub-menu with the different offerings available to you:
When you click on the Home offering, this will take you to the plugins homepage which supplies instructions, similar to these, on how to use the plugin.
Post Links
Click the Post Links menu 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 demo test site with just a few URLs in it.
You will now see a table with two columns, one for the title of your posts and another for the links of your posts. Depending on how many posts you read more have will depend on how long this list will be.
Underneath the URL's table, you should see that LinkGather has also calculated how many post URLs you have.
You then also have the ability to download the articles in Google Spreadsheets format.
Page Links
The instructions above is exactly the same for Page Links, but instead of supplying back published articles, it will bring back published pages instead:
JetPack ShortLinks
The option for JetPack URLs is again exactly the same procedure 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 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 demo video walkthrough here: