Updating Users through an import

Updating an existing User through import is largely the same as adding new Users. First, go to the admin section then select Imports:

Then Users:

Then under Download Import Template select Existing Users Import Template:

An Excel template will be created with a column for each of your user fields. This is the same as the import file made for new users, but the email column at the start of the file is used as a unique identifier for the users:

This column is what is used to map each of the users that you are updating to the correct existing user. Now using one line for each User fill in your details and save.  Note that you do not need to fill in every field, only the ones you want to update. If you leave a field blank in the csv it will not clear the existing data in the User, it will just be ignored.

To update the email address of a user you can add the new email under column New Email. You will need to put the current email into the Email column to identify the user and then the new email for the user under the New Email column.

For an example in the below import file the user's current email is [e-mail] and the new email is [e-mail]. Once the import is successfully completed the email address of user Sumeet Chauhan will be replaced with [e-mail].

Once you are done click on Upload Data and select Update Existing Users to import your file: