Do you want to import and export WordPress users from one website to another?
This can be very helpful when you want to merge multiple websites and automatically move all users to the new website.
In this article, we are going to show you how to easily import and export users in WordPress. We'll also show you how to import exported WooCommerce customers.
Why or when may you need to import and export users in WordPress?
While there are various use cases for importing and exporting WordPress users, the most common scenarios where you need to import and export users are:
When you are buying a website and want to bring its content and user base together.
When you want to consolidate two websites and merge their content and user base.
When you want to import customer information into an email list or your CRM.
If you run a membership website or a WooCommerce store, you may also want to keep all of your customer details and give your customers a seamless login experience on the new website.
Let's take a look at how you can easily import and export users from one WordPress site to another, or move WooCommerce customers from one store to another.
Export users to WordPress
First, you need to install and activate the plugin for importing and exporting users and customers. For more information, see our step-by-step guide on installing a WordPress plugin.
After activation you have to visit the Tools »Import and export users and customers Page in the WordPress administration area and switch to the Export tab.
Here you can choose which users you want to export. For example, you can select by user role and export WooCommerce customers, customers from your membership plugin, or all users.
You can also filter users by date. For example, you can select users who were created between a certain period of time.
You can leave the rest of the options at their default values and click the Download button. The plugin prepares a CSV file and downloads it to your computer.
CSV, or Comma Separated Values, is a file format that allows you to save data with fields separated by commas. You can open these files in any spreadsheet software such as Google Spreadsheets or Microsoft Excel.
Import WordPress users
The plugin also makes it easy to import the users to the same website or another website.
If you are importing the users to another WordPress website, you will need to install the plugin on that website as well.
After that you can go to Tools »Import and export users and customers Page and switch to the "Import" tab.
Here, click on the "Select file" button to select the previously downloaded CSV file.
Below you can configure plugin settings according to your own requirements. For example, you can only import users with certain user roles, choose what to do with empty data fields, send emails to users with a login link and their login information, and much more.
After reviewing the options, click the Start Import button.
The plugin starts importing WordPress users and shows you a list of imported users.
You can go now User »All users Page to see the imported users.
Sending email to imported users
If you move user accounts, you may want to notify them of the change by sending them an email. The plugin can do this for you during the import, but you may want to change the email with your own message.
Just go to the Tools »Import and export users and customers Page and switch to the Mail Options tab.
By default, the plugin sends the login information to the users in the email. You can add your own message here to give users more information about why they are seeing this email.
Tip: Make sure your WordPress site can send email notifications. If you have a lot of users / customers, the plugin may not be able to send notifications. We recommend using the WP Mail SMTP plug-in to ensure maximum deliverability. For more information, see our guide on how to troubleshoot WordPress not sending emails.
We hope this article has helped you easily import and export WordPress users and WooCommerce customers. You might also want to check out our guide to monitoring user activity in WordPress and our ultimate WordPress security guide to protecting your website.
If you enjoyed this article, please subscribe to our YouTube channel for WordPress video tutorials. You can also find us on Twitter and Facebook.