WPBeginner

Beginner's Guide for WordPress

  • Blog
    • Beginners Guide
    • News
    • Opinion
    • Showcase
    • Themes
    • Tutorials
    • WordPress Plugins
  • Start Here
    • How to Start a Blog
    • Create a Website
    • Start an Online Store
    • Best Website Builder
    • Email Marketing
    • WordPress Hosting
    • Business Name Ideas
  • Deals
    • Bluehost Coupon
    • SiteGround Coupon
    • WP Engine Coupon
    • HostGator Coupon
    • Domain.com Coupon
    • Constant Contact
    • View All Deals »
  • Glossary
  • Videos
  • Products
X
☰
Beginner's Guide for WordPress / Start your WordPress Blog in minutes
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

WPBeginner» Blog» Plugins» How to Easily Import and Export WordPress Users

How to Easily Import and Export WordPress Users

Last updated on October 29th, 2020 by Editorial Staff
314 Shares
Share
Tweet
Share
Pin
Free WordPress Video Tutorials on YouTube by WPBeginner
How to Easily Import and Export WordPress Users

Do you want to import and export WordPress users from one website to another?

This could be really helpful when you are merging multiple sites and want to automatically shift all users to the new site.

In this article, we will show you how to easily import and export users in WordPress. We’ll also show you how to import export WooCommerce customers as well.

Importing and exporting WordPress users and WooCommerce customers

Why or When You May Need to Import and Export Users in WordPress?

While there are several use-cases for importing and exporting WordPress users, the most common scenarios when you need to import and export users are:

  • When you purchase a website and want to merge the content and user base.
  • When you want to consolidate two sites 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 WooCommerce store, then you may also want to keep all your customer data and allow your customers a seamless login experience on the new site aswell.

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.

Exporting Users in WordPress

First thing you need to do is install and activate the Import and Export Users and Customers plugin. For more details, see our step by step guide on how to install a WordPress plugin.

Upon activation, you need to visit the Tools » Import and export users and customers page in WordPress admin area and switch to the Export tab.

Export WordPress users and WooCommerce customers

From here, you can choose which users you want to export. For instance, you can select by user role and choose to export WooCommerce customers, customers from your membership plugin, or all users.

You can also filter users by date. For instance, you can select users that were created between a specific period.

You can leave the rest of the options to their default values and click on the Download button. The plugin will prepare and download a CSV file to your computer.

CSV or ‘Comma Separated Values’ is a file format which allows you to store data with fields separated by commas. You can open these files in any spreadsheet software like Google Spreadsheets or Microsoft Excel.

Importing WordPress Users

The plugin also makes it easy to import the users back to the same website or a different website.

If you are importing the users to a different WordPress website, then you’ll need to install the plugin on that website as well.

After that, you can go to the Tools » Import and export users and customers page and switch to the ‘Import’ tab.

Import WordPress users / WooCommerce customers

From here, click on the ‘Choose File’ button to select the CSV file you downloaded earlier.

Below that, you can configure plugin settings to your own requirements. For instance, you can import only users with specific user roles, choose what to do with empty data fields, send emails to users with login link and their credentials, and more.

After reviewing the options, go ahead and click on the ‘Start Importing’ button.

The plugin will start importing WordPress users and will show you a list of users imported.

Imported users in WordPress

You can now go to Users » All Users page to see the imported users.

Sending Email to imported users

Now, if you are moving user accounts, then you may want to let them know about the change by sending them an email. The plugin can do that for you during the import but you may want to change the email with your own message.

Simply head over to the Tools » Import and export users and customers page and switch to the Mail Options tab.

Send user email

By default, the plugin sends the login details to the users in the email. You can add your own message here offering users more details about why they are seeing this email.

Tip: Make sure your WordPress site is able to send email notifications. If you have a lot of users/customers then the plugin may not be able to send notifications. We recommend using the WP Mail SMTP plugin to ensure maximum deliverability. For details, see our guide on how to fix WordPress not sending email issues.

We hope this article helped you easily import and export WordPress users and WooCommerce customers. You may also want to see our guide on how to monitor user activity in WordPress and our ultimate WordPress security guide to keep your website safe.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

314 Shares
Share
Tweet
Share
Pin
Popular on WPBeginner Right Now!
  • How to Properly Move Your Blog from WordPress.com to WordPress.org

  • Revealed: Why Building an Email List is so Important Today (6 Reasons)

    Revealed: Why Building an Email List is so Important Today (6 Reasons)

  • Google Analytics in WordPress

    How to Install Google Analytics in WordPress for Beginners

  • How to Start Your Own Podcast (Step by Step)

    How to Start Your Own Podcast (Step by Step)

About the Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Trusted by over 1.3 million readers worldwide.

The Ultimate WordPress Toolkit

22 Comments

Leave a Reply
  1. Enzo Williams says:
    May 17, 2020 at 7:20 pm

    Im having some issues as i have 81,000 users trying to export to a csv. Which by my guess is several MB it keeps coming up with an error before task can complete.

    Reply
    • WPBeginner Support says:
      May 19, 2020 at 8:57 am

      More than likely it is taking too long, you may want to try the recommendation in our article below:
      https://www.wpbeginner.com/wp-tutorials/how-to-fix-fatal-error-maximum-execution-time-exceeded-in-wordpress/

      Reply
  2. Lourenço says:
    Oct 14, 2019 at 7:37 am

    If some users already exist – what will happen?

    Does it overwrite them?

    Regards.

    Reply
    • WPBeginner Support says:
      Oct 14, 2019 at 11:22 am

      You would want to reach out to the plugin’s support for the specifics on how that would be handled :)

      Reply
      • Lourenço says:
        Oct 14, 2019 at 4:12 pm

        Thanks I will.

        Regards.

        Reply
  3. Sarah Webster says:
    Aug 6, 2019 at 5:16 pm

    Hi there

    If I export all users to a new site, will their passwords remain the same?

    Thanks!

    Reply
    • WPBeginner Support says:
      Aug 7, 2019 at 10:20 am

      Unless I hear otherwise, the passwords should remain the same

      Reply
  4. michael says:
    May 21, 2019 at 5:14 pm

    hello I am lost. I made a website for our club some years ago. the members have passwords to see the content of the page.
    now I updated the site and moved the web host (same URL) . Now I want

    a) to move / migrate the database including the passwords our members have assigned themselves some years ago (and forgot about them).
    b) have them active right away, so there is no problems for the members top go in their page.

    Does this work?
    Michael

    Reply
    • WPBeginner Support says:
      May 22, 2019 at 11:11 am

      For moving hosts you could take a look at our guide here: https://www.wpbeginner.com/wp-tutorials/how-to-move-wordpress-to-a-new-host-or-server-with-no-downtime/

      When you move the site and users over, they can use the reset password option to get their passwords back or you could use the plugin in our article here: https://www.wpbeginner.com/plugins/how-to-reset-passwords-for-all-users-in-wordpress/

      Reply
  5. Sarah says:
    Apr 24, 2019 at 4:05 pm

    Can i use this on a multisite? I tried to export users in a subsite of a multisite, and the export button takes me to the dashboard without downloading the export file.

    Reply
    • WPBeginner Support says:
      Apr 25, 2019 at 10:21 am

      You would want to reach out to the plugin’s support for the specifics of how to use it on multisite.

      Reply
  6. Chad says:
    Mar 4, 2019 at 8:04 pm

    Thank you so much! This plugin was awesome for moving users from a main site to a subdomain prior to transfer.

    Reply
    • WPBeginner Support says:
      Mar 5, 2019 at 11:32 am

      You’re welcome :)

      Reply
  7. beth jansen says:
    Oct 3, 2018 at 10:13 am

    Will the plug in create new users, assign passwords, and email them?

    Reply
    • Ando says:
      Feb 8, 2019 at 5:06 am

      Yes, it’s doing all those options.

      Reply
  8. Marin L says:
    Sep 21, 2018 at 5:24 am

    How can I import absolute new users. So they don’t exist yet. Is the email and first and last name enough?

    So I have a page made on WordPress and no WooCommerce. It’s just a page.

    Reply
  9. Stephen says:
    Sep 3, 2018 at 3:27 pm

    Does you plugin enable you to IMPORT Gmail and Yahoo contact lists into a WordPress site ?
    Many thanks
    Stephen

    Reply
    • WPBeginner Support says:
      Sep 3, 2018 at 5:45 pm

      Hi Stephen,

      It can do that. First you will need to export your contacts list in CSV format. Now install the plugin and export your current users, the plugin will generate a CSV file. You need to open this file in a spreadsheet program like Google Sheets or Excel. Notice the arrangement of columns. Now open your contacts list CSV file and arrange the columns in the same way using spreadsheet software. Now save this CSV file and try importing this file using the plugin.

      Reply
  10. Lenawa says:
    May 26, 2018 at 1:55 pm

    Hello

    Same problem as Alan , getting this error

    keep getting cant insert user without email

    Reply
  11. Alan says:
    May 16, 2018 at 11:21 am

    Doesn’t work! keep getting cant insert user without email

    Reply
  12. Paul J says:
    Apr 25, 2018 at 11:34 am

    Hello, I was wondering if this plug-in also exports/imports usermeta data

    Reply
    • WPBeginner Support says:
      Apr 25, 2018 at 7:12 pm

      Hi Paul,

      The pro version will be able to do that, please plugin website for details.

      Reply

Leave a Reply Cancel reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Over 1,320,000+ Readers

Get fresh content from WPBeginner

Featured WordPress Plugin
TrustPulse
TrustPulse
Instantly get 15% more conversions with social proof. Learn More »
How to Start a Blog How to Start a Blog
I need help with ...
Starting a
Blog
WordPress
Performance
WordPress
Security
WordPress
SEO
WordPress
Errors
Building an
Online Store
Useful WordPress Guides
    • 7 Best WordPress Backup Plugins Compared (Pros and Cons)
    • How to Fix the Error Establishing a Database Connection in WordPress
    • Why You Need a CDN for your WordPress Blog? [Infographic]
    • 30 Legit Ways to Make Money Online Blogging with WordPress
    • Self Hosted WordPress.org vs. Free WordPress.com [Infograph]
    • Free Recording: WordPress Workshop for Beginners
    • 24 Must Have WordPress Plugins for Business Websites
    • How to Properly Move Your Blog from WordPress.com to WordPress.org
    • 5 Best Contact Form Plugins for WordPress Compared
    • Which is the Best WordPress Popup Plugin? (Comparison)
    • Best WooCommerce Hosting in 2021 (Comparison)
    • How to Fix the Internal Server Error in WordPress
    • How to Install WordPress - Complete WordPress Installation Tutorial
    • Why You Should Start Building an Email List Right Away
    • How to Properly Move WordPress to a New Domain Without Losing SEO
    • How to Choose the Best WordPress Hosting for Your Website
    • How to Choose the Best Blogging Platform (Comparison)
    • WordPress Tutorials - 200+ Step by Step WordPress Tutorials
    • 5 Best WordPress Ecommerce Plugins Compared
    • 5 Best WordPress Membership Plugins (Compared)
    • 7 Best Email Marketing Services for Small Business (2021)
    • How to Choose the Best Domain Registrar (Compared)
    • The Truth About Shared WordPress Web Hosting
    • When Do You Really Need Managed WordPress Hosting?
    • 5 Best Drag and Drop WordPress Page Builders Compared
    • How to Switch from Blogger to WordPress without Losing Google Rankings
    • How to Properly Switch From Wix to WordPress (Step by Step)
    • How to Properly Move from Weebly to WordPress (Step by Step)
    • Do You Really Need a VPS? Best WordPress VPS Hosting Compared
    • How to Properly Move from Squarespace to WordPress
    • How to Register a Domain Name (+ tip to get it for FREE)
    • HostGator Review - An Honest Look at Speed & Uptime (2021)
    • SiteGround Reviews from 4464 Users & Our Experts (2021)
    • Bluehost Review from Real Users + Performance Stats (2021)
    • How Much Does It Really Cost to Build a WordPress Website?
    • How to Create an Email Newsletter the RIGHT WAY (Step by Step)
    • Free Business Name Generator (A.I Powered)
    • How to Create a Free Business Email Address in 5 Minutes (Step by Step)
    • How to Install Google Analytics in WordPress for Beginners
    • How to Move WordPress to a New Host or Server With No Downtime
    • Why is WordPress Free? What are the Costs? What is the Catch?
    • How to Make a Website in 2021 – Step by Step Guide
Deals & Coupons (view all)
TranslatePress
TranslatePress Coupon
Get 15% OFF on TranslatePress WordPress translation plugin.
MainWP
MainWP Coupon
Get 15% OFF on MainWP WordPress multisite manager plugin.
Featured In
About WPBeginner®

WPBeginner is a free WordPress resource site for Beginners. WPBeginner was founded in July 2009 by Syed Balkhi. The main goal of this site is to provide quality tips, tricks, hacks, and other WordPress resources that allows WordPress beginners to improve their site(s).

Join our team: We are Hiring!

Site Links
  • About Us
  • Contact Us
  • FTC Disclosure
  • Privacy Policy
  • Terms of Service
  • Free Blog Setup
  • Free Business Tools
  • Growth Fund
Our Sites
  • OptinMonster
  • MonsterInsights
  • WPForms
  • SeedProd
  • Nameboy
  • RafflePress
  • Smash Balloon
  • AIOSEO

Copyright © 2009 - 2021 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by SiteGround | WordPress Security by Sucuri.