Import & Export WordPress Data to CSV

Description

Ultimate CSV Importer provides all the necessary Import and Export features in one bundle with simplified steps to follow. Option to add exporter, woocommerce and User import as addons. You have to install to use these features.

Add below addons from your WP Admin

Export any WordPress data
Product Import Export for WooCommerce
Import Export WordPress Users

How to import data to your WordPress?

There are 3 simple steps to follow,

  1. Upload your CSV/XML file. Auto delimitter support for “,” , “\t” , “|” , “;” , “:” are added
  2. Relate or map your CSV fields with WP fields using drag and drop or simple left/right pick list method.
  3. Click import once done.

There are more features bundled to make even complicated post data import simplified.

1.Upload your CSV

  • Upload your CSV file from different sources like desktop, FTP/SFTP, remote URLs or a location from your host server.
  • CSV, Zip, txt and XMl data (pro) file types supported.
  • Once uploaded, choose New items if you want to import as new posts.
  • Choose existing option in case to import the data to update or replace existing posts records.
  • Pick a post type like Post, Page, Custom Post, Comments or any other from the drop down.
  • This is under which post type your data get imported.
  • It can be a complete post content replacement or partial update like selected set of fields for each post in CSV.
  • Click continue button.

2.Relate or map your CSV fields to WP fields

In mapping section, CSV Importer plugin allows you to relate the uploaded data set against WordPress fields. There are two methods available to relate your data set.

  • A simple left and right drop downs that allows you to map CSV field with the related WordPress fields.
  • You can choose each field from left side and assign a field from right to where it should go.

Drag ‘n’ Drop method

  • You can visually drag field by field from the right side bar and drop it to post create view like place holder.
  • For e.g. you can drag title filed and drop it under post title box.
  • To make it easier you can see both field label and sample record in side bar, which allows you to understand how data placed.
  • In top side bar header, you can rotate this sample records by choosing a row item no. in case the default sample data is not helpful.
  • Now the post_content field is mush improved.
  • Can drag and drop multiple columns to post content.
  • Also a wysiwyg editor is added to manage text with styles manually.

3. Click Import

  • Once the mapping completed, click import to start the import process.
  • In import view, you can pause and resume the import process.
  • A section shows post count and status of successful imports with a timer.
  • A log section shows you detailed real time log of the process step by step.
  • Log is downloadable using the link provided.

What can you import to WordPress

Core Modules – Post, Page, Custom Post, Comments.
Users – Import Users add-on to import your WordPress Users
Custom Post – CPT UI, Custom Press and default WordPress Custom Post.
Custom Field – WordPress default Text and Text area fields.
SEO field – Free version of All in One SEO.
Reviews – WP Customer Reviews

Highlights

  • High performance, much comparable & much faster than all the other available plugins.
  • Can handle 1000s of records on the fly, now without editing max. execution time in php.ini
  • Supports WordPress Custom Fields, Custom Press fields, WP Customer Reviews and All in One SEO fields.
  • Media images from any external URL like Google Images, pixabay, shutterstock, or any domain you own can be imported.
  • Import with duplicate handling for optimized database.
  • Free add-on to Import Users to upload user info into WordPress.
  • WordPress core custom fields registered dynamically on the flow of CSV import.
  • Post type import with terms & taxonomies with any of depth of parent-child values.
  • WordPress multisite import supported.
  • Post Type CSV import along with multi category & multi tag.
  • Import CSV with “,” , “\t” , “|” , “;” , “:” delimiters in UTF-8 format can be imported.
  • Free export add-on to export all your WP content in CSV file.

Important Notes

  • Featured Image import processed from the background using WP-CRON to improved the performance.
  • All languages supported by WordPress imported in UTF-8 without BOM format.

Other useful tools

  • Dashboard
  • General settings >> Scheduled log emails, send password in users get imported etc.
  • Database optimization
  • Security and performance monitoring
  • Manager >>File manager, log manager
  • Support >> Documentation

Premium Features

  • CSV and XML import
  • Reusable Mapping Templates with Template manager
  • Reusable featured image option, can use the same for multiple post without downloading.
  • Option to switch between media downloadable or avoid importing media files from remote URLs used in post content body
  • Smart Schedule/Recurring Import to run import periodically without any manual interaction.
  • Toolset Types Import – Custom fields, Post Relation, Intermediate post, Repeatable Field & Repeater Field Group support
  • Multilingual import – support for the import of WPML & qTranslate X add-on
  • WooCommerce product import along with six WooCommerce add-on
  • Handles Custom Fields of ACF (FREE & Pro), Types, Pods and WordPress fields with the flow of import
  • Import history i.e. detailed log maintained in the Log manager.
  • Import all the supported features with Rest API.
  • Extendable for your needs with API.

HELPFUL LINKS

Documentation

Try our live demo here

Request a free trial by visiting here and Click Try Now option to generate your own WordPress test environment.

For samples and tutorials, visit our blog

Screenshots

  • Dashboard view of the importer.
  • Upload section of CSV.
  • Simple Drag and Drop mapping with post content editor
  • 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.

FAQ

  • What is a csv file?
    A csv or comma separated value file is a simple text based file format to store tabular data. In general, a character like a comma used as a separator between commas separated values as tables.

  • How to open or edit csv file?
    A csv file could be edited in any program like notepad or notepad+. However, a spreadsheet editor like MS Office, Open Office Calc is more useful to directly edit as tabled structure.

  • What are the types of CSV files?
    Most common type is csv or comma separated value file. The other one is delimited file where a character like a tab or a semicolon used instead of comma as a delimiter.

  • What is csv file format?
    There are different file formats available based on encode like ANSI, UTF-8, UTF-8 without BOM, USC-2 BE BOM and USC-2 LE BOM. For WordPress, the default format will be UTF-8 and for non-Latin character data, UTF-8 without BOM used.

  • How to validate a CSV?
    You can validate a csv file using CSV Lint. Your CSV may miss escaping characters and misplaced/skipped character, which may cause the import to cease. Validate any csv file for issues or warning and fix them before importing it to WordPress.

  • How to import content to WordPress?
    Import to WordPress done in different methods based on content source type, platform, and file types. The most common types of imports are XML, CSV and DB files.

  1. Xml method needs advanced knowledge to edit/update them in case of any changes required on source data. Otherwise, users are limited to do import without any changes to source file. Hence, editing done post by post in WordPress only possible after import.
  2. CSV methods allow any users with basic excel or any spreadsheet knowledge can audit, change, edit or update the data visually in bulk before importing. So painful manual works avoided and time saved. Also, CSV file is the most preferred method for any offline programs.

Reviews

October 23, 2019
The free plugin works great but has its limitations. The paid version doesnt work at all. CSV Validation errors, they sent me a fix, told me not to use the fix, said they will send another fix and nothing. Cant import blog posts with images. Free version works fine, paid one cant import featured images. Cant update existing posts and products. Stays at 0% complete. Compolete waste of money, will be contacting PayPal and getting a refund.
October 17, 2019
I purchased the Premium version. I had problems due to some particular settings of my server. I thought, and now what I do. I tried to contact support. They worked for three days and solved all the problems. Really a serious company you can rely on. If you need a plugin to import your data, this is the most complete one I've tried. Allows you to import, specially if you use woocommerce and WPML, all translations all with a few clicks. You can even automate the processes. Recommended!!!
September 17, 2019
This is a great tool, have been using it for a while. I had a little issue with Toolset image import where it downloaded the image locally instead of keeping the URL provided in the CSV. Support got me a workaround in 24 hours - what more can you ask!
Read all 336 reviews

Contributors & Developers

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

Contributors

“Import & Export WordPress Data to CSV” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “Import & Export WordPress Data to CSV” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

6.0.3

  • Added: Import post_content image without downloaded into media option
  • Added: post_content editable option in drag and drop mode
  • Added: Improved bulk import engine without max. execution time edit
  • Added: csv and text file import support with accepted delimiters(, , \t , | , ; , 🙂
  • Fixed: plugin home page ui issue with php version 5.5

6.0.2

  • Fixed: posts import struck in first record
  • Added: support for image import through google drive
  • Fixed: CPT-UI with product category import issue
  • Fixed: minor issues & warnings

6.0.1

  • Added: Upload support for txt file
  • Improved: UI Improvements – process image for in send button in support page
  • Improved: UI – Show export tab by default. If user have not installed the exporter plugin, It contains the download link.
  • Improved: UI – In plugins page inside csv importer. If a plugin is installed show it as already installed.
  • Fixed: : Timer not stopping after import issue.
  • Modified: Changed video url in documentation. In settings changed “file_uploads” and “allow_url_fopen” to “on” instead of 1.

6.0

  • Improved: user interface and performance.
  • Added: Header Manipulation fields can now hold static text content along with any CSV header content.
  • Added: Media upload section to import Image from computer.
  • Added: progress bar for desktop upload.
  • Fixed: : WordPress core custom fields issue.

5.6.2

  • Added: support for remote url without extensions

5.6.1

  • Added: WP CSRF Protection

5.6

  • Added: Compatibility for WordPress 5.0

5.3.7

  • Removed: Registering custom field in mapping section.

5.3.6

  • Added: Compatibility for WordPress 4.9.8
  • Added: Import Post parent import with Post Title
  • Fixed: : Post export redirection issue.
  • Fixed: : Post slug import in drag and drop method.

5.3.5

  • Added: Support for serialized data import.
  • Added: Compatibility for WordPress 4.9.6
  • Improved: Usability and user interface.
  • Fixed: : Insertion of hyperlinks in WYSIWYG editor in drag and drop mapping.

5.3.4

  • Improved: Notifications in mapping
  • Fixed: : Export menu issue.

5.3.3

  • Added: Compatibility for WordPress 4.9
  • Moved: User import as add-on.
  • Removed: Export

5.3.2

  • Added: Add-ons support
  • Moved: User import as add-on.
  • Removed: Export

5.3.1

  • Modified: Hide the filter based on Condition.
  • Fixed: : data loss when page refresh (export).
  • Fixed: : warning during Upload.
  • Fixed: : user export above 1000 records.
  • Fixed: : Custom Field Suite issue.
  • Fixed: : Forced quotes issue.

5.3

  • Added: Prevent loss of mapping data
  • Added: Custom field group plugin support
  • Added: Maintenance mode
  • Added: Inclusion feature
  • Updated: Exclude selection as include selection in export module
  • Fixed: : User import
  • Fixed: : Delimiter issue
  • Fixed: : Advance mapping issues
  • Fixed: : Post status in Mapping
  • Fixed: : Featured image in Mapping
  • Fixed: : Post comment in Mapping
  • Fixed: : Export page radio button based on plugin activation
  • Fixed: : Comment Export
  • Fixed: : Text changes

5.2

  • Added: Advance mapping view with Drag and 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, and 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 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 postdate 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: : Postdate 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 short code 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 multisite.
  • 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 any 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 numeric 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 workflow
  • Improved: Add custom field option improved.
  • Improved: Date format handling improved
  • Improved: Any Date format 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.