How to Add Users in Bulk?

Add Users in Bulk

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 spreadsheet.

STEPS FOR ADDING USERS FROM A SPREADSHEET


  1. Sign in to your Google Admin console.
  2. From the Admin console Home page, go to Users.
  3. Click the Manage option on the right of Users.
  4. At the top of the page, click Bulk update users.




  5. Click Download blank CSV template to download a comma-separated value (.csv) file.

      a.  Open the CSV file in a spreadsheet application, such as Google  Sheets or Microsoft                  Excel.

  6. Enter the user’s information
    • For each user you want to add, enter the following required information in these   columns in the spreadsheet:
    1. First Name
    2. Last Name
    3. Email Address—Use the format username@example.com
    4. Password—Must be at least 8 characters.
    5. For column descriptions and formatting details, click on Learn more.
      Your spreadsheet should look something like this:



      (Optional) Enter in the remaining columns to specify additional information, such as recovery emails, home addresses,  licenses, etc, Org Unit Path—Enter / (forward slash) to place users in your top-level organizational unit.




  7. Save the file:
    1. After you've filled in the spreadsheet, save it as a CSV file (.csv).

    Notes:

    • Maximum CSV file size is 35 MB.
    • The 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.
  8. Upload the file:
    1. At the top of the Users page, click Bulk update users.
    2. Click Attach CSV file.
    3. Browse to the location on your computer and attach the CSV file.
    4. 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.

After uploading, it will show something like this, as shown in 

the picture below:




It can take up to 24 hours for new users to have access to Google services and appear in the Directory.

Please check the below-supporting article for your further reference:
Add or update multiple users from a CSV file - Google Workspace Admin Help