The top-rated WordPress plugin to import and export WordPress users and WooCommerce customers.
Description
The most-rated WordPress User Import Export plugin ever! This plugin allows you to easily import and export WordPress users and WooCommerce customers. It lets you migrate to a new website without losing your users or customers, quite literally.
You can import or export user/customer data using CSV files. This helps in migrating or updating user data on your website.
🔸 Import/export user/customer data based on user roles, user email, and date range of when the users were added to the system.
🔸 Batch Export/Import for easier processing of data
🔸 Retain user passwords (optional)
🔸 Export WordPress users with passwords
🔸 Map and transform fields while importing customers/users
🔸 Change values (bulk modify) while importing user data using Evaluation Fields
🔸 Export guest users - Include data of WooCommerce guest customers (users who bought products from the site without creating an account).
🔸 Export specific users based on username/email - Suggests email addresses and names in export data filter fields while you type in.
🔸 Tested OK with WordPress 6.1
🔸 Tested OK with WooCommerce 7.5
🔸 Tested OK with PHP 8.0
How does it work?
This WordPress user import export plugin uses CSV (Comma-Separated Values) files as input. You must create a CSV file and enter the user details in a structured format. (refer to this sample CSV) This is to match each field of the user import CSV file to the appropriate user fields in WordPress.
For example, the user_email field gets mapped to the User Email. Otherwise, the admin needs to manually map the import user CSV fields.
For the plugin to work correctly, you must map the headers of all the column correctly and you must ensure that all of the fields you enter is in the correct format.
You can create the CSV from the scratch or you can export the user CSV using the same plugin. You can use a spreadsheet program, such as Microsoft Excel, OpenOffice, LibreOffice, or Google Spreadsheets for creating and modifying the CSV file. Save this file in UTF-8 encoding with extension .csv.
After entering all details about users in a spreadsheet, you can bulk import users to WordPress. With this plugin, you can also export and download user details as a CSV file.
For more information about the setup of the plugin, refer to this article: WordPress Users & WooCommerce Customers Import Export Plugin - User Guide.
Watch the video on getting started with the plugin.
Why choose us? =
WebToffee creates quality WordPress/WooCommerce plugins that are easy to use and customize. We are proud to have millions of customers actively using our plugins across the globe.
Hear it from our users
> danielepais (@danielepais) ⭐⭐⭐⭐⭐
> Great tool especially if you need to select a batch of users and some account details but not all, with this plugin you can filter what to output on your comma separated CSV file.
> Allan Klinbail (@aklinbai) ⭐⭐⭐⭐⭐
> After working for a couple of months on a new site from scratch, I didn’t want to have to issue password resets for all users.
This allowed me to move them all, easily and simply.
> benlumi (@benlumi) ⭐⭐⭐⭐⭐
> I transfered all my customers to my new website in no time and without any stress. Many options available to do the job.
Perfect ! Thank you 😀
Premium version Features
✅ Import and export WordPress users and WooCommerce customers.
✅ Supports multiple file formats like CSV, XML, and Excel (XLS, XLSX).
✅ Option to choose all roles or multiple roles while exporting.
✅ Various filter options (User Roles, User Email, Date Range, Offset/Limit, Guest Users, Ascending/Descending Sort) for exporting customers/users.
✅ Map and transform fields while importing WooCommerce customers.
✅ Map and transform fields while exporting WooCommerce customers.
✅ Apply conditions to change values of the fields while importing customers using Evaluation Fields.
✅ Export user meta (custom fields and hidden metadata supported in addition to other user data)
✅ Choice to update or skip existing imported customers.
✅ Bulk update existing customers/user data.
✅ Choice to send or skip emails for newly imported customers.
✅ WPML Supported.
✅ Import and export users/customers to/from a remote server via FTP in scheduled time intervals with Cron Job.
✅ Supports importing user CSV from URL & Google sheets.
✅ Third-party plugin compatibility.
✅ Compatible with BuddyPress, Ultimate Member, Ultimate Membership Pro, Better Notifications for WP, Advanced Custom Fields (ACF), etc.
✅ Excellent Support with a 99% customer satisfaction rate.
✅ 30-day money-back guarantee.
Please visit Import Export WordPress Users & WooCommerce Customers for more details.
Export WordPress users and WooCommerce customers to CSV
This WordPress user export plugin enables you to export WordPress users and WooCommerce customers to a CSV file. You can use this CSV file to migrate users/customers to another website with the Import users functionality of this plugin.
If you have hundreds, even thousands, of WordPress users, the export users option in the plugin helps to save your effort and time of manually adding the user data.
You can bulk export user data to a CSV file with multiple powerful filters such as user roles, date ranges, etc.
Import WordPress users and WooCommerce customers from CSV
With this WordPress user import plugin, you can easily import hundreds or thousands of WordPress users and WooCommerce customers to your website using a CSV file. The plugin lets you bulk import or merge (update existing users) on your WordPress website.
The WordPress import users plugin also has the option to send an email to the users and customers whenever the admin imports/updates users' details. It enables you to securely migrate your users’ passwords from one website to another.
You can map your import columns to the appropriate WordPress data to import or merge user details. You can also import data from a variety of sources, such as an uploaded CSV file on FTP (Premium), a locally saved CSV file on your computer, or from a URL, Google sheet, etc.
For importing WordPress users’ and WooCommerce customers’ data to your website, you must create a CSV (Comma-Separated Values) file which contains information about mapping fields in a tabular form. You can create a CSV file by using a spreadsheet program, such as Excel, or Google Spreadsheets. Save this file with the extension '.csv'. After entering all details about WordPress users in the spreadsheet, you can import users or customers to your website.
Import/Export/Migration Plugins for WooCommerce from WebToffee
🔸 WooCommerce Product Import Export Plugin: Easily import and export products to/from your WooCommerce store using a CSV file.
🔸 WooCommerce Order/Coupon/Subscription Import Export: The plugin lets you export and import orders and coupons via CSV to and from your WooCommerce store.
🔸 WordPress Backup & Migration: Quickly migrate and backup entire WordPress site or selected files from one location to another. Backup to FTP, Google Drive, Amazon S3, or local storage and easily restore them.
Installation
Minimum Requirements =
- PHP Version: 5.6 or later
- WordPress version: 3.0 or later
- WooCommerce version: 3.0 or later
Steps to install the plugin
To install the plugin, follow the below steps:
Step 1: Log in to your WordPress dashboard.
Step 2: Navigate to Plugins and select Add New.
Step 3: From the search box, type "Import export WordPress users" or "Import export WooCommerce customers" and click Search Plugins.
Step 4: Once you find the Import Export WordPress Users and WooCommerce Customers plugin by WebToffee, click on Install Now.
Step 5: After installation, click Activate to activate the plugin.
You can also install the plugin by downloading the zip file from the plugin page on WordPress.org. Then upload the file directly from your WordPress dashboard, or using an FTP application.
Plugin Updates
For every update of the plugin, you will be notified of the installed plugins page. You can directly update the plugin from your dashboard. We recommend that you keep the latest version of the plugin so that you can avail of the new functionalities and security features.
Frequently Asked Questions
Does this plugin export users to excel?
This plugin exports user data to CSV which can be opened with Excel and saved as an Excel file.
Does this plugin support multiple roles?
Yes. You can export import users along with multiple user roles.
Does this plugin export WooCommerce customer data?
Yes, you can export WooCommerce customer data.
Does this export users with passwords?
Yes. This plugin will export users with passwords.
Does this import users with their passwords?
Yes. This plugin will import users with the password, so users can use the same old password in the imported site as well.
Does this plugin support WooCommerce customer order CSV export?
No. You may want to use Order Export & Order Import for WooCommerce for this purpose.
Do Import Export WordPress Users support Multisite?
Yes, the plugin supports exporting users from each sub-sites of the multisite network.
Does this plugin export custom data fields?
This version of the plugin does not support the import or export of user custom data fields. It is one of our premium features. Please have a look at the premium version of the plugin to export and import custom metadata fields.
Can this plugin update existing user data?
Yes, you can update the existing user data by setting the option: 'If the user exists in the store' to 'Update' in the Advanced options during import.
Imported customers are not listed under WooCommerce customers
Please refer the article on how to refresh WooCommerce customers list.