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 easier to create a backup and instantly import stored backups within seconds.

Note: This feature works like a migration tool, you must first export the record before importing 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 #

While editing the content, locate the Import/Export menu in the top-right corner.

Step 3: Switch to the Export Tab #

Click the menu to open a sidebar displaying two tabs: Import and Export. Here, switch to the Export tab.

click-export-csv-from-export-tab

Step 4: Export the Content #

Click the ‘Export CSV’ button. The content 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 the Redirect link.”

post-inserted-message-after-import

Click ‘Click Here’ 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 importing from an existing post or page edit view, follow the same steps.

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 #

Easily migrate individual WooCommerce products between websites 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. Enter a file name when prompted, then 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 #

Once the import is complete, you’ll see a message:

‘Inserted Post ID. Click Here for the 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.

Flash Sale! Get 20% OFF

WP Ultimate CSV Importer Premium!

Copy-paste the code at checkout.

Hurry! Limited time only!

Flash Sale! Get 20% OFF

For Vtiger and Suite CRM Products

Copy-paste the code at checkout.

Hurry! Limited time only!