WordPress.org

Ready to get started?Download WordPress

Forums

Exporting Post Details To Excel or CSV (10 posts)

  1. PWB
    Member
    Posted 5 years ago #

    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.

  2. iridiax
    Member
    Posted 5 years ago #

    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

  3. iridiax
    Member
    Posted 5 years ago #

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

  4. PWB
    Member
    Posted 5 years ago #

    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?

  5. MichaelH
    Member
    Posted 5 years ago #

  6. PWB
    Member
    Posted 5 years ago #

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

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

  7. WebTechGlobal
    Member
    Posted 4 years ago #

    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

  8. Cristian Tacchi
    Member
    Posted 4 years ago #

    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?

  9. WebTechGlobal
    Member
    Posted 4 years ago #

    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

  10. WebTechGlobal
    Member
    Posted 4 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic