How to guide for free wordpress ultimate csv importer plugin

How to import data from an existing CSV into WordPress as Page, Post or any Custom Post Types using WP Ultimate CSV Importer plugin in seconds. Download Free Plugin from wordpress.org

wp csv importer

The Pro version of the Ultimate CSV Importer plugin has many more features like

  1. Bulk products import for WP-eCommerce plugin in a few clicks.
  2. Bulk products import of e-shop plugin in a few clicks.
  3. Custom Taxonomy
  4. Bulk Nested Categories import.

And more flexible features like the update, delete already uploaded post on single click and duplicate detection, etc. Please refer to relevant posts for the detailed features of PRO Version of Ultimate CSV Importer.

Please don’t forget to give your rating and feedback for these free plugin.

So many major improvement changes, more flexible import options and added powerful features.   

A plugin that turns your offline data as WordPress post, page or custom post data’s by simple mapping feature as a csv file import.

WP Ultimate CSV Importer Plugin helps you to import any CSV file as post, page or even as a custom post type. Convert your offline database maintained for years into your valuable website content. Also do periodical content changes, maintenance, content update, prices, offers, coupons, and inventory, etc.

Watch This Helpful Youtube Video Playlist

This simple but ultimate plugin as you can import everything needed to create as any WP post types from admin as simple as CSV file. Just in few clicks to map your CSV data set to match the WordPress fields to import. That’s all, now your imports are turned as WordPress site content in a matter of seconds. No more pain of creating post content one by one of converting your offline data. You can import all the essential data as WordPress post and skip unwanted things. Or you can import as many as custom fields without missing even a single data. Provided you should have a theme that supports custom fields. So you can now make use of your offline data, inventory, price catalog, information data, database and any other excel datasheet for online content distribution to your valuable visitor or customers.

1.    Admin can import the data from any CSV file.
2.    Can import as post, page or custom post.
3.    Compatible with Custom post type UI plugin support
4.    It can define the type of post and post status while importing.
5.    A powerful mapping feature enables importing the data as perfect WordPress post types.
6.    Users can map column headers to existing fields or create and assign as unlimited custom fields.
7.    Import unlimited data as any post type.
8.    Make an imported post as published, private, pending, draft, sticky or even as password protected.
9.    Define different post status for every individual post via CSV.
10.    Add featured image Url to every post.
11.    Assign authors to every post.
12.    Add title, content, excerpt, and slug to posts
13.    Assign multiple tags and categories to post
14.    Non existing tags and categories are created automatically
15.    Assign date of publishing either a previous date or futures date for scheduled publishing.
16.    Skip Duplicate titles or content or both to avoid duplicates at time of import itself
17.    The only option we missed is post format, which will be added in the next major update.

Important Notes:  
You can schedule your post for future publishing automatically by mentioning future date and time in the date field of a particular post in your csv file.
Your theme should support featured image function. If not, please add the following code to header.php or where you need to display.     add_theme_support( ‘post-thumbnails’ );
You can follow the instructions as given here http://codex.wordpress.org/Function_Reference/the_post_thumbnail http://codex.wordpress.org/Post_Thumbnails http://wordpress.org/support/topic/featured-image-not-showing-7?replies=5

Posts and Pages Module – This module will import all your data into bulk posts or pages. There are 9 fields to map, in which post title and content are mandatory. All other fields are optional. You can also have a published date field which can also have a future date that reflects a scheduled post. Optionally you can import as many fields you want as custom fields. You can name these fields as your wish while importing. Pages don’t need categories and tags. You can assign a featured image for each post or page through a list of image URLs.

Custom posts – Similar to post and pages you can import any custom post types that is configured in your WordPress. You can also assign a featured image for each post created.

The pro version of this plugin is available now with a lot more new features, functionality, controls, and improved usability. Please upgrade to the pro version to enjoy the powerful features like importing nested categories, WP-eCommerce products, eShop products, custom taxonomies in bulk with simple clicks. For more powerful features upgrade to the pro version of ultimate csv importer plugin have many more features like

  • One-click Import of Nested category with complex hierarchies to any no. of levels with proper description and SEO slugs
  • One-click Import of bulk tags with proper description and SEO slugs
  • One-click Import of Users with roles
  • One-click Import of Custom taxonomies with proper description and SEO slugs
  • Import, update and maintain your WP Commerce / eshop inventory, prices, periodical, and short term offers, coupons, bonus, etc.

How to install ultimate csv importer plugin in WordPress

Wp Ultimate CSV Importer is very easy to install like any other WordPress plugin. No need to edit or modify anything here.

  1. Unzip the file ‘wp-ultimate-csv-importer.zip’.
  2. Upload the ‘ wp-ultimate-csv-importer ‘ directory to ‘/wp-content/plugins/’ directory using FTP client or upload and install
    wp-ultimate-csv-importer.zip through plugin install wizard in wp-admin panel
  3. Activate the plugin through the ‘Plugins’ menu in WordPress.
  4. After activating, you will see an option for ‘Wp Ultimate CSV Importer’ in the admin menu (left navigation) and you will import the csv files to import the data.

Most Frequently Asked questions

Why Wp Ultimate CSV Importer?

To import bulk data to post/page/custom post types. This plugin supports. Upcoming versions will support eCommerce import, social publishing and many.

How to install the plugin?

Like other plugins, wp-ultimate-csv-importer is easy to install. Upload the wp-ultimate-csv-importer.zip file through the plugin install page through wp-admin. Everything will work fine with it.

How to use the plugin?

After plugin activation, you can see the ‘ Wp Ultimate CSV Importer ‘ menu in the admin backend.a. Browse csv file to import the data. b. Select the post type or post/page to import as. b. Map each header to the relevant fields using the dropdowns to import. c. If import as the draft option is checked, the post will be in draft mode.

How to define the multiple tags and categories?

In CSV, tags should be separated by “,” to import multiple tags and categories should be separated by “|” to import multiple categories.

How to choose featured image to import?

Match the column contains URL paths to images to the Attachment field from the drop-down. Configuring our plugin is as simple as that.

How to create/edit csv file?

Any csv editor like MS Excel will work well. Better to convert/create from any spreadsheet details like excel.

How should the csv file look like?

Please see attached sample csv file.

How to use separators in the csv file?

You can use , or ; as separators. You can choose the delimiter at the time of import.

How to define multi-category or tags?

To define a multi-category or tags use pipeline(|) symbol as a separator. Multi categories – Use pipeline symbol as a separator to have Multi categories. You can use category name directly not the ID. If no matching category is found, the new category will be created for the same. Eg: Category 1|Category 2|Category 3|Category 3To Create Multi Tags – same as category

What fields are mandatory?

post type, post_title, post_body are mandatory. All others are optional and defaults are applied in some cases.

How to use date and time field?

Use the format “yyyy-mm-dd hh:mm:ss” for date and time.

How to schedule posts?

You can schedule posts automatically by giving a future date/time in a date field for each post.

How to assign an author for each post?

The already created author ids can be used.

For eg: 1 for admin, 2 for user

2. To assign authors for each post you should mention relevant author id for each post in csv before import.

For quick response and reply please create issues in our support instead of the WordPress support forum.

 

New Planned Features

These features are on the final stage of development and testing. Once passed minimum testing scores, updates will be released ASAP. Please stay in touch for new release updates.

  • Bulk upload of categories, tags, and users with roles.
  • Duplicate post detection.

How to import content to WordPress with advanced features? What is the advanced mapping?

Even it is simple to go with normal post properties, there are more advanced mapping features available in WordPress Ultimate CSV Importer Plugin. You control each and every field, the property of a post just like while creating it manually in wp-admin. You need to prepare your csv slightly to make these features available to you.

How to use advanced mapping features?

For a simple import post title and content is sufficient to create a successful import. All other fields are optional that set to default as in WordPress. To have more control over it, as in the above image you can add more fields in CSV as prescribed for WordPress Ultimate CSV Importer Plugin. You can add post_excerpt, post_status, post_author, etc as the below-listed format

post_excerpt – text max. characters is wp default

How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags part 1
How to import content to WordPress WordPress Ultimate CSV Importer Plugin field tags part 1

post_date – any date format and should be the future date to get scheduled for publishing.

post_category – can be | separated for multiple categories and case sensitive

post_tag – can be comma-separated for multiple tags and case sensitive

post_author – as user id or name and case sensitive. Mismatches are set to Admin

How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags featured image
How to import content to WordPress WordPress Ultimate CSV Importer Plugin field tags featured image

featured_image – should be a full valid URL path and image must exist

How to import content to wordpress WordPress Ultimate CSV Importer Plugin field tags part 2
How to import content to WordPress WordPress Ultimate CSV Importer Plugin field tags part 2

post_slug – WordPress default (small letters, spaces replaced by hyphens)

post_parent – assign a post imported as a child to a post id

CF : {custom_field} – existing Custom fields with their label (WP Custom Fields only)

Add Custom Fields – to add a new custom field and import with a label

post_status – You can choose from drop-down to set an overall status for the whole import

To set the status for each data you import, mention the values as below

Publish (default)

Sticky

Pending

Private

{your_password}

Draft

The missing fields like Post format, Send Trackbacks and Discussion will be added in upcoming versions.

What is automapping in WordPress Ultimate CSV Importer Plugin? 

Auto mapping is a hands-free mapping feature introduced from version 3.0.0. Just replace the CSV headers with relevant auto map headers and save it to use as a template csv file. WordPress Ultimate CSV Importer Plugin can identify these headers and automatically map your fields with relevant WordPress fields. This feature will almost eliminate the pain of mapping each and every time, in particular with many no. of fields.

Where to get the sample csv files for Wordpress Ultimate CSV Importer Plugin?

You can view this post thread for regularly updated sample csv files and news. Also, you can browse this download folder directly

Cookies help us deliver our services. By using our services, you agree to our use of cookies.