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.

Export WordPress Create New Export

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.

Export WordPress Drag and Drop Export Fields

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.

Export WordPress Confirm Settings and Run 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.

Export WordPress Download and Export Complete

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:

  • 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.
Export WordPress Select Export Type

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 Do I 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 can only 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 Do I Export and Import a WordPress Site?

You can use WP All Export and WP All Import to export and then import your WordPress data from one site to another. Here's what to do:

  1. Go to the export site and use WP All Export to migrate all of your desired data.
  2. Download the generated bundles for each post type or custom post type that was exported.
  3. Go to the import site and use WP All Import to import each bundle.
  4. Review to confirm that your migration was successful.

This process is explained in more detail in our Migrate quickstart guide.

How Do I 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'

Related Docs

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.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross