Importing and Updating Users via CSV

Add or update multiple users from a CSV file

Before people within your organization can sign in and use your organization's Google Workspace, they need a user account. If you have many new users, you can add their accounts all at once from a CSV file.

You can also update multiple existing accounts from a CSV file. Patronum uses the same file format of the Google Admin Console, so please check the latest Google Documentation on how to Add or update multiple users from a CSV file.

For each user you want to add, enter the following required information in these columns in the CSV file:

First Name
Last Name
Email Address—Use the format username@example.com
Password—Must be at least 8 characters.

Passwords are case sensitive. By default, a password must have at least 8 characters. You can change password requirements for your organization.If you're updating existing users and you don't want to change their passwords, enter 4 asterisks.If a Password Hash Function is also specified, the Password column must contain the hashed password. For example, if you use SHA-1 and the hash of password abc is xyz, enter xyz in the Password column.

Org Unit Path—Enter / (forward slash) to place users in your top-level organizational unit. You might do this if you haven't set up an organizational hierarchy in the Admin console. Or, you can enter the path for a specific organizational unit, staring with a forward slash, such as /Sales.

Your CSV file should look like something like this:

Updated on: 16/01/2024

Was this article helpful?

Thank you!