How can i export post only with this data in excel :-

Post title - Post URL - Author - publish Date


  • What had you tried? What are your development skills?
    – Rarst
    Aug 22, 2014 at 20:31

1 Answer 1


If you have direct access to your WordPress database, you could use a tool like PHPMyAdmin or HeidiSQL to query the post and user tables and extract the information you need from the appropriate tables.

I discuss how an SQL query is constructed to get specific categories in Does WordPress Offer A Way to Get only Child Categories?. You can probably construct your own query to get the needed information with some time.

Or, you could take the simple option and install something like Export 2 Excel.

This site is temporarily in read-only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .