How to Export WordPress to CSV, Excel, and XML
To export WordPress data to CSV, Excel, or XML, go to WP All Export › New Export and select the type of data you'd like to export. Next, drag and drop the post data to set up your export file. Then run the export to create your customized WordPress export.
Here's a video that shows how WP All Export works in-depth:
Continue reading below for text instructions.
Step 1: Select a WordPress Post Type to Export
First, navigate to All Export › New Export and choose the type of data that you would like to export.
WordPress separates data into different post types like posts, pages, WooCommerce products, real estate properties, etc. You can export any custom post type or taxonomy by selecting it here.
Once you've chosen a post type to export, click Customize Export File at the end to continue (not shown).
Step 2: Customize Your WordPress CSV/XML Export
The fields available to export are listed on the right. Drag and drop individual fields from there to the column selection area, or click Add All to export everything.
All data is available for export, including media, images, categories and tags, custom fields, etc. Add-ons like WooCommerce, real estate plugins, Yoast, and ACF have custom data that can be exported, too.
Once you've selected your export fields, you can move them around to reorder them. Click to rename individual elements, combine multiple fields, and more.
When you've finished selecting and configuring your export columns, click Continue.
Step 3: Confirm and Run Your Export
WP All Export will ask you to verify your final export settings. Click Confirm & Run Export when you're ready to run your export.
Step 4: Download Your WordPress CSV/XML Export
After the export finishes, download the generated export file. At this point, you can choose to migrate this data to another WordPress site, edit it in Excel and import it back to this WordPress site, or send it to Dropbox, Google Drive, email, and over 1000+ other external apps via Zapier. You can even schedule your exports to run automatically.
You can review previous exports via All Export › Manage Exports.
Export WordPress – Advanced Topics
Select a Different Export Type
To export WordPress data in a different format, change the Export Type (in step 2 above) to a different file format. Here are the available options:
- CSV File: creates a .CSV file.
- Excel File (XLS): creates a .XLS file.
- Excel File (XLSX): creates a .XLSX file.
- Simple XML Feed: creates a .XML file.
- Custom XML Feed creates a .XML file.
When you export WooCommerce products, there will be another Feed option: Google Merchant Center Product Feed. That export type is specific to products and generates a .TXT file.
Make an Export Run Automatically with Scheduling
You can schedule your WordPress export using WP All Export and its built-in options:
- Use cron jobs: this is included by default with WP All Export Pro. It allows you to manually create cron jobs in your server (via cPanel, Plesk, or similar) and then run the export on a schedule. To learn more, see Manual Scheduling.
- Use Automatic Scheduling Service: this is an optional and monthly paid service that allows you to schedule exports directly from within WP All Import's interface with an easy-to-use interface. See Automatic Scheduling Service.
The scheduling options can be defined in Step 3 above or after the export has been created in All Export › Manage Exports › Scheduling Options. The same options are also found in the export Settings.
Use PHP Code or Custom PHP Code when Exporting Data
In addition to exporting data easily, WP All Export allows you to use PHP code or custom PHP code on the exported data.
This is useful for modifying your WordPress data on-the-fly while exporting. You can learn more about this in our documentation, How to Pass Exported WordPress Data Through PHP Functions. This technique allows you to apply a function to a single export element.
If you need to pass more than one export element through a function, you can use custom export fields instead. See Combine and Process Multiple Data Elements into a Custom Export Field for more information.
Frequently Asked Questions
How to Completely Export my WordPress Site?
WP All Export allows you to export the post types or custom post types available on your WordPress site, but it won't be able to export your full site at once. You will have to export one post type at a time.
By default, WordPress offers a native tool to export all WordPress data (see Tools Export Screen). However, to export a WordPress site entirely and manually, you can export the WordPress database and then download the WordPress files from your server via SFTP or FTP.
How to Export and Import a WordPress Site?
- Go to the export site and use WP All Export to migrate all of your desired data.
- Download the generated bundles for each post type or custom post type that was exported.
- Go to the import site and use WP All Import to import each bundle.
- Review to confirm that your migration was successful.
This process is explained in more detail in our Migrate quickstart guide.
How to Export Media from WordPress?
WP All Export doesn't support exporting the Media Library out of the box. To export media from your WordPress site, you need to export the post type or custom post type associated with the media that you wish to export.
For example, if you have multiple images attached to posts, you would need to export your WordPress posts to obtain those images.
However, there's a workaround that allows using a WP_Query export (see documentation) to generate an export file with all of the media that exists on your site. Here's the query that you can use:
'post_type' => 'attachment', 'post_status' => 'inherit'
Learn how to import any CSV or XML file to WordPress using WP All Import.
Learn how to migrate data to a different site using WP All Import and WP All Export.
Learn to bulk edit your WordPress data with WP All Import and WP All Export.