Before people on your team can sign in and use your organization's Google services (for example, Google Workspace or Cloud Identity), 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 spreadsheet, or CSV file.
Before you begin Make sure this is the right optionIf you use a CSV file to create new accounts, the users do not receive a new user welcome email with their credentials. You have to send your new users their account credentials separately.
Tip: If you forget the new user's password, reset the password and then email the new one to the user.
Step 1: Download the template file To complete these steps, you need the appropriate User management privilege. Without the correct privilege, you won't see all the controls needed to complete these steps.with an
administratoraccount to the Google Admin console.
If you aren’t using an administrator account, you can’t access the Admin console.
The file has columns for the attributes that can appear in each user's profile. Profiles appear in the Admin console and in the users' Contacts Manager.
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.
For column descriptions and formatting details, review the guidelines below.
Your CSV file should look like something like this:
After it's complete, save it as a CSV file (.csv).
Notes:
If your file is larger or has too many records, open it in your spreadsheet program, split the table into separate files, and save each one as a CSV file. Make sure you include the column headings row in all CSV files.
Your Tasks list opens automatically and shows the progress of the upload. Once processing is complete, you'll receive an email report.
If there's a processing error, download the log file from your Tasks list. For more information, go to Resolve common errors below.
It can take up to 24 hours for new users to have access to Google services and appear in the Directory. Learn more about the Directory.
Follow CSV file format guidelinesGeneral guidelines If you want to... Follow these guidelines... Enter multiple values in a column For multiple values in a single column, such as phone numbers and email addresses, separate them with a comma (but no spaces)—for example: username1@example.com,username2@example.com Enter values that include commas, with line breaks, or double quotesEnclose the values in double quotation marks—for example, "123 Anystreet, Anytown"
Upload non-ASCII or double byte usernames Be sure to save the CSV file in UTF-8 so the usernames are readable. Add more columns You can enter information only in the columns available in the downloaded file. You can't add new columns, such as those for custom attributes. Upload existing users If you enter the email address or email alias of an existing user in the Email Address column, the existing user's account will be updated with any changes you make to their information in the other columns. Column reference Required columns Column Description/Format First Name / Last Name A first name and last name can each have up to 60 characters. Email Address The user's sign-in name. Enter the full email address: username@example.com Password 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 PathFor placing users in an organizational unit.
If you haven't yet set up an organizational hierarchy: Enter / (forward slash) only to place all users in the top-level parent organizational unit. You can move users to other organizational units you create later.
If you've already set up an organizational hierarchy: Use the format in the following examples to place each user in an organizational unit—in either your top-level parent organizational unit or a child organizational unit below it.
Examples:
/ (for the top-level parent–don't enter your domain name)
/Sales (for a child below the top-level parent)
/Students/First Grade
Specify one of the following supported hash functions: MD5, SHA-1, or crypt.
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.
Tip: You can find utilities on the web to generate hashed passwords using the supported hash functions.
Recovery Email and Recovery PhoneFor providing recovery information used for login challenges.
Recovery phone—Must be in the E.164 format. They must start with the plus sign (+), followed by the country code, area code, and phone number. Entries can have a maximum of 15 digits. Example: +16505551212.
Note: Recovery phone should be unique for each user. If the same recovery phone number is used by multiple users, that number is automatically blocked for security reasons.
For editing existing user accounts only. To assign a different license to a user, enter the SKU ID for the license. Separate multiple license IDs with commas—for example: 1010020020,1010330002
A CSV file can include up to 200 users that are being assigned a new license.
Resolve common errorsErrors when you upload your CSV file Error Cause/Solution File is empty Your file doesn't contain any information. Incorrect file format or unknown column name The columns in your file should be titled First Name [Required], Last Name [Required], Email Address [Required], Password [Required], and Org Unit Path [Required]. File must have the "column name" column A required column is missing. Empty "column name" in row nn A column that requires information is empty in a specific row.For example, you'll see the error Empty "Org Unit Path [Required]" in row 2 if you didn't enter the organizational unit in which you want to place a user's account. Go to Org Unit Path above.
File is too large to upload The CSV file is over 35 MB or there are more than 150,000 records in the file. Open the file and split the table into separate files. Save each one as a CSV file. Make sure you include the column headings row in all CSV files. Incorrect number of columns in the row nn A column is missing for a specific row. "Email Address [Required]" contains reserved username in row nn Certain accounts are reserved and can't be created—for example, abuse and postmaster. Action_Failed: User_LIMIT_EXCEEDED You reached the limit to add licenses to your Google Workspace edition, so some users in your CSV file did not get a license.Note: Starting from the top row of your CSV file, Google Accounts are added until no more licenses are available.
Errors in the log file Error Cause/Solution ACTION FAILED: ARCHIVAL LICENSE NOT ALLOWED Occurs when attempting to update Archived User licenses with the CSV file. Try manually adding the licenses. ACTION FAILED: INSUFFICIENT LICENSES Your organization's Google Account doesn't have enough licenses for all the new users in your CSV file. Accounts are added starting from the top row until there are no more licenses available. You can purchase more licenses and then upload the remaining users in the CSV file. ACTION FAILED: MULTIPLE LICENSES IN SAME PRODUCTThe upload failed for one of the following reasons:
For example, if you change a license from Business Starter to Enterprise Plus, the CSV file upload will fail, because those two edition names have the same Product ID, Google-Apps. For details, see Google Product and SKU IDs.
This error usually means one of the following formatting errors:
This error can occur if:
If you add a user to an organizational unit that has automatic licensing turned on, the automatic licensing settings take precedence over the license you assign to the user in the CSV file. An error won't be shown in the log file.
Update existing user accountsEdit accounts with a CSV fileYou can save time when you need to edit multiple accounts by downloading a list of accounts from the Admin console.
Before you beginwith an
administratoraccount to the Google Admin console.
If you aren’t using an administrator account, you can’t access the Admin console.
Your Tasks list opens automatically and shows the progress of the download.
The file has columns for the attributes in each user's profile.
Your Tasks list opens automatically and shows the progress of the upload. Once processing is complete, you'll receive an email report.
If there's a processing error, download the log file from your Tasks list. For more information, go to Resolve common errors.
If you have an LDAP server, such as Microsoft Active Directory, you can use Google Cloud Directory Sync to synchronize your Google users, groups, and shared contacts to match the information in your LDAP server.
Want someone to do this for you? Get professional help with setup.
Related articles
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.
How can we improve it?
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4