This WordPress plugin will allow you to export the URLs for all your blogs posts in Google Spreadsheets format.
Get the plugin from the WordPress Plugin Repository by searching for LinkGather, alternatively you can just go to the URL below:
WordPress Repository
Download LinkGather
Once you have installed the plugin, straight away you are ready to go.
Walkthrough
A new tab on the menu side of your WordPress admin portal will appear called LinkGather:
When you hover over this tab option, you will then see a sub-menu with the different offerings available for you:
If you click on the Home option, this will take you to the plugins homepage which includes instructions, similar to these, on how to use the plugin.
Post Links
Click the Post Links menu to take you to the page that will display all of your blog websites 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 should now see a list with two columns, one for the title of your posts and another for the links of your posts. Depending on how many posts you have will depend on how click here long this list will be.
At the bottom of the link table, you will see read more that LinkGather has also added up how many post URL you have.
You then also have the option to download the articles in Excel format.
Page Links
The procedure above is exactly the same for Page Links, however instead of supplying back published posts, it will bring back published pages instead:
JetPack ShortLinks
The option for wp.me Links is again exactly the same method 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.
Hoping that you have JetPack short links enabled, clicking on our plugins wp.me Links menu will bring back all those wp.me Links that it has gathered:
YouTube Demo
If you are still having problems using more info this plugin, you can view a demostration video walkthrough here: