CSV Export will create a csv file of published and draft post data.
Installation:
Install CSV Export by the WordPress plugin installer.
Activate the plugin at the plugin administration page.
Look under Tools section (Left sidebar menu) for the Export page.