As many of you already know, the Office365 platform can perform tasks automatically, which means simplification and time savings.

In today’s post  I will explain how to register users in Office365 , as well as their allocation of licenses with PowerShell. In this way, it will be much more comfortable to register users massively than if we did it manually.

Next, I’ll show you the two steps we’re going to follow:

       1.Create a CSV File

First, we will create a CSV file with the following name “CreaciónUsusuarioOffice365.csv” and with this data (Here you have the template to download)

  • DisplayName
  • userPrincipalName
  • passwordProfile
  • GiveName
  • Surname
  • JobTitle
  • Departament
  • UsageLocation
  • streetAddress
  • state
  • country
  • physicalDeliveryOfficeName
  • city
  • postalCode
  • telephoneNumber
  • mail
  • License
  • MailNickName

*Note: I have left the link so you can download the file and only have to add the data of the users you want to register in Office365

Here is an example of what the completed data file should look like


     2. Script Execution

Once the data is inserted in the file “CreateUserOffice365.csv” we will save it in the My Documents folder.

When we have it saved we proceed to Execute the Script “CreacionUsuarios_V2.ps1“.

While the script is running we can see the result of the “Active Users” management console of Office365

Usuarios Activos en Office 365

If you want us to help your business or company contact us at or call us at +34 962 681 242

Recommended Posts

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.