This plugin for WordPress will allow you to export the web addresses for all your websites posts in Excel format.
Get the plugin from the WordPress Plugin Repository by looking for LinkGather, also you can just go to the address below:
WordPress Repository
LinkGather for WordPress
Once you have installed and activated the plugin, you can go ahead and use it.
Instructions
A new tab on the left side of your admin portal will appear called LinkGather:
Hover over this tab option, you will then see a sub-menu with the different options available to you:
Clicking on the Home link, this will go to the plugins developer page which has instructions, similar to these, on how to use the plugin.
Post Links
Push the Post Links title to navigate you to the page that will show all of your WordPress sites published posts’ links. Be aware that for the purposes of this instruction, we are using our blog test site with just a few links in it.
You will now see a list with two columns, more info 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 long this list will be.
At the bottom of the URL table, you will 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 procedure above is exactly the same for Page Links, however instead of showing back published articles, it will bring back published pages instead:
JetPack ShortLinks
The option for JetPack URLs is again exactly the same instructions as those above, however, JetPack ShortLinks 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 LinkGather Plugin 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.
Assuming that you have JetPack short links enabled, clicking on our plugins wp.me Links option will bring more info back all those JetPack URLs that it has gathered:
Video Walkthrough
If you are still having problems using this plugin, you can view a demostration video walkthrough here: