CSV Import for WordPress

Description

WP Ultimate CSV Importer is an import and export tool that helps to build a WordPress site at the drop of a hat by importing Post, Page, Custom Post, Users, Comments, WordPress Custom Fields & CustomPress fields, Reviews of WP Customer Reviews and SEO fields of All in One SEO. The plugin supports export and import of all Custom Post Types. The import is for selective modules, but the export is for all the core modules along with few third party plugins.

The image can be imported from external URL like Google image, pixabay, shutterstock, etc,. The images are imported in the background with the help of WP-CRON to enhance the performance. You can easily configure your WP-Cron for faster import.

Please show your support for WP Ultimate CSV Importer by giving it a rating 🙂

Modules supported in Import and Export

  • Core Modules – Post, Page, Custom Post, Comments and Users.
  • Custom Post – CPT UI, CustomPress and default WordPress Custom Post.
  • Custom Field – CustomPress, WordPress default Text & Textarea fields of Types, Pods, etc,.
  • SEO field – Free version of All in One SEO.
  • Reviews – WP Customer Reviews

Modules supported in Export

  • Core Modules – Category, Tag, Custom Taxonomy, Customer Reviews, Comments.
  • eCommerce Products – WooCommerce, MarketPress, WP e-Commerce.
  • Custom fields and SEO fields imported along with these modules can be exported.

Highlighted Feature

  • High performance rocket speed import.
  • Imports image from an external URLs.
  • Optimized database with enhanced duplicate handling.
  • WordPress core custom fields can be dynamically registered on the flow of import.
  • Import static & dynamic content on the flow of import.
  • Post type import with terms & taxonomies with any of depth of parent-child values.
  • Send email to newly imported User with auto generated password information.
  • Can be used in WordPress multisite.
  • Post Type import along with multi category & multi tag.
  • CSV with any delimiter in UTF-8 format can be imported.
  • Exports all the imported files of different modules with filters.

Note

  • The Users module is disabled in multisite.
  • Featured image from password protected image location can’t be imported.
  • All languages supported by WordPress can be imported in UTF-8 without BOM format.

Ultimate CSV Importer PRO

Ultimate CSV Importer PRO has all the features of WP Ultimate CSV Importer and it is extended with a lot of features that enables to import, schedule, update and export CSV files. The import details over a year is in dashboard chart to easily track the site updates in a fraction of a second. Any changes like modifying existing content or appending new content can be done in simple update flow. You can also update or import periodically with scheduler. The update or schedule is done with the templates which is created with mapped fields in the mapping section of the import. The export option enables to export the imported modules as CSV based on the filters.

Supported Modules To Import and Export

  • Core Module – Post, Page, Custom Post, Comments, Category, Tags, Users, Customer Reviews.
  • eCommerce Products – WooCommerce, MarketPress, WP e-Commerce & eShop.
  • SEO field – Free & Pro version of All in One SEO and Yoast SEO.
  • Multilingual – WPML & qTranslate X
  • Image – NextGEN Gallery
  • Events Management – Events Manager FREE & Pro
  • Custom fields – CustomPress, ACF, Types, Pods, CCTM & WordPress default Text & Textarea fields.
  • Custom Post – CustomPress, Types, Pods, CPT UI, CCTM & default WordPress Custom Post.

Highlighted Feature of PRO

  • Import image from external URL along with the advanced SEO option.
  • Rename featured image loaded from external URL.
  • Import CSV from FTP and SFTP location.
  • WPML & qTranslate X add-on support.
  • Supports WooCommerce product import along with 6 WooCommerce add-on.
  • Imports products of MarketPress Lite & PRO version add-on.
  • Registers Custom Fields of ACF (FREE & Pro), Types, Pods and WordPress fields in the flow of import.
  • Imported modules can be managed in the File manager.
  • Detailed logs are maintained in the Log manager.
  • Duplicate handling with any of the WordPress field.
  • Import all the supported features of WP Ultimate CSV Importer with Rest API.
  • Extendable for your needs with API.

Helpful Links

Documentation.

Watch our product video
You can try the live demo or request for free trial by clicking Try Now in WordPress Ultimate CSV Importer page to generate your own WordPress test environment.

Read our blog to know more about the new features of our WordPress plugins.

FAQ and Troubleshooting tips

Screenshots

  • Dashboard view of the importer.
  • Upload section of CSV.
  • Simple Drag and Drop mapping.
  • Mapping view of the uploaded CSV fields with WordPress fields.
  • Detailed real-time log.
  • Settings with php.ini details.
  • Downloadable log manager for all imported events.
  • Export module with filters.

Installation

  1. Extract the wp-ultimate-csv-importer.zip in wordpress/wp-content/plugins using FTP or with plugin install in wp-admin.
  2. Activate the plugin in WordPress plugin list.

FAQ

Common Issues
  1. What are reasons for my import to break?
    Import may hang due to the following reasons

    • CSV not properly validated.
    • CSV not properly encoded to UTF-8.
    • System Requirements are not matched the required values.
  2. How to validate a CSV?
    WP Ultimate CSV Importer allows you to import CSVs that are validated. So kindly validate your CSV using CSV Lint. Your CSV may have any escape characters and misplaced skip characters which may cause the import to cease.

  3. What are the supported CSV Formats?
    WP Ultimate CSV Importer recognizes only the UTF-8 encoded characters. You can check on the UTF-8 encode with CSV Lint. Any chance if you are using Excel, we recommend you to use Google Sheets. Excel will miss some characters to be encoded to proper UTF-8.

  4. What are the Minimum Requirements needed to upload CSV?
    Basic System Requirements need to be met to upload a CSV with bulk of records. Kindly check your System Requirements by Settings → Security and Performance on WP Ultimate CSV Importer plugin. You have to increase the system requirements values to the minimum values mentioned in the plugin.

  5. Why my featured images not getting uploaded?
    The importer uploads images in the background for faster performance and it requires WP-Cron to be enabled. You can easily configure WP-Cron for smooth and speedy import.

  6. What are the supported custom fields in FREE version?
    The importer supports default WordPress Text and Text area fields of Types, Pods, etc,.. You can also import the Text & Text area fields created with custom codes in WordPress standards.

For more FAQ, you can refer here.

Reviews

Not reliable, full of spam, got broken

Beside the UX it’s painful, it has worked till I’d to actually deliver the post_type.
It keep retrieving:
“Undefined variable: template_mapping in wp-ultimate-csv-importer/admin/views/form-advanced-mapping-configuration.php on line 193”

Amazing plugin

Perfect for bulk import of data, even for custom posts with a lot of customizations

Just does what it is meant to do

Works as intended. A minor bug that I notice is – the advanced mapping maps the csv fields more accurately than Normal mapping in case of date fields.

Does what is says

one of the most usefull plugins out there, if it comes to import/export data, swap data among 2 wordpress installations etc.

a few clicks and your work is safe / imported onto another installation.

I mostly use it do get taxonomies from my development server to productions server. It amazes me every time, when i have to populate about 100 categories in under 5 seconds.

Keep up the good work !!!

Saved my Butt

Previous .csv tool was not writing custom fields to database. Read about WP Ultimate CSV Importer in a help forum, it saved my butt by enabling me to be home for dinner on time. Problem solved. Thinking about upgrading to the Pro version now. Dinner was delicious.

Read all 201 reviews

Contributors & Developers

“CSV Import for WordPress” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

5.2

  • Added: Advance mapping view with Drag ‘n’ Drop support.
  • Added: Ultimate member plugin support for Users Import.
  • Fixed: Issue with Post format.
  • Fixed: Month order in dashboard charts.
  • Added: Latest version support on All In One SEO 2.3.12.1.
  • Added: Compatibility for WordPress 4.7.3.

5.1.1

  • Fixed: Broken when SCRIPT_DEBUG is true. Solved.
  • Fixed: Issue in duplicate handling to skip the duplicate records.
  • Added: Missing font “glyphicons-halflings-regular.woff2”.
  • Removed: Unwanted console warnings.
  • Added: Compatibility for WordPress 4.7.2.

5.1

  • Added: Language Support for German, French, Italian, Spanish, Dutch & Russian.
  • Added: Restriction to show “Admin dashboard widget” only for users with Admin role. Solved
  • Added: Notice to enable wp-cron to populate the feature images. Solved.
  • Added: Warning messages to notify when uploads directory is missing, insufficient permission to access and uploaded file size exceeds your server limits.
  • Added: Duplicate handling feature to skip the duplicate records.
  • Added: Canonical URL support in All in One SEO data import.
  • Improved: CSV export performance.
  • Fixed: All custom fields in WP installation adding to a Post. Solved.
  • Fixed: Mixing up of Custom taxonomies while assigning a term to Post. Solved.
  • Fixed: Adding unwanted data before and after post content. Solved.
  • Fixed: Issue with Post Category & Tags export.
  • Fixed: Missing up of SEO fields in mapping section.
  • Fixed: Issue in exporting All in one SEO fields.
  • Fixed: Issue in assigning page template (wp_page_template).
  • Removed: Warnings in migration script.

5.0.3

5.0.2

  • Added: Compatibility from PHP 5.3.

5.0.1

  • Fixed: WP Customer Reviews import feature.

5.0

  • Added: Compatibility for WordPress 4.7 and PHP 7.
  • Added: Option to replace imported CSV file value with static and dynamic value.
  • Added: Image image import from external URL
  • Added: Send email to newly imported User with Password Information
  • Added: Any Custom Post Type import.
  • Added: Post Type import with terms & taxonomies with any depth of parent-child hierarchy.
  • Improved: High speed import with enhanced UI.
  • Improved: User role import with capability value or role name in CSV

3.11.1

  • Fixed: Browse button disappears in 3.11.0 https://wordpress.org/support/topic/browse-button-disappears-in-3110

3.11.0

  • Added: Compatibility for WordPress 4.5.3.
  • Added: menu_order field Import for Custom Post Type.
  • Added: Support for comma and pipeline separation in multi category & taxonomies import.
  • Added: Compatibility to export WooCommerce fields with WooCommerce version 2.6.1.
  • Updated: Help links of Product page & Live Demo.
  • Fixed: Issues in Taxonomies, Categories & Tags export.
  • Fixed: Issue in export by status filter.

3.10.0

  • Improvements: Can export any number of records from WordPress site.
  • Fixed: Issue in ACF relationship field export.

3.9.4

  • Improvements: Duplicate image handling. Option to skip or rename image as image_name-number if image name is same as existing media image name.

3.9.3

  • Added: Compatibility for WordPress 4.5
  • Fixed: Environment issue with custom port id in MAMP.

3.9.2

  • Modified: CSVParser Engine with SmackCSVParser, a high-speed robust parser.

3.9.1

  • Added: Post parent now supports for post title and post name.
  • Fixed: jQuery conflicts.

3.9

  • Added: PHP 7 compatibility.
  • Added: Support for all post date formats.
  • Fixed: Featured image and Inline image naming issues.
  • Fixed: Auto mapping issues in Custom Fields and SEO Fields.

3.8.8

  • Added: Localize script for multi-language support.
  • Added: WordPress 4.4.1 compatibility.
  • Improved: Code cleanups with WordPress standards.
  • Fixed: Vulnerability security issue.
  • Fixed: Export issue.
  • Fixed: Custom Taxonomy import issue.
  • Fixed: User mail notification on new user imports.
  • Fixed: Category & Tag import issue in eShop module.
  • Removed: Mod security check.

3.8.6

  • Added: Compatibility for WordPress 4.4.
  • Modified: Support page UI.
  • Fixed: Post date issue.
  • Fixed: Custom Post Type listing issue.

3.8.5

  • Added: Restriction to view the image without password for protected status content.
  • Modified: Settings page UI.
  • Fixed: post_status mandatory validation issue.
  • Fixed: SEO Fields mapping issue.
  • Fixed: Known issues in export.
  • Fixed: Mandatory validation issues.
  • Fixed: Console TypeError issue.

3.8.4

  • Modified: Changed the Dashboard view.

3.8.3

  • Added : Text domain for language translation system.
  • Fixed : Detect duplicate issue.

3.8.2

  • Added : Compatibility for WordPress 4.3.1.
  • Added : Grouped core custom field in mapping section.
  • Added : Image import with spaces in image name.
  • Fixed : Module entry count in dashboard issue.
  • Fixed : Duplication of image in media gallery.

3.8.1

  • Added : Compatibility for WordPress 4.2.3 and 4.2.4.
  • Added : Export by specific date and author option in comments.
  • Fixed : warnings triggered in console.
  • Fixed : XSS vulnerability.
  • Removed : ../../../../../../wp-load.php and replaced with WordPress Ajax call.
  • Removed : Direct usage of wp-content.

3.8

  • Added : Multi language support (fr_FR,es_ES,nl_NL).
  • Added : Inline image handling with shortcode along with image attributes.
  • Added: Any delimiter support for CSV export.
  • Fixed: Warnings and bugs Fixes

3.7.4

  • Added : WordPress 4.2.2 compatibility.
  • Fixed : Allow Editor/Author to import.(Multisite also).

3.7.3

  • Fixed: Vulnerability security issue.

3.7.2

  • Added: WordPress 4.2 and 4.2.1 compatibility.
  • Fixed: Blank page issue conflicts.

3.7.1

  • Added: Security fix for curl.
  • Added: Security fix for session status.

3.7

  • Fixed: Featured image hot link issue.

3.6.78

  • Added: Hot security fix in readfile.php.

3.6.77

  • Added: WordPress 4.1.1 compatibility.
  • Improved: Inline image import feature.
  • Added recursive method to assign the image.
  • Fixed: Featured image naming issue. Solved
  • Removed: Warnings.

3.6.76

  • Improved: Post Format.
  • Fixed: Export eShop content issue.
  • Fixed: Import with image name issue.
  • Fixed: Groups plugin conflict.

3.6.75

  • Added: Terminate & Continue option in import.
  • Improved: Log section.
  • Fixed: Web View & Admin View issue.
  • Fixed: Security issue in export module.

3.6.74

  • Fixed: Security issue.

3.6.73

  • Added: WordPress 4.0 compatibility.
  • Added: https format support for all WP instances.
  • Added: Warning to guide user to create uploads directory with writable permissions.
  • Improved: Security and performance tab under settings module.
  • Fixed: Featured image handling issues.
  • Fixed: Multisite compatibility issue.
  • Fixed: All console warnings.
  • Removed: Post Content field mandatory option.

3.6.72

  • Added: Debug mode enable/disable options.
  • Modified: Menu order changes.

3.6.71

  • Fixed: Minor bugs.

3.6.7

  • Added: Export features for all missing modules.
  • Fixed: All console warnings and reported logs.

3.6.6

  • Fixed: Dashboard chart issue in multi site.
  • Modified: UI to improve usability.
  • Fixed: Groups plugin conflicts.

3.6.5

  • Added : Inline image support with advanced media handling.
  • Added: PDO check.

3.6.4

  • Added: WordPress 4.0 compatibility.
  • Added: Advanced export features with filter options.
  • Improved: Advanced log section.
  • Fixed: jQuery issues.

3.6.3

  • Added: eShop import support.
  • Added: WordPress 3.9.2 compatibility.
  • Fixed: Conflicts with other plugins.

3.6.2

  • Fixed: Hot security issue.

3.6.1

  • Fixed: Multi-site support issue.
  • Fixed: Duplicate import issue.
  • Fixed: Security issue.

3.6

  • Added: Interactive graphs and charts in plugin dashboard.
  • Added: Admin dashboard widgets.
  • Added: Users and comments export feature.
  • Added: Auto delimiter handling.
  • Added: Auto mapping feature.
  • Added: Allow authors to access import features.

3.5.5

  • Added: post_format attribute support.
  • Added: page_template attribute.
  • Added: update_post_meta for duplicate meta issue
  • Fixed: TypeError issue in jQuery.

3.5.4

  • Added: All in One SEO Pack import support.
  • Added: WordPress 3.9.1 compatibility.

3.5.3

  • Added: Compatibility for WordPress 3.9.
  • Added: Export feature for Posts, Page, Custom Post.
  • Fixed: Reported bugs
  • Removed: all warnings.

3.5.2

  • Import posts with author names as numerical apart from User ID
  • Added: menu_order attribute import
  • Added: Auto image rename option
  • Option to cancel an partial import at middle
  • Improved image handling even special characters in URL
  • Import can handle image URLs without any extensions
  • User reported bugs fixed

3.5.1

  • User reported issue fixes
  • Activation and other plugin conflict issue solved like Jet pack
  • Admin UI freezing issues – screen option, Help links issues fixed.
  • WYSIWYG editor UI issue fixed.

3.5.0

  • Combined major release version of 3.5 and 3.4
  • Improved MVC structure.
  • Improved User interface with drag and drop feature.
  • Improved: WordPress 3.8.1 compatibility added.
  • Module based system allows simplify UI
  • Added: Detailed log feature added.
  • Added: Support and Useful links added.
  • Added: Support made easy now from plugin.

3.3.1

  • Added: Multisite compatibility except User import.
  • Added: Comments, Users modules mandatory fields validation added.
  • Improved: Removed unwanted warnings.

3.3.0

  • Added: WordPress 3.8 compatibility.
  • Added: Bulk users with role import feature.
  • Added: Comments import feature with relevant post ids.

3.2.3

  • Added: WordPress 3.7.1 compatibility added.
  • Added: Different media path support added.
  • Added: Sub folder installations support added.
  • Improved: Updated plugin directory path.
  • Improved: Removed unwanted warnings.
  • Improved: Performance check.

3.2.2

  • Added: WordPress 3.6.1 compatibility added.
  • Added: Mapping UI improved with on select dynamic update feature
  • Added: Help content added
  • Fixed: Post slug issue fixed and tested for 3.6 and 3.6.1

3.2.1

  • Improved: Performance improvements on SQL and CSV parsing
  • Fixed: Plugin deactivation issue fixed and updated the code.
  • Fixed: Links in the cells makes problems with the “quote”
  • Fixed: Loading content from more than one column
  • Fixed: Custom Post type issues fixed

3.2.0

  • Improved: User interface improvements
  • Improved:WordPress 3.6 compatibility added, Much Improved UI.
  • Fixed: Featured image issues fixed for WordPress-3.6.

3.1.0

  • Improved: Much Improved Featured Image feature
  • Fixed: Image URL for featured image issues fixed
  • Fixed: PHP 5.4 upgrade fix

3.0.0

  • Added: Category in numerics are restricted and skipped to Uncategorized
  • Added: Protected status password inclusion as {password}.
  • Added: Post authors can be User ID or name
  • Improved: Much improved work flow
  • Improved: Add custom field option improved.
  • Improved: Date format handling improved
  • Improved: Any Date format is supported now
  • Improved: Future scheduling and status improved
  • Improved: Can apply post status for individual post via CSV itself
  • Improved: Featured image handling improved and fixed. More improvement are scheduled.
  • Improved: Duplicate check options improved for both title and content option.
  • Improved: Post author issue fixed and improved
  • Improved: Wrong user id or name are automatically assigned under admin
  • Improved: Multi category and tags improved
  • Fixed: Custom Field mapping and import fixed
  • Fixed: Overall Status option improved and issue fixed
  • Fixed: Password field fixed for Protected
  • Fixed: Status as in CSV option improved and fixed

2.7.0

  • Added: Added more post status options
  • Added: Publish, Sticky, Private, Draft and Pending Status for whole import
  • Added: Protected status with a common password option added
  • Added: “Status as in CSV” to assign status for individual post through CSV as ID or Field Tag
  • Added: User ID and User Name support for Post author feature added
  • Added: In case of missing or false IDs post assigned to admin as draft
  • Added: Add Custom Field Text box auto-filled with CSV header tag.
  • Added: Duplicate detection for post content and post title added as options.
  • Added: User can choose either one or both to avoid duplicate issues.
  • Improved: 6 Standard date format added as drop down to choose.
  • Improved: Renamed post_name as post_slug to avoid confusion
  • Improved: Mapping Fields
  • Improved: Field tags are formatted to support auto mapping option (next milestone)
  • Improved: Listed custom fields with prefix as CF: Name for easy identification.
  • Fixed: Date format conflict at import fixed.

2.6.0

  • Fixed: Major Bug fixed
  • Fixed: Added UTF-8 support.
  • Fixed: Fixed HTML tag conflicts.

2.5.0

  • Major issues fixed and updated to WordPress-3.5.1 compatibility.

2.0.1

  • Update to WordPress-3.5 compatibility.

2.0.0

  • WPDEBUG errors fixed. CSV import folder changed to WP native uploads folder.

1.1.1

  • Renamed the mapping field attachment as featured_image and category as post_category.

1.1.0

  • Added featured image import feature along with post/page/custom post.

1.0.2

  • Bug fixed to recognize the trimmed trailing space in the CSV file
  • Added validation for the duplicate field mapping.

1.0.1

  • Added features to import multiple tags and categories with different delimiters.

1.0.0

  • Initial release version. Tested and found works well without any issues.