Book Image

Microsoft Office 365 Administration Cookbook

By : Nate Chamberlain
Book Image

Microsoft Office 365 Administration Cookbook

By: Nate Chamberlain

Overview of this book

Organizations across the world have switched to Office 365 to boost workplace productivity. However, to maximize investment in Office 365, you need to know how to efficiently administer Office 365 solutions. Microsoft Office 365 Administration Cookbook is packed with recipes to guide you through common and not-so-common administrative tasks throughout Office 365. Whether you’re administering a single app such as SharePoint or organization-wide Security & Compliance across Office 365, this cookbook offers a variety of recipes that you’ll want to have to hand. The book begins by covering essential setup and administration tasks. You’ll learn how to manage permissions for users and user groups along with automating routine admin tasks using PowerShell. You’ll then progress through to managing core Office 365 services such as Exchange Online, OneDrive, SharePoint Online, and Azure Active Directory (AD). This book also features recipes that’ll help you to manage newer services such as Microsoft Search, Power Platform, and Microsoft Teams. In the final chapters, you’ll delve into monitoring, reporting, and securing your Office 365 services. By the end of this book, you’ll have learned about managing individual Office 365 services along with monitoring, securing, and optimizing your entire Office 365 deployment efficiently.
Table of Contents (16 chapters)
14
Chapter 14: Appendix – Office 365 Subscriptions and Licenses

Importing users in bulk

Adding users one at a time can become quite laborious in a large organization. This recipe provides a method for importing a file and adding users in bulk. Additionally, this can be done through PowerShell, which will be covered in Chapter 3, Administering Office 365 with PowerShell.

Getting ready

The user creating the account must be either a global or user administrator.

How to do it…

  1. Go to the Microsoft 365 Admin Center at http://admin.microsoft.com.
  2. Select Users > Active users.
  3. Select Add multiple users.
  4. Click Add multiple users:
    Figure 2.6 – The Add multiple users button of the Active users page

    Figure 2.6 – The Add multiple users button of the Active users page

  5. The Import multiple users panel will open. From here, you can download a sample comma-separated values (CSV) file, enter your user information according to the column headings in the download, and then upload it to your tenant:
    Figure 2.7 – The upload file dialog for downloading templates of and importing CSV files of new users

    Figure 2.7 – The upload file dialog for downloading templates of and importing CSV files of new users

  6. The CSV file must include all the exact column headings that are found in the sample. If you move the headings, the upload may not work appropriately.

    Data must be entered into the username and display name columns for each user.

  7. Click Next to move to the Set user options section.
  8. From this screen, you can set the Sign-in status and select product licenses for the bulk loaded users:
    Figure 2.8 – Dialog options for allowing sign-in and assigning product licenses upon import

    Figure 2.8 – Dialog options for allowing sign-in and assigning product licenses upon import

  9. Click Next to move to the View your result section.
  10. On the View your result screen, you can choose to send the results to an email address, check how many users were created, and download the results. Note that the results will include plaintext passwords. The results will help show how many users were successfully created and maybe illustrate a need for licensing adjustment to meet the number of users:
    Figure 2.9 – Confirmation of created users with the option to email a result file to users

    Figure 2.9 – Confirmation of created users with the option to email a result file to users

  11. Click Send and close to finish the process.

How it works…

You just imported a CSV file with many users' data to create new users in Office 365 more efficiently. This behind-the-scenes method is functionally the same as manually adding users. However, it applies those selections in bulk and then creates a downloadable file with the login information.

See also