Knowledge Base

How to import CSV in WordPress

With WP Ultimate CSV importer, you can easily import or update posts, pages, custom posts, taxonomies, etc with the CSV, XML, or Excel files in WordPress. Choose the data type you need to import and Map the incoming data fields with their corresponding WP core fields.  You can edit or filter the incoming data elements. In this guide, we will learn how to import CSV to WordPress.

Step 1: Create a New Import for WordPress #

To create a new WordPress import, navigate to WP Ultimate CSV importer -> Import or update. Then, upload your import file directly from the desktop, URL, or FTP/SFTP.  

Import-Posts-Import-Update

Then select Fresh import or Existing. If you want to import additional data from the posts already published on your site, click Existing. If you need to import the new data to your website, then select Fresh Import.

Choose the Data types you want to import such as Posts, Pages, Taxonomies, Custom posts, Categories, Woocommerce Products, Variations, etc. from the drop-down.

Import-post-New-Post-Import

Step 2: Map the fields with a simple drag-and-drop method                                                 #

All the fields of the import file will be displayed on the left side menu. Whereas, the data fields you need to import will be on the right side. You can drag the right widget from the left side of the field menu and drop it on the desired fields on the right side.

For example: Drag the post title from the left menu and drop it exactly on the post title field on the right side.

Import-posts-Mapping-drag-and-drop-mode

Advanced Mode:

You can also map fields with the advanced mode by selecting the appropriate fields from the drop-down menu.

Import-Posts-Mapping-Advanced-Mapping


Note: You can map as many or as few fields as you wish based on your needs. 

Step 3: Configure the import file #

Once done with the Mapping, you will lead to the manage media uploads.  Here you can specifically choose the media handling on your data import. Choose whether you need to use media images if already available overwrite the available images or Always create a new image. 

With efficient media handling, you can download the post content external images to media.

Import-Posts-Manage-media-uploads

Then configure the import settings of your import file, by enabling the Safe backup before import (Roll Back option). 

Also, it’s flexible to enable the maintenance mode while in the Import process and handle duplicate records on existing import files.

Import-Posts-Import-configuration-settings-on-post-update

Step 4: Run the Import #

Run the Import if you are done with the media handling and Import configuration settings. Now your imported file has started to import on your WordPress site. Once the import is completed, you can verify whether your desired file has been accurately imported on your WordPress site

Import-Posts-Run-Import-for-new-posts

For example, if you have imported the posts, then verify the imported file by navigating to the Posts -> All Posts.

Advanced Topics  #

Save your Import template- and use the saved template as you need #

WP Ultimate CSV importer allows you to save the import template and settings of the existing data import. And that saved template can be used for future/new import processes. 

Since, Mapping plays an important role in efficient data import, saving the mapping template will save your time and effort on mapping the same data every time you import. 

To save the import template, Follow the step 2. Once done with the mapping, provide the template name and click on Save.

Now on importing any new file to WordPress , Step 2 will show the saved import template screen with its settings (If the file name is same as old import file name). You can use the saved template for the new import or you can create a new template by clicking on the Create new mapping option.

Export-Posts-Use-template

Schedule WordPress Data Import #

WP Ultimate CSV importer allows you to schedule your import process based on your needs. In Step 4, Configure the import process, enable the Schedule option, and then provide the Scheduled, date, time, frequency, and time zone to schedule the import process.

Import-posts-Schedule-post-import

WordPress Data Import- Frequently Asked Questions #

How to import a CSV file in WordPress? #

Data Import in WordPress is the same as for all file types. Just browse your CSV file on the Import/update widget on WP ultimate CSV importer. Our plugin will recognise the file types and proceed with the import process accordingly.  There is not any specific format to import CSV. Moreover, CSV is the most common file format for data import in WordPress. 

How to import XML files using WP ultimate CSV importer? #

The data import process is the same as in the above steps. You need to upload an XML file in the Browse file section given in Step 1. Then, follow the other steps to import your XML files in WordPress.

Can I import Custom Posts in WordPress? #

Yes. It is easy to import the custom post by simply selecting the Custom post types that you need to import in the data types section in Step 1. Follow the subsequent steps explained in the above guide to import custom posts to your WordPress site.

How to import my Website data into the WordPress site #

To import your website data into the WordPress site, you need to have a valid import file in CSV/XML/TXT/JSON format. If you don’t have the file to be imported, you can export your Website data using the Export option on WP Ultimate CSV importer. Upload the exported file and follow the import process given in the above steps.

How to export WordPress data as CSV files? #

To export the CSV file from the WordPress site, 

  • Navigate to the Ultimate CSV importer -> Export
  • Choose the desired data type. For example, posts
  • Provide the file name and choose the file type as CSV
  • You can download your Post csv as Google sheet data by enabling the “Export data in Google sheet”
  • You can configure the advanced filters based on your business needs to export your desired posts in the desired format.
  • Enable the Schedule option to export the data at your preferred time.
  • Once done click on Export.
  • Now your desired posts on your WordPress site will be exported successfully as CSV files.

Does WP Ultimate CSV importer support the data import of  Woocommerce products? #

Yes, WP Ultimate CSV importer supports the data import of almost all aspects of Woocommerce products such as variations, categories, prices, images, stock level, etc.

What are the supported third-party plugins for WP ultimate CSV importer? #

Below are the supported third-party plugins for the WP Ultimate CSV importer:

eCommerce Plugins

  • WooCommerce Import Suite
  • WP eCommerce

WooCommerce Import

  • Product
  • Variations
  • WooCommerce Orders
  • WooCommerce Coupons
  • WooCommerce Refunds

WooCommerce Addons

  • WooCommerce Subscriptions
  • Chained Products
  • Pre Orders
  • Product Retailers
  • Product Addons
  • Returns & Warranty Request
  • Product Bundles

Supported Custom Fields Plugins

  • ACF Free & PRO
  • CMB2
  • Toolset Types
  • Pods
  • Custom Fields Suite(CFS)
  • CCTM
  • JetEngine
  • MetaBox

Custom Post Plugins

  • Custom Post Type UI
  • Toolset Types
  • Pods
  • CCTM
  • JetEngine
  • CFS
  • CMB2
  • MetaBox

Multilingual Plugins

SEO Plugins

  • Yoast SEO Free & Pro
  • All In One SEO Free & Pro
  • Rank Math SEO Free & Pro
  • SEOPress Free & Pro

Membership Plugins

  • WP-Members
  • Members
  • Ultimate Member

LMS plugins

  • LearnPress
  • Lifter LMS
  • MasterStudy LMS

Other Supported Plugins

  • Events Manager Free & Pro
  • WP Customer Review
  • bbPress
  • NextGEN Gallery
  • WP Job Manager
  • Featured Image from URL
WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

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