What's WP
Find Everything Related to WordPress - Best Tutoriasl on WordPress!
How to Export and Import WordPress Users from One Site to Another

How to Export and Import WordPress Users from One Site to Another

When you transfer your WordPress site or merge multiple sites into the single platform, you have to import and export several things. In most cases, these include the files, images, database and SEO settings. However, if your site allows the user registration or is a membership website, you also need to export and import WordPress users from the existing ones to the old sites.

From the following contents, you can know how to do this easily. But before the detailed steps, we’d like to note that you need to backup the whole site, especially for your user information to avoid some unexpected cases.

How to Export and Import WordPress Users

Firstly, you need to export the information of your WordPress users. Here, you cannot rely on the default WordPress tool of Export, which can be got by hitting the Tools > Export button. After all, this tool only allows you to export the contents for your website media, pages and posts.

When it comes to the export of user information, you need to leverage the Cimy User Manager plugin. With it, you can easily export users to the CSV files.

Here, you can directly click the Users tab once you have installed this plugin, and then, you need to press the Cimy User Manager button. From this page, you can find two main parts, which are the Import Users part and the Export Users part.

Export WordPress Users

Now, you need to scroll down to the export option. Here, you firstly can find the upload path that is used to store the CSV file containing the user information. Note that this plugin will make sure that this path is totally writeable.

Export WordPress Users

Next, you can select the field delimiter and the text delimiter for the CSV file. By default, this plugin uses commas and quotes to separate field and text respectively. However, if you’d like to use this file in somewhere else, you can change the values as you like.

Now, you should determine how to sort the rows in the exporting file. Note that you have the options to sort based on user registration date, login name, email address, post count, website URL and the displayed name.

Lastly, if you are looking to use the CSV file with the tool of Microsoft Excel, you can enable the special Excel Compatibility mode.

As every part is determined properly, you can click the Export button now. This way, this plugin will automatically export all your user information, and then, save the data on your server using the CSV file. Once you have checked the success message along with a download button, you can click that button to save the file on your local computer.

Import WordPress Users

As for the importing of WordPress users, you still need the help of this plugin. In this case, you firstly should make sure that you already have it installed on the site that you are looking to import users. And then, you can visit the Cimy User Manager page again and navigate to the Import Users part this time.

Import WordPress Users

Here, you can select the previously downloaded CSV file for uploading and choose the proper delimiters for field and text.

In addition, you need to remember to check the box for creating the users using the information and data from the CSV file. Also, you can choose to use the email notification function. This can send your users the new account information easily.

Now, you can click the Import button directly to finish the whole process.


Susan Rose is a freelance writer who has a deep knowledge about WordPress. She loves everything related to website building since the freshman year at Christopher Newport University, and loves to share her experience with people all over all the world. In the daily life, Susan loves detective novels as it can train her logical thinking and creativity.