Before people on your team can sign in and use your organization's Google services (for example, G Suite or Cloud Identity), they need a user account. If you have many users, you can add their accounts all at once from a spreadsheet.
Before you begin
- Make sure this is the right option: Upload users with a spreadsheet only if you're adding up to 150K users. However, if you have an LDAP server, such as Microsoft® Active Directory®, or have programming skills, we recommend other options for larger organizations. For details, go to Options for adding users.
- Make sure you have enough licenses (Annual Plan only): Before you add users, you might need to add licenses to your account. Learn how to get more licenses.
Add users from a spreadsheet
- From the Admin console Home page, go to Users.
- At the top of the page, click Bulk upload users.
- Download the sample CSV (comma-separated values) template.
- Open the CSV file in a spreadsheet application, such as Google Sheets or Microsoft® Excel.
The file has columns for the attributes that can appear in each user's profile. Profiles appear in the Admin console and users' Contacts manager.
- For each user you want to add, enter the following required information in these columns in the spreadsheet:
- First Name
- Last Name
- Email Address—Use the format firstname.lastname@example.org
- Password—Must be at least 8 characters.
- Org Unit Path—Enter a
/(forward slash) if you want to place users in your top-level organizational unit. You might do this if you haven't yet set up an organizational hierarchy in the Admin console.
For details on placing users in other organizational units, go to the format guidelines below.
- (Optional) Fill in the other columns only if you want. Otherwise, you can leave them blank.
Go to the format guidelines below for help with entering information in columns, especially:
- Multiple values in a column
- Values with commas or line breaks, such as a physical address
After you've filled in the spreadsheet, save it as a CSV file (.csv).
- Maximum CSV file size is 35 MB.
- Maximum number of records per file is 150,000.
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.
- To upload non-ASCII or double byte usernames, first save the CSV file in UTF-8, including BOM.
- After you've filled in the spreadsheet, save it as a CSV file.
- At the top of the Users page, click Bulk upload users.
- Click Attach CSV.
- Click Upload. If there's an error, enter the missing information in your spreadsheet and upload the file again. For more information, go to common errors below.
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 common errors below.
It can take up to 24 hours for new users to have access to G Suite services and appear in the global Directory. Learn more about the global Directory.
Follow spreadsheet 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: email@example.com,firstname.lastname@example.org|
|Enter values with commas, line breaks, or double quotes||Enclose the values in double quotation marks—for example,
|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.|
|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: email@example.com|
|Password||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
|Org Unit Path||
For placing users in an organizational unit.
If you haven't yet set up an organizational hierarchy: Enter a
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.
|Password Hash Function [Upload Only]||
Specify one of the following supported hash functions:
The Password column must contain the hashed password. For example, if you use SHA-1 and the hash of password
Tip: You can find utilities on the web to generate hashed passwords using the supported hash functions.
|Recovery Email and Recovery Phone||
For providing recovery information used for login challenges.
|Work/Home Address||If you include commas or line breaks in an address, enclose the address in double quotation marks—for example,
|New Primary Email [Upload Only]||For editing existing user accounts only. Specify a new primary email address (username).|
|Building ID, Floor Name, and Floor Section||To enter this information, follow these guidelines.|
|Change Password at Next Sign-In||To require a user to change their password the next time they sign in to their account, enter
|New Status [Upload Only]||For editing existing user accounts only. To archive or suspend a user, enter
|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, Last Name, Email Address, Password, and Org Unit Path.|
|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 the 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.|
|"Email Address [Required]" contains reserved username in row nn||Certain accounts are reserved and can't be created—for example, abuse and postmaster.|
|Read Only columns||Delete any "read only" columns before uploading the file.|
|ACTION FAILED: Validation||An entry contains unsupported characters. For help, go to Username and group name guidelines.|
|ACTION FAILED: UNKNOWN ERROR||Most likely, a temporary error occurred. Try uploading the CSV file again, or uploading items in smaller batches. This error can also occur if you've entered an incorrect domain name in a user's email address (after the @ sign) in the Email Address column.|
|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: OU INVALID||
This error usually means one of the following:
|ACTION FAILED: USER NAME INVALID||The email address (user name) in the Email Address column isn't formatted correctly. Make sure you enter the user's full email address. Also check for spaces in the address.|
|ACTION FAILED: PERMISSION DENIED||The user's email address in the Email Address column includes a domain name (after the @ symbol) that's not associated with your organization's Google account. Make sure you entered the domain name in the email address correctly.|
|ACTION FAILED: PASSWORD HASH FUNCTION INVALID||The Password Hash Function column contains an incorrect hash function name.|
Maintain user accounts
You can save time when you need to edit multiple accounts by downloading a list of accounts from the Admin console. Important things to remember:
- Any information in columns you can edit replaces existing information in the Admin console when you upload the file.
- For columns you don't want to change, you can either delete them (if the column isn't required), leave their information in the file, or delete their information.
- If you delete all information from a column that's not required, but leave the column in the spreadsheet, the existing information is not removed from the user's account when you upload the file.
- If you don't want to change a user's password, make sure the Password column contains the symbols **** (4 asterisks).
- To change a user's username, enter the new email address in the column New Primary Email.
Want someone to do this for you? Get professional help with setup.