How to Add Several Users at Once to Google Workspace | Adding Users from a CSV File

Hello, everyone! Since the beginning of this year, I've been using Google Admin Console, therefore, I've been gaining new skills, and I'd like to share all my new knowledge with all of you.

Before adding users, make sure that there are available licenses, if not, you need to purchase more user licenses, you should take a look at this link posted by Google. On the other hand, how many users you need to add? This option is recommended for adding up to 150,000 users, if you need to update more than that, I recommend you use APIs.

Go to admin.google.com and sign in as the admin, and select Users.

 

Note:  You must use an administrator account and sign in with it, you can't sign in with your @gmail.com account.

 

Click on Bulk update users.

 

Now, you can download a blank CSV template, and user info. As you can read, the required fields are as follows:

• First Name: it can have up to 60 characters
  
• Last Name: it can have up to 60 characters
  
• Email Address: User's sign-in email address, it could be Name.LastName@yourdomain or, Name@yourdomain (there's no a format).
  
• Password
• Organizational Unit Path: There are different options, check them carefully.
  
• / : Place user in the top-level parent org unit.
• /Child : Place user in a child org unit, it can be "/Marketing", for instance.
  
• /Child/Subchild : Place users in a subchild level, for example "/Managers/IT".

You can download my csv file here, it comes with names, job titles and son on, just for practice purposes. Let's click on ATTACH CSV FILE, double-click on your file and then select UPLOAD button.

Immediately you click Upload, you will see that the task has begun on the top-right corner.

 

After a couple of minutes, you will see that the task has been completed on the top-right corner, and receive an email.

Task

Email

Press Ctrl + F5 on your keyboard to refresh/reload the page, and all your new users will be displayed.

And that's all! 

Don't forget to subscribe to my blog and my YouTube channel, and follow me on my social media.  

Connect with me

• LinkedIn: Kevin Urena
  
• Youtube: Kevin Urena Mtz 
  

• Instagram: Kevin.Urena_ 
• Spotify: Kevin Ureña

If you like my blog, and it's helped you, let me know with a coffee 😃😄

• Buy me a coffee: KevinUrena :)