How to Export WordPress to CSV, Excel, and XML
To export WordPress data to CSV, Excel, or XML, go to All Export › New Export and select the type of data you want to export. Use the Drag & Drop interface to select your export columns, then run the export and download your file.
Step 1: Select a Post Type for Your WordPress Export
First, navigate to All Export › New Export and choose the type of data that you want 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, click Customize Export File at the end to continue (not shown).
Step 2: Customize Your WordPress 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 your export columns are the way you want them, click Continue.
Step 3: Confirm and Run Your WordPress Export
You can now configure your WordPress export settings. This includes the ability to schedule your export and set advanced options. We'll leave these settings alone for now. Instead, click Confirm & Run Export to run your export.
Step 4: Download Your WordPress 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 into WordPress, or send it to Dropbox, Google Drive, email, and over 1000+ other external apps via Zapier.
You can review previous exports via All Export › Manage Exports.
Export WordPress – Advanced Topics
Select a Different WordPress Export Type
To export WordPress data in a different format, expand the Export Type section in the Drag & Drop interface. Here are the available options:
- Spreadsheet
- CSV File: creates a .CSV file.
- Excel File (XLS): creates a .XLS file.
- Excel File (XLSX): creates a .XLSX file.
- Feed
- 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.
Export WordPress Automatically with Scheduling
You can schedule your WordPress export using the following options:
- Cron jobs: this 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.
- Our Automatic Scheduling Service: this is an optional and monthly paid service that allows you to schedule exports directly from within our plugin's interface. See Automatic Scheduling Service.
The scheduling options can be defined by expanding the Scheduling Options section of the Export Settings screen (Step 3 above), or after the export has been created in All Export › Manage Exports › Scheduling Options.
Use PHP Code or Custom PHP Code when Exporting WordPress Data
In addition to exporting WordPress data easily, our software 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.
Export WordPress – Frequently Asked Questions
How to Completely Export a WordPress Site?
You can export the post types or custom post types available on your WordPress site, but you can't export your full site at once. You 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 WordPress Media?
You cannot export 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 need to export the 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'
Related Docs
Learn how to import any CSV or XML file to WordPress.
Describes how to migrate data between sites.
Shows you how to bulk edit your WordPress data.