Import & Export WordPress Data to CSV

Description

Ultimate CSV Importer fournit toutes les fonctionnalités d’importation et d’exportation nécessaires en un lot avec étapes à suivre simplifiées. Notez que les ajouts d’exportation, de WooCommerce et d’import d’utilisateur sont disponibles sous forme de modules. Vous devez les installer pour utiliser ces fonctionnalités.

How to import data to your WordPress?

There are 3 simple steps to follow,

  1. Upload your CSV/XML file.
  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.

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 in 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.
  • 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.
  • Image import processed from the background using WP-CRON to improve the performance.
  • 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 any delimiter 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 from any publicly accessible external URL.
  • 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
  • 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

Captures d’écran

  • 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.

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.

  • Comment ilmporter du contenu dans WordPress ?
    Importation vers WordPress effectuée selon différentes méthodes basées sur le type de source de contenu, de plate-forme et de fichier. Les types d’importation les plus communs sont les fichiers XML, CSV et BDD.

  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.

Avis

17 septembre 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!
11 septembre 2019
I was looking for a plugin to export custom post types created by Toolset and this is the only plugin that actually does the job! Amazing and a huge time saver!! Thanks!
23 août 2019
this plugin is really perfect for importing large databases and it is perfectly compatible with ACF, YOAST and CPT so I highly recommend it. The after-sales service is responsive and professional
22 août 2019
Unlike other CSV Importers, this plugin does not offer support for anything other than a "," delimited file. Pipes, Tabs, colons etc are not supported. FYI. Support is slow.
Lire les 331 avis

Contributeurs & développeurs

« Import & Export WordPress Data to CSV » est un logiciel libre. Les personnes suivantes ont contribué à cette extension.

Contributeurs

“Import & Export WordPress Data to CSV” a été traduit dans 1 locale. Remerciez l’équipe de traduction pour ses contributions.

Traduisez « Import & Export WordPress Data to CSV » dans votre langue.

Le développement vous intéresse ?

Parcourir le code, consulter le SVN dépôt, ou s’inscrire au journal de développement par RSS.

Journal

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.