The plugin is useful to take backup of your database to excel sheet as well you can upload to new database. It will give you complete post information
What the WP Export plugin is?
WP Export is a plugin to get all your blog's published and draft post data in Excel format as output. The post data means, post Title, Description, Excerpt, Categories, Tags and all other custom fields which you have used for your blog post. You can also makes changes in it and and save as CSV (Comma Delimited) format. Now you can use this CSV file to import this data wherever you want. What ever data you have inserted in you CSV file will be inserted to your blog with necessary category and tags. In case if any category is not already created in the blog, the plugin will add new category and post will be automatically assigned to it.