Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

How to add users in bulk for Office 365

Summary: Each person on your team needs to have a user account before they can sign in and access the Office 365 services, such as email and Office.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Instructions

If you have a lot of people, you can add their accounts all at once from an Excel spreadsheet or some other file that is saved in the .CSV format.

Important Note:     
Access the sample spreadsheet template External Link or follow the process below to download the template in Microsoft Online Portal.
 

Notepad Icon Add multiple users to Office 365 in the Microsoft Online Portal

 

  1. Sign in to the Microsoft Online Portal External Link

  2. Select Users > Active users.

Bulk Upload 1

  1. In the More drop-down, choose Import multiple users.

  2. On the Import multiple users panel, you can optionally download a sample CSV file with or without sample data filled in.

Important Note:      
Access the sample spreadsheet template  External Link.

Bulk Upload 2

Your spreadsheet needs to include the exact same column headings as the sample one (Username, First Name, etc.). If you use the template, open it in a text editing tool, like Excel and consider leaving all the data in row 1 alone, and enter the data only in rows 2 and below.

Your spreadsheet needs to include values for the username (like bob@contoso.com) and a display name (like Bob Kelly) for each user.

  1. Enter a file path into the box, or click Browse to browse to the CSV file location, then choose Verify.

    If there are issues with the file, the issue is displayed in the panel. You can also download a log file.

    • On the Set user options dialog, you can set the sign-in status and choose the product license that is assigned to all users.

    • On the View your result dialog you can choose to send the results to either yourself or other users (passwords are in plain text), and you can see how many users were created, and if you need to purchase more licenses to assign to some of the new users.

Bulk Upload 3

 

Additional Resource:


Affected Products

Microsoft 365 from Dell
Article Properties
Article Number: 000184377
Article Type: How To
Last Modified: 10 Oct 2024
Version:  9
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.