How to Export Posts in WordPress

To export posts in WordPress, go to WP Ultimate CSV importer -> Export.  From the data types lists select Posts.  Map the fields of the CSV fields header with WP fields to construct the export file.  Choose the file type, filters and run the export. Download the exported file and verify the exported files.

Step 1: Build a new export for your WordPress Posts. #

Navigate to the WP Ultimate CSV importer -> Export. 

Choose Posts from the lists of data types. The number of posts in your wordpress site will be displayed. Verify the posts, and click on Continue.

Step 2: Choose the Export Columns of the Posts #

You can create a new mapping for your export file or you can use the saved mapping templates.

On clicking on Create new mapping, the configuration settings of the new export file will be displayed

If you choose the saved template, the settings of the selected template will be applied to this respective export file.

For example, the file name, file type, and the filter option to export any specific fields of the saved mapping template will be applied to the new export file.

Step 3: Configure Advanced filter settings  #

To export your posts most specifically, you can use the advanced filter option.

The Advanced filter configuration Window will be displayed when selecting the Create new mapping. 

Choose the file name and file type. Then you can choose any advanced filter option to export your posts more specifically. 

For example, if you choose Export data with a specific author, then the posts of the selected author will only be exported.

Also, you can define any particular fields of the posts to be exported like custom fields, wordpress core fields, ACF fields, etc.,

Note: The WP Ultimate CSV importer is compatible with ACF, JetEngine, Metabox, PODS, and Toolset types to export all custom fields of the Posts effectively.

You can also define the scheduling option to export posts.

Once done with all the configuration, and ready to go, click on the Export option.

Step 4: Download the exported file #

Once the export process is completed, you can download the exported posts file in CSV, XML, or XLS format. 

You can easily import the exported file to other websites using our WP Ultimate CSV importer. This plugin is a two-in-one tool that seamlessly imports and exports post data between your WordPress Sites.

Export WordPress Posts- Advanced Topics #

Advanced Filter option to Specific Post Export #

There are so many advanced filters to efficiently export specific posts or fields of the posts from the WordPress site. The advanced filter option includes,

1. Export Data with auto delimiters or other delimiters. 
2. Export data with  Status: You can export posts with their status such as All, published, sticky, or draft. 
3. Export data by specific author: Choose the desired author name from the drop-down menu to export only the posts of the selected author.
4. Export data with specific post IDs – Provide the desired post IDs for the posts that you want to export.
5. Export data by specific category– Select the desired category from the drop-down, based on which you need to export. 
6. Export data with specific inclusion – Select any desired fields to export from the WordPress core fields, All in one SEO field, custom field suite, elementor fields, Featured image meta, Rank Math Pro fields, Terms and Taxonomies fields, and Yoast SEO fields.

Schedule the post-export #

Enable “Do you want to Schedule this export?” and provide the Scheduled date, time, frequency, and time zone.

Provide the Schedule host’s details and the connection types. Then run the Schedule Export.

Support different file format #

The WP Ultimate CSV importer supports different file formats to output your exported file. 

You can export your posts in any of the following file formats:

• CSV
• XML
• XLS
• JSON

WordPress Posts Export- Frequently Asked Questions #

How to export my Posts as Excel in WordPress? #

To export posts as CSV,  

1. Navigate to the WP Ultimate CSV importer -> Export->Posts.
2. Click on continue and choose the mapping template or create a new mapping.
3. On the Export configuration settings, select the file type as XLS. 
4. Run the exporter and verify the Posts in your Excel file.

How to export single posts from WordPress? #

To export single posts from WordPress, follow all the steps explained in this guide. Add any advanced filter that best suits the desired posts to export.

What are the steps to export selected posts from WordPress? #

Follow the above steps to export the posts. To export more specific posts, or to export the selected posts from wordpress, use the advanced filter options. 

This will help to export the desired targeted posts effectively. For example, if you add the filter to export the post of a specific author, then it will export only the posts with that author.

How to export posts automatically? #

To export posts automatically, enable the scheduling option on the export configuration settings. Follow the steps above on the Advanced topics- Schedule the Posts export.

How to Import WordPress Posts?
#

1. Go to WP Ultimate CSV importer -> Import/Update.
2. Upload the desired import file in the format of CSV, XML, or XLS.
3. Choose the data type that you want to import such as posts, pages, custom posts, etc.
4. Map the incoming data elements with their respective WP fields.
5. Configure the import settings and run the Import.

How to export WordPress pages? #

The steps to export WordPress Pages will be the same as that the WordPress posts Export. Follow the Steps given in this guide. But In Step 1, select the data type as Pages instead of Posts. The import process will seamlessly run with the subsequent steps.

How to export WordPress data to CSV/XML? #

You can follow the same steps given above to export the WordPress posts to CSV/XML. In Step 3, select the file type as CSV to export your posts file in CSV format, Whereas choose the file type as XML to export posts in XML. Now run the export. Moreover, CSV is the default file format for any WordPress data export in WP Ultimate CSV importer.

How to Migrate Posts from One WordPress Site to another? #

Follow the below steps to migrate your Posts from One WordPress site to another.

1. Export all your posts from the source site by following all the steps given in this guide
2. Now import the exported file by navigating to the WP Ultimate CSV importer -> Import/Update.
3. Follow the steps on how to import posts
4. Run the importer and verify whether all your posts on the source site will get migrated to the destination site.

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $199/-