How to Bulk Upload Contacts to People App
Add together or update multiple users from a CSV file
Earlier people on your squad can sign in and employ your organisation's Google services (for example, Google Workspace or Cloud Identity), they need a user account. If you lot have many new users, y'all tin add together their accounts all at once from a spreadsheet.
You can too update multiple existing accounts from a spreadsheet.
Before yous begin
- Brand sure this is the right option—Upload users with a spreadsheet if you're adding up to 150,000 users. Nevertheless, if you have an LDAP server, such as Microsoft Agile Directory, or have programming skills, we recommend other options for larger organizations. For details, go to Options for adding users.
If y'all're updating user accounts, note that a spreadsheet can include upward to 200 existing users that are being assigned new licenses.
- (Annual Plan customers) Make sure y'all accept enough licenses—Before you add users, you might need to add licenses to your business relationship. Larn how to go more licenses.
- (Flexible Program customers) Your subscription price depends on how many users you take—Adding user accounts automatically increases your monthly payment.
- (Google Workspace Business organisation edition customers) Y'all can add a maximum of 300 users. There is no minimum or maximum user limit for Enterprise plans.
- Automatic licensing takes precedence—If you add a user to an organizational unit that has automated licensing turned on, the automated licensing settings have precedence over the license you assign to the user in the CSV file. An mistake won't be shown in the log file.
- There might be unmanaged accounts—Cheque to see if anyone you plan to add already has a Google Business relationship. Then follow steps to avoid conflicts with those accounts. Become to Discover and add unmanaged users.
- There might be company accounts—If users invite people outside your organization who don't accept Google accounts to interact on Drive, they'll receive visitor accounts, in the formatcompany's_username@your_domain.com. If you add a user with the same username every bit a visitor account, the account will be converted to a total Google Workspace account. The business relationship volition keep its current Drive file permissions. Learn more about sharing documents with visitors.
Open all | Close all
Add users from a spreadsheet
If y'all employ a CSV file to create new accounts, the users practise not receive a new user welcome email with their credentials. You accept to send your new users their account credentials separately.
Tip: If you forget the new user's password, reset the password so email the new ane to the user.
Stride 1: Download the template file
- From the Admin console Abode folio, go to Users.
- At the acme of the folio, click Bulk update users.
- Click Download blank CSV template to download a comma-separated values (.csv) file.
- Open the CSV file in a spreadsheet application, such as Google Sheets or Microsoft Excel.
The file has columns for the attributes that can announced in each user'due south profile. Profiles appear in the Admin console and users' Contacts manager.
Step two: Enter users' information
- For each user you want to add together, enter the following required data in these columns in the spreadsheet:
- First Proper noun
- Last Proper name
- Email Accost—Use the format username@example.com
- Password—Must exist at least 8 characters.
-
Org Unit Path—Enter / (forwards slash) to place users in your elevation-level organizational unit of measurement. Y'all might do this if y'all haven't set up an organizational hierarchy in the Admin console.
For column descriptions and formatting details, review the guidelines below.
Your spreadsheet should await like something like this:
- (Optional) To require a user to reset their countersign when first signing in, in theModify Password at Side by side Sign-In column, enter True. Otherwise, get out the cavalcade empty.
- (Optional) To specify additional information, such equally recovery emails, home addresses, or licenses, enter it in the remaining columns.
Step 3: Relieve the file
After y'all've filled in the spreadsheet, save it as a CSV file (.csv).
Notes:
- 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 up information technology in your spreadsheet programme, divide the table into separate files, and save each one as a CSV file. Make sure y'all 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.
Step four: Upload the file
- At the peak of the Users page, click Bulk update users.
- Click Attach CSV file.
- Scan to the location on your calculator and adhere the CSV file.
- Click Upload. If there's an error, enter the missing information in your spreadsheet and upload the file again. For more information, go to Resolve common errors below.
Your Tasks list opens automatically and shows the progress of the upload. Once processing is complete, you'll receive an electronic mail report.
If there's a processing fault, download the log file from your Tasks list. For more information, become to Resolve common errors below.
It tin take upward to 24 hours for new users to have access to Google services and appear in the Directory. Acquire more about the Directory.
Follow spreadsheet format guidelines
General guidelines
| If you desire to... | Follow these guidelines... |
|---|---|
| Enter multiple values in a cavalcade | For multiple values in a single cavalcade, such as phone numbers and email addresses, separate them with a comma (merely no spaces)—for example: username1@domain.com,username2@domain.com |
| Enter values that include commas, with line breaks, or double quotes | Enclose the values in double quotation marks—for example, "123 Anystreet, Anytown" |
| Upload non-ASCII or double byte usernames | Be sure to salvage the CSV file in UTF-8 then the usernames are readable. |
| Add more than columns | You lot 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 e-mail alias of an existing user in the Email Accost cavalcade, the existing user's account will be updated with any changes you make to their information in the other columns. |
Column reference
Required columns
| Cavalcade | Description/Format |
|---|---|
| First Name / Last Name | A offset name and concluding name can each take up to 60 characters. |
| Email Address | The user'southward sign-in name. Enter the full email accost: username@example.com |
| Password | Passwords are case sensitive. By default, a password must have at to the lowest degree 8 characters. You tin change password requirements for your organization. If you lot're updating existing users and you lot don't want to modify their passwords, enter **** (4 asterisks). If a Countersign Hash Function is too specified, the password column must contain the hashed password. For example, if you use SHA-ane and the hash of password abc is xyz, enter xyz in the Password cavalcade. |
| Org Unit Path | For placing users in an organizational unit. If you oasis't yet set up an organizational hierarchy: Enter / (forward slash) but to place all users in the pinnacle-level parent organizational unit. You lot can move users to other organizational units you create later. If you've already set up an organizational hierarchy: Apply the format in the post-obit examples to place each user in an organizational unit—in either your tiptop-level parent organizational unit of measurement or a child organizational unit below it. Examples:
|
Optional columns
| Column | Format |
|---|---|
| Password Hash Function [Upload Merely] | Specify 1 of the following supported hash functions:MD5, SHA-1, or crypt. The Password cavalcade must incorporate the hashed password. For case, if you utilize SHA-1 and the hash of password abc is xyz, enter xyz in the Password cavalcade. Tip: Yous 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 Accost | If you include commas or line breaks in an accost, enclose the accost in double quotation marks—for instance,"123 Anystreet, Anytown" |
| New Primary Email [Upload Only] | For editing existing user accounts only. Specify a new master e-mail address (username). |
| Building ID, Flooring Name, and Flooring Department | To enter this information, follow these guidelines. |
| Modify Password at Next Sign-In | To crave a user to change their password the next fourth dimension they sign in to their account, enter TRUE. Otherwise, get out the column empty or enter Faux. |
| New Status [Upload But] | For editing existing user accounts only. To archive or suspend a user, enter Archived or Suspended. To unarchive or restore a suspended user, enter Active. |
| New Licenses [Upload Simply] | For editing existing user accounts just. To assign a different license to a user, enter the SKU ID for the license. Separate multiple license IDs with commas—for example:1010020020,Google-Drive-storage-20GB,1010330002 A spreadsheet tin can include upwardly to 200 users that are being assigned a new license. |
Resolve mutual errors
Errors when you upload your CSV file
| Fault | Crusade/Solution |
|---|---|
| File is empty | Your file doesn't contain any data. |
| Incorrect file format or unknown column name | The columns in your file should be titled First Name [Required], Last Proper noun [Required], Electronic mail Accost [Required], Password [Required], and Org Unit Path [Required]. |
| File must take the "column name" cavalcade | A required cavalcade is missing. |
| Empty "column name" in row nn | A cavalcade that requires information is empty in a specific row. For example, you'll see the error Empty "Org Unit of measurement Path [Required]" in row two if you didn't enter the organizational unit in which yous want to place a user's account. Go to Org Unit Path higher up. |
| File is too big to upload | The CSV file is over 35 MB or there are more than 150,000 records in the file. Open up the file and divide the table into separate files. Relieve each one as a CSV file. Make certain 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 tin't exist created—for case, 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 summit row of your CSV file, Google Accounts are added until no more licenses are available. |
Errors in the log file
| Fault | Cause/Solution |
|---|---|
| Activeness FAILED: Validation | An entry contains unsupported characters. For assistance, go to Username and grouping proper noun guidelines. |
| ACTION FAILED: UNKNOWN ERROR | Most probable, a temporary fault occurred. Try uploading the CSV file once more, or uploading items in smaller batches. This error can also occur if you've entered an wrong domain name in a user'southward email address (afterwards the @ sign) in the E-mail Accost cavalcade. |
| ACTION FAILED: Insufficient LICENSES | Your organization'southward Google Account doesn't have enough licenses for all the new users in your CSV file. Accounts are added starting from the peak row until at that place are no more licenses available. You tin can purchase more licenses and then upload the remaining users in the CSV file. |
| ACTION FAILED: OU INVALID | This mistake unremarkably means one of the following formatting errors:
|
| Activeness FAILED: USER Proper noun INVALID | The e-mail address (username) in the E-mail Address column isn't formatted correctly. Make sure y'all enter the user's full email address. Also check for spaces in the accost. |
| Activity FAILED: PERMISSION DENIED | The user'southward electronic mail address in the Email Address cavalcade includes a domain proper name (subsequently the @ symbol) that's not associated with your arrangement'southward Google Account. Make sure you entered the domain name in the email address correctly. |
| Activity FAILED: Password HASH Role INVALID | The Password Hash Function column contains an incorrect hash role proper noun. |
| Activeness FAILED: UPDATE USER LICENSES FAILED | I or more SKU IDs in the New License cavalcade couldn't be updated for the user. Ensure that the SKU IDs are correct and the column is formatted correctly for multiple SKU IDs. |
| Activity FAILED: Simply VFE ALLOWED | The user currently has a Vault Former Employee (VFE) license, but the New License column contains a SKU ID for a license other than the VFE. Y'all can't add some other license type to a user with a VFE license. |
| Activeness FAILED: UNASSIGNABLE LICENSE | The New License cavalcade contains a SKU ID for a product for which you don't have a subscription. |
| Activeness FAILED: MULTIPLE LICENSES IN SAME Production | The New License column contains multiple SKU IDs for the same product—for case, multiple Bulldoze storage SKUs. |
| ACTION FAILED: REPEATED SKU ASSIGNMENTS FOR USER | The New License column contains the aforementioned SKU ID 2 or more than times. |
| ACTION FAILED: SKU SWITCH RESTRICTED | The New License column contains a SKU ID for a production that your current subscription doesn't let y'all upgrade or downgrade to. |
| Action FAILED: UPDATING DELETED USER | The New License column contains a SKU ID, but the user account is deleted. |
If you add a user to an organizational unit that has automatic licensing turned on, the automatic licensing settings take precedence over the license yous assign to the user in the CSV file. An error won't be shown in the log file.
Update existing user accounts
Edit accounts with a spreadsheet
You can save time when y'all need to edit multiple accounts by downloading a list of accounts from the Admin panel.
Before you begin
- Whatsoever information in columns you can edit replaces existing information in the Admin console when yous upload the file.
- For columns you don't want to change, you can either delete them (if the cavalcade isn't required), leave their information in the file, or delete their information.
- If you delete all information from a cavalcade that'southward not required, but leave the cavalcade in the spreadsheet, the existing data is non removed from the user'southward account when you lot upload the file.
- If you don't desire to change a user's password, make sure the Countersign column contains the symbols **** (4 asterisks).
- If you lot don't want to edit a specific user's data, you tin go out their row in the spreadsheet or remove information technology. If yous remove all of a user's information in the file, their account is not deleted.
- To change a user's username, enter the new email address in theNew Primary Email column.
- If you've changed the main domain for your Google Workspace account, see Rename user addresses in bulk afterward changing your primary domain for specific instructions.
To edit several user accounts
- From the Admin panel Domicile folio, get to Users.
- At the superlative of the page, click Bulk update users.
- Click Download User Info In CSV File to download a comma-separated values (.csv) file with all user accounts.
Your Tasks list opens automatically and shows the progress of the download.
- Nether Your Tasks, click Download CSV.
- Open the CSV file in a spreadsheet application, such as Google Sheets or Microsoft Excel.
The file has columns for the attributes in each user'due south profile.
- Edit the information in the file.
- Afterward you've filled in the spreadsheet, salve it equally a CSV file.
- At the top of the Users page, click Bulk update users.
- Click Attach CSV file.
- Browse to the location on your calculator and attach the CSV file.
- Click Upload.
- If there'due south an fault, enter the missing information in your spreadsheet and upload the file again. For more data, become to Resolve common errors.
Your Tasks listing opens automatically and shows the progress of the upload. Once processing is complete, you'll receive an electronic mail report.
-
If there's a processing mistake, download the log file from your Tasks list. For more information, go to Resolve common errors.
Sync user data with your LDAP server
If y'all have an LDAP server, such as Microsoft Agile Directory, you lot tin 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 assistance with setup.
Related articles
- Reset a user's password
- Gear up password recovery for users
- Individually add user accounts
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.
Was this helpful?
How tin can we better it?
Source: https://support.google.com/a/answer/40057?hl=en
Post a Comment for "How to Bulk Upload Contacts to People App"