Export All Posts, Products, Orders, Refunds & Users

Through the WordPress admin panel.
By using a WordPress export plugin.

Exporting through the WordPress Admin Panel is limited and there are plugins available with the most advanced features that the default tool does have. Primarily this export doesn't support CSV, Xls, or JSON files.

To export your content from the WordPress admin panel, simply navigate to Tools > Export in the left-hand menu.

From here, you can choose to export all content or only certain types of content (such as posts or pages). Once you've made your selection, click the Export button and save the resulting file to your computer.

WordPress data Export via our plugin

If you prefer, you can also use this plugin to export your content as a CSV, XML, XLS, or JSON file format. Simply install and activate the plugin, then navigate to the Export screen.

From here, you can choose what to export, once you've made your selection, click the Export button and save the resulting file to your computer.
2. How can I export the entire WordPress site? How to export it from localhost?
If you want to export your entire WordPress site, including your settings and configuration, you will need to use a plugin or manual method.

For manual export,

Back up your files as compressed files including wp-content or you can do it separately if the size is too big which you can merge later to the root folder.
Ensure you have a copy of the wp-config.php file, it is better to have multiple version copies of this with a prefix or suffix added to the file name. You will end up updating the new domain or subdomain, DB name, DB password, and host details in the wp-config.php file to make it work in a new environment. In this case, you may need to refer it the old configurations to make sure they are correct.
Finally export your WordPress DB as .sql or zip or gzip format.

3. How to export wp-content?
You can simply compress it and move it to the desired location. Note that wp-content is the folder where your theme, plugins, media, and backups are stored. You may end up handling a very huge folder, if that is the case you can split and backup them.
4. How to WordPress export database tables to CSV using a plugin?
If you want to export your WordPress database table to a CSV file, you can use our WordPress CSV export tool.

To do this, go to the Export screen in your plugin UI. From there, you can select which type of content you'd like to export. Choose "Posts" if you want to export your blog posts, "Pages" if you want to export static pages, or choose any other options available.

Choose the file type you wish to export, note you can select between CSV, XlS, XML, or JSON format. Click the "Export" button. This will process extracting the information from the WordPress database as the source and convert them into CSV or XLS files to export. Both CSV and XLS formats are openable in any spreadsheet program like Microsoft Excel.
5. How to export WP DB?
These steps can only back up the WP core DB export that includes all your posts, pages, and comments. The core files, folders, wp-content, and media such as images, are not backed up. Both have to be managed separately, you can use a Backup plugin for the whole WordPress site backup.

Assuming you have a WordPress site up and running, there are two ways to export your database. The first is by using phpMyAdmin, and the second is by using the command line.

To use phpMyAdmin:

Log in to phpMyAdmin.
Select the database you want to export from the left-hand sidebar.
Click the Export tab at the top of the page.
Under Export Method, select Quick * to display only the minimal options.
Scroll down to the Format-specific options section and select Microsoft Word XML format from the drop-down menu.
Click Go to start the export process.

To use the command line:

Log in to your server via SSH.
Navigate to the directory where you want to export the database file.
Export the database with the following command: mysqldump -u username -p database_name > databasename.xml
Enter your password when prompted.
The database will be exported to an XML file in the current directory.

To use the hosting control Panels:

You can back up using cPanel or the hosting panel if it is supported. Search or look for ‘Download a MySQL Database Backup’ under backups. Choose the name of the WP database to download it as a gzip file. If you are not sure, get the DB name from the wp-config.php file in the root.
6. Can I export Custom Post created with any third-party plugin?
Yes, you can export all Custom Posts listed in the drop-down.
7. Is there any limitation on the number of records exported?
No, there is no limitation on the number of records you can export.
8. What is export_wp and how can I use it?
export_wp is a function for WordPress that generates the WXR export file for download. By default, this function can export all the content for post types with the can_export argument enabled and skip posts with ‘auto-draft’ status.

Like any other function, developers can use it directly in themes or plugin files by attaching it to an action hook or filter hook. All plugins categorized under export use WordPress functions to process the request.
9. How Passwords are handled in export?
The attribute and header name are user_pass in your export file. The passwords are exported in original md5 format from WordPress DB which is easy to import back in case of site migrations without any issues.

You can always skip or delete the old passwords to generate new passwords during import but that involves extra processes like emailing all users about the change and requesting them to change the temporary password, etc.,
10. To export, how to remove unwanted columns? Is there any controlled export?
For a controlled export, you have to use available advanced filters and options for desired results. You can also remove unwanted columns even after export by deleting them. Note this can be easy to edit, update, or delete if you choose CSV or Excel format as an option.
11. How to export WooCommerce orders to Excel? How to export orders to Excel format?
Under the export tab, choose WooCommerce Orders as your choice to export. This will export all orders from WooCommerce provided no advanced filters are selected. You can use the date filter to limit the time range of the orders created. Apply other options as desired, and export the data. If you wish to export WooCommerce orders to Excel for editing and manipulation, make sure that you have selected XLS in the file format options.
12. Where are WooCommerce Orders exported?
When you click to download the exported data, the file is downloaded through your web browser. You can find it in Browser > Download (Ctrl + J) and click show in folder. The default download location should be C:\Downloads on your Windows PC.
13. Does this plugin support the export/import of images for WooCommerce products? How the image galleries are exported?
Yes, you can export images for WooCommerce products. They are respectively for the default WooCommerce setup as follows.

featured_image: Inputs should be the image URL which is publicly accessible and downloadable.

Example: https://ps.w.org/wp-ultimate-csv-importer/assets/banner-772x250.jpg

product_image_gallery: This a set of multiple image URLs that is publicly accessible and downloadable separated by pipe symbols like image21.jpg|image82.png|topview.png.

Example:https://ps.w.org/wp-ultimate-csv-importer/assets/banner-772x250.jpg|https://ps.w.org/wp-ultimate-csv-importer/assets/icon.svg?rev=2795463
14. What is WooCommerce product shipping class? How to handle it in import and export files?
Product Shipping Classes in WooCommerce make it easier to configure shipping rates for a set of products & and categories. That is to manage additional handling or special packaging, to set up free or flat-rate shipping. The attribute for Product Shipping Classes is exported as product_shipping_class that is assigned to the product.

In the case of import, make sure the shipping classes are already created and input the proper values. You can do a sample export to verify the product_shipping_class values before manipulating your import values.
15. What are Columns exported with user metadata? What WordPress default profile data is exported?
The plugin will export all the attributes involved, even if they are non-mandatory or have no values. The future release will have filtering options to exclude empty fields to trim unnecessary columns that could increase the import performance.

Here is the main attributes list:

user_login
user_pass
first_name
last_name
user_email
user_url
display_name
biographical_info
wp_capabilities
wp_user_level
role

Some of the WordPress user default profile data exported are:

user_nicename
user_registered
disable_visual_editor
admin_color
enable_keyboard_shortcuts
show_toolbar
wp_dashboard_quick_press_last_post_id

Added to that, WordPress member's user metadata that can be exported are:

mem_email
mem_text
mem_tarea
mem_multiselect
mem_select
mem_radio_gp
mem_password
mem_image
mem_file
mem_url
mem_number
mem_date
mem_checkbox

In the case of WooCommerce customers below listed user meta is exported:

woocommerce_api_consumer_key
woocommerce_api_consumer_secret
woocommerce_api_key_permissions
wpscshipping_region
wpscbilling_region
wpsccart
billing_first_name
billing_last_name
billing_company
billing_address_1
billing_address_2
billing_city
billing_postcode
billing_state
billing_country
billing_phone
billing_email
shipping_first_name
shipping_last_name
shipping_company
shipping_address_1
shipping_address_2
shipping_city
shipping_postcode
shipping_state
shipping_country

Select the 'Comments' module in the export tab to export comments. Provide filename, and file type, choose filters, and click export.

17. Can I preview the data before exporting it?
Yes! The new Preview option shows the first 10 records from your choosen post type. The preview button is accessible at the end of the Export settings page, you can use it after applying necessary filters and other settings. This helps you verify the output before generating the full file — saving time and avoiding mistakes.
18. What is Query-Based Export and how do i use it?
Query-Based Export is a developer-focused export feature that lets you export exactly the data you need by writing custom queries. Instead of exporting all content or relying on filters, you can target specific posts, users, or comments using advanced criteria like post type, meta fields, date range, categories, and more. Just go to Export tab and choose WP Query. Enter your query arguments in JSON-like format, preview the results, and click Export. It’s flexible, powerful, and doesn’t require writing PHP.
19. How does iteration-based export work?
Iteration-based export breaks down large data exports into smaller, manageable batches. Instead of processing all records at once, the plugin exports them in multiple iterations—reducing server load, avoiding timeouts, and ensuring smoother, more reliable exports for large datasets.
20. Can I export Easy Digital Downloads data using WP Ultimate CSV Importer?
Yes. You can export Easy Digital Downloads data, including Downloads, Customers, and Discounts. Go to the Export tab, choose Custom Posts, select the required EDD module (EDD Downloads/EDD Customers/EDD Discount), set the file name and format, and click Export.