How to Export WordPress Posts

To export WordPress posts, go to WP All Export › New Export and select Posts from the dropdown list. Build your export file using the Drag & Drop interface. Once done, export the posts and download the exported file.

This documentation covers how to export WordPress posts using WP All Export. For a broader look at exporting WordPress posts, check out:

Step 1: Create New Export for WordPress Posts

Go to All Export › New Export on the site, choose Posts, and WP All Export will update to show the number of posts it will export:

Export WordPress Posts New Export

Below this section, you can Add Filtering Options to make the export more selective.

Once you've defined which posts to export, click on Customize Export File.

Step 2: Customize the WordPress Post Export File

The Drag & Drop interface will appear, which lets you decide which data columns to export and allows you to modify the export file format.

The data available for export is shown in the Available Data section on the right. To add a field to the export, drag it from that section to the column selection area on the left:

Export WordPress Posts Drag and Drop

You can delete an export column by dragging it outside the column selection area, or by clicking on the column and then clicking on Delete.

When exporting WordPress posts, you will see the following sections: Standard, Media, Taxonomies, Custom Fields, and Other.

Posts Standard Data

WordPress post standard data is found in Available Data › Standard. The following data fields are available:

  • ID: The post ID is a unique number given to every post in WordPress.
  • Title: The title of the WordPress post.
  • Content: The post's content.
  • Excerpt: A short description of the post.
  • Date: The date the product was published, in y-m-d H:i:s format.
  • Post Type: The post type to export, which is post in this case.
  • Permaink: The URL of the post.
Export WordPress Posts Standard Post Data

Posts Media

All Images and attachments associated with the exported WordPress posts will appear here. You will see two sections inside the Media section: Images and Attachments. Both sections contain the same types of fields:

  • URL: The URL of the image or file.
  • Filename: The filename for the full-size image or the file.
  • Path: The path or location on the server of the image or file.
  • ID: The attachment ID of the image or file, similar to a post ID.
  • Title: The image or file title.
  • Caption: The image or file caption.
  • Description: The image or file description.
  • Alt Text: The image or file's alternative text.
  • Featured: The URL of the featured image (not shown for attachments).
Export WordPress Posts Media

Posts Taxonomies

This section includes the categories and tags attached to the WordPress posts. By default, posts only have two taxonomies, but all taxonomies are detected and shown here during export:

  • Categories
  • Tags
Export WordPress Posts Taxonomies

Posts Custom Fields

This section contains any custom fields added by custom code or other plugins. This interface will show up to 1000 custom fields, but custom code can be used to retrieve any custom field.

Export WordPress Posts Custom Fields

Other Posts Data

This section contains other post data not included in the other sections. The following is an incomplete list with only the more important other export fields:

  • Status: The post status. The default post statuses are publishdraft, pending, and private.
  • Author ID: The ID of the user that created the post.
  • Author Username: The username of the user that created the post.
  • Slug: The post's slug.
  • Parent: If the post has a parent post, it will export its ID. Otherwise, 0 is exported.
  • Parent Slug: If the post has a parent, it will export its slug. Otherwise, 0 is exported.
  • Post Modified Date: The date the product was last modified, in y-m-d H:i:s format.
Export WordPress Posts Other Data

Step 3: Download the Exported WordPress Posts

Once the export template is set up, click Continue at the bottom. This will bring you to the Export Settings screen, where you will see the following:

Export Settings

Here you can configure Scheduling Options and Advanced Options. When you are ready to run your export, click Confirm & Run Export.

The export will begin to process. Once it is complete, you can download the exported file in either the selected format (i.e., CSV, XML, Excel) or as a Bundle file. In addition to the export data, the bundle file contains instructions that tell WP All Import how to import the data.

Confirm and Run Screen

Here's a look at an example WordPress posts export:

Export WordPress Posts Example File

Advanced Topics

Add Filters to Your WordPress Post Export

You can add a filter to export only a subset of WordPress posts. The filter can be used on all export fields described in Step 2 of the guide above.

To filter your WordPress posts, expand Add Filtering Options in the panel at the bottom of Step 1, then choose an Element, select a Rule, and input a Value:

Export WordPress Posts Add Filtering Options

In this example, you are setting:

Element = Date

Rule = equal to or newer than

Value = yesterday

This is the same as saying, “Export posts with a date equal to or earlier than 'yesterday.'"

You can also combine multiple filters. For example, to export posts with a category of "News" that have a status of publish, set your filters like this:

Export WordPress Posts Multiple Filters

The filters can be as complex as you want. Using the same Filtering Options section, you can modify existing filters in All ExportManage ExportsSettings.

Choose A Different Export File Format

You can choose a different export type to output a different file format. The following options are available:

  • Spreadsheet
    • CSV File
    • Excel File (XLS)
    • Excel File (XLSX)
  • Feed
    • Simple XML Feed
    • Custom XML Feed

You can learn more about using any of the available export types here: Export WordPress to CSV, Excel, or XML.

Learn How To Connect Your Export With External Apps

You can use Zapier to connect with external apps. Zapier acts as a middle man between WP All Export and hundreds of other popular apps. For example, you can send the exported posts via email (i.e., using Gmail) or to Google Drive.

To learn more, read: How to Send Exported WordPress Data to Zapier.

Frequently Asked Questions About Exporting WordPress Posts

How to Export WordPress Posts Automatically?

You can use our automatic scheduling service to run your WordPress posts export automatically on a predefined schedule. This can be scheduled directly from our interface. Alternatively, you can manually set up cron jobs on your server.

How to Export WordPress Posts to Excel?

  1. Go to All Export > New Export and select Posts.
  2. Configure the export columns using our Drag & Drop interface.
  3. In that same interface, change the Export Type to Spreadsheet > Excel File (XLS) or Spreadsheet > Excel File (XLSX), depending on the version of Excel that you are using.
  4. Run the export.
  5. Verify the content of your export file.

How to Migrate Posts From One WordPress Site to Another?

  1. Go to WP All Export and select Migrate Posts on the export site.
  2. After the export is complete, download the Bundle option.
  3. Go to WP All Import and upload the bundle file on the import site. WP All Import will use the import template in the bundle file to automatically configure the import.
  4. Process the import to complete the migration.

To see this process in more detail, refer to our Migrate quickstart guide.

How to Download a List of Posts From WordPress?

Use the steps from this guide to export all WordPress posts and generate a list with all the posts from your WordPress site. If you only need a subset of posts, you can apply a filter as explained in the section Add Filters to Export WordPress Posts Selectively.

How to Import WordPress Posts?

  1. Navigate to All Import › New Import.
  2. Choose how you want to import your data (i.e., upload a file, download a file from a URL, etc.) and select your import file.
  3. Choose Posts as your import target.
  4. Use our Drag & Drop interface to map the incoming data elements to the post target fields.
  5. Run the import.

Relevant Videos

Related Docs

Export images along with their WordPress type or custom post type.

Export custom fields from any theme or third-party plugin.

Use filters to tell WP All Export which data should be exported specifically.

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