Update multiple password using a CSV File

Problem

You want to know how to reset the password for some or all users.

Environment

  • Admin console

Solution

  1. Sign in to the Admin console.
  2. Go to Menu > Directory.
  3. Click Users.
  4. Click Bulk Update users
  5. Download a blank CSV file.
  6. Open the file using Google Sheets or save the file as a Google sheet.
  7. Update all the information on the Google sheet. A sample information that needs to be updated: 
    First Name:
Last Name:
Email Address:
Password:
Org Unit Path [Required]:
  8. If you want the user to reset their password on their next login, look for  Change Password at Next Sign-In and enter True on the value.
  9. Save the Google sheet.
  10. Go back to the Admin console page.
  11. Attach CSV file on the Bulk Update Users page.
  12. Click Upload.
  13. If there is an error, check the file again for missing or incorrect information and repeat steps 10, 11 and 12.