WordPress.org

Support

Support » How-To and Troubleshooting » Exporting Post Details To Excel or CSV

Exporting Post Details To Excel or CSV

  • Hi all, I thought I would give these forums a shot.

    I am looking to export the details of my posts into a spreadsheet and wondered if anyone knew how to do this?

    Idealy I would like
    Title Of Post | Date | Author | Category

    No other info is needed but I can delete it once it’s in excel if required.

    Thanks for any help if anyone reads this.

Viewing 9 replies - 1 through 9 (of 9 total)
  • I don’t know how to do it, but that kind of data is in the MySQL database and maybe you can get it from there.

    http://codex.wordpress.org/Database_Description

    Another option would be to make a custom WordPress page template with query_posts in it to list out all the posts’ info for copy and pasting.

    http://codex.wordpress.org/The_Loop
    http://codex.wordpress.org/Template_Tags/query_posts#Example_3
    http://codex.wordpress.org/Pages#Creating_Your_Own_Page_Templates

    Added: I don’t know if all the data you want is in there, but feeds and XML sitemaps may also have it.

    yeah i was hoping that there would be a dead simple way to do it. Either with the rss feed or a plugin to do it.

    Any suggestions?

    Has anyone got a tutorial or something on how to do this?

    I have no idea what I am doing to get this done.

    Hey

    Did you find a solution for this and would you be willing to purchase CSV 2 POST Plus if I added such an ability to it?

    I plan to anyway it’s just that I could make it higher priority.

    CSV 2 POST is a csv import plugin I made that is slowly and will aventually do all things CSV on WordPress so that you don’t need to install a plugin to mass delete posts, export data and another one to import it.

    Currently selling at £29.99 and the price will go up once the export ability is added however for you I would keep it at this price.

    Ryan

    iridiax,

    I need to export post data out of wordpress (to excel) but the xml file generated by wordpress is not XML compilant so i cant read it in Excel…

    i need to read post data (title and custom fields) to generate in excel statics

    exporting mysql data is not a option because the xml or xls data is veeeery bad constructed..

    and the xml (non compilant) data is just what i need but i dont figure out how to make it XML compilant

    anybody can help me?

    Sorry not at the moment tied up with CSV 2 POST importing functions won’t be coding the exporting tools for another 2-3 weeks possibly.

    Watch the development of CSV 2 POST because it will eventually do everything when it comes to data management for WP.

    Ryan

    I decided to create a new plugin which is even better than CSV 2 POST called Easy CSV Importer. You can do data import from your PC and avoid opening csv files on your server too much.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Exporting Post Details To Excel or CSV’ is closed to new replies.
Skip to toolbar