New MsolUser Script

FirstName,LastName,DisplayName,UserPrincipalName,UsageLocation,AccountSkuId,MobilePhone,PhoneNumber,Title,Department,StreetAddress,PostalCode,City,Office

Edit in Excel save as CSV UFT-8 > Open in NotePad++ and replace ; with ,

Import-Csv -Path "C:\365\Users.csv" | ForEach {New-MsolUser -FirstName $_.FirstName -LastName $_.LastName -DisplayName $_.DisplayName -UserPrincipalName $_.UserPrincipalName -UsageLocation $_.UsageLocation -LicenseAssignment $_.AccountSkuId -MobilePhone $_.MobilePhone -PhoneNumber $_.PhoneNumber -Title $_.Title -Department $_.Department -StreetAddress $_.StreetAddress -PostalCode $_.PostalCode -City $_.City -Office $_.Office } | Export-Csv -Path "C:\365\Results.csv"

Users.csv

Import-Csv -Path "C:\365\Users.csv" | ForEach {Set-MsolUserPassword -UserPrincipalName $_.UserPrincipalName -NewPassword "Temporary123!" -ForceChangePassword:$false}
Import-Csv -Path "C:\365\Users.csv" | ForEach {Set-MsolUser -UserPrincipalName $_.UserPrincipalName -StrongPasswordRequired $false}

Install PowerShell the Azure Active Directory