Knowledge Base

How to Export Import WordPress Single Page, Post, Custom Post, & WooCommerce Product as CSV

WordPress Export Import Single Page, Post, Custom Post feature in WP Ultimate CSV Importer enables effortless migration of your records between environments, such as from a development site to a live site. You can export and import records directly from the edit or create view inside WordPress, making it even easier for you to create backup, and import stored backup instantly within a few seconds.

Note: This feature works like a migration, you first have to export the record and then import it. It supports only CSV format for now.

How to Export a Page/Post/Custom Post #

Follow these step-by-step processes to export individual content:

Step 1: Navigate to the Content #

Go to the post, page, or custom post you wish to export.

Step 2: Access the Import/Export Menu #

In the edit view of the content, locate the Import/Export menu at the top-right corner.

Step 3: Switch to the Export Tab #

Click on the menu to open a new sidebar. It will show the page with two tabs: Import and Export. Here, switch to the Export tab.

click-export-csv-from-export-tab

Step 4: Export the Content #

Just click the Export CSV button. The content data will be downloaded as a CSV file and saved to your device.

Note: If the selected content has no data or is unpublished, you’ll receive an alert: “Invalid or unpublished post ID.”

How to Import a New Page/Post/Custom Post #

Use the following steps to import content from a CSV file.

Note: The headers in the exported file should match the import file headers to perform import correctly. Any changes in the file header names will cause some issues while import. So it’s best to use the exported file, just change the data in it and import.

Step 1: Navigate to Add New Content #

Go to Add New in your WordPress dashboard for the desired content type (page, post, or product).

Step 2: Access the Import/Export Menu #

Locate the Import/Export menu in the top-right corner. Click on it to open a sidebar.

import-export-icon-in-post-edit-view

Step 3: Upload the CSV File #

In the Import tab, click Choose File to upload the exported CSV file. Select the file and click Open.

click-choose-file-from-import-tab

Step 4: Import the Data #

Upon successful file upload, click Upload Import.

click-upload-import-to-start-post-import-

A success message will appear like this: “Inserted Post [ID]. Click here for Redirect link.”

post-inserted-message-after-import

Use the Click here button to view the newly imported content in a new tab.

Step 5: Start a New Import Process #

Click the Clear button to reset the process and start a new import.

Note: If you initiate the import process from the edit view of an existing post or page, the steps remain the same.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

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

How to Export Import a Single WooCommerce Product with WP Ultimate CSV Importer #

You can now migrate individual WooCommerce products between websites effortlessly using the one-click import/export feature available directly from the product create or edit view. Follow the steps below to export and import a single WooCommerce product.

Note: This feature supports simple, grouped, external, and variable products (with attributes). However, it does not currently support exporting/importing product variations.

Export a Single WooCommerce Product #

Step 1: Access the Product Record #

Navigate to WooCommerce > Products in your WordPress dashboard and select the product you want to export.

Step 2: Locate the Import/Export widget #

Open the desired product in the edit view. Look for the Import/Export widget on the page (refer to the screenshot for guidance).

import-export-widget-in-add-new-product-page

Step 3: Export the Product as a CSV #

Click the Export tab in the widget and simply click the Export CSV button. Provide a name for the file when prompted and download it to your device.

click-export-csv-to-export-existing-woo-product

Import Single WooCommerce Product #

Step 1: Navigate to the Add New Product Page #

Go to your WordPress dashboard and select WooCommerce > Products > Add new product.

Step 2: Find the Import/Export widget #

Locate the Import/Export widget on the Add New Product page. By default, the widget will display the Import area.

Step 3: Upload the Exported Product File #

Click the Choose File button. Select the previously exported product CSV file from your device and click open.

Step 4: Start the Import Process #

After you receive the successful upload message like below after the file upload. Click the Upload Import button to start the import process. The process will be completed in a few moments.

product-csv-upload-success

Step 5: Verify the Imported Product #

After the import completes, you’ll receive a message like:

“Inserted Post ID. Click here for Redirect link”. Click the Click Here button to view the newly imported product. Verify that all product fields, including attributes, pricing, and metadata are imported correctly.

single-product-import-complete-message

Use the Clear button on the widget to reset the form and start a new import, if needed.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

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

New Release Unveiled:

WP Ultimate CSV Importer v8.1