Import/Export Users is a tool that allows site admins to manage their users through a .csv file editable in spreadsheet programs like Excel. With this file, admins can quickly setup or edit the details of dozens of users and commit all changes with a single upload. It is particularly useful for sites with large numbers of users. Moreover, this tool is supported by all themes and all sites.
Go to Tools > Import/Export Users. Click the Export Users button.
This will create a .csv file of all current users, and download that to your computer. You can then edit this file in spreadsheet programs like Excel. You can edit any information about existing users and add new users by adding new rows.
It is important that you do not rename, rearrange, add, or delete any columns. If the .csv file is not formatted correctly, the 'import users" function will not work.
Go to Tools > Import/Export Users. Choose the .csv file that you would like to import. The file must be in the exact same format as the one created by the export tool.
Select the Import Users button and the site will update the information of all users and create new users if needed.