WordPress Awesome Import & Export Plugin allows to import and export of post, pages, categories/tags, custom posts, comments, users, custom tables, custom taxonomies .
You can also import and export custom plugin data like woocommerce or import/export data of any table of wordpress database. You can import using csv,excel,xml files and export in csv,excel,xml,pdf.