Wordpress post information exporting to excel

[Scottish Business Owner]

This is probably a long shot but does anyone know an easy way of getting post information out into a spreadsheet?

I have a site where i'd like to create a spreadsheet of all posts made to date but i'd rather not do it by hand. Something that could be refreshed would be amazing and if I could pick what fields I wanted that would also be immense.

There are a couple of plugins I came across but they don't seem to be supported that well and have lot's of comments about them not working.

Any advice greatly appreciated

 

[Taryn Wallis]

Do you have access to PHPMyAdmin? If so, you can export your database (or just the tables you want) in various formats - CSV and Excel are supported.

 

[Business Upside]

Just go to Tools and then export to export all of your posts, pages, comments. In this tutorial, we will go over simple steps to get started and export all Word Press posts into CSV format.