Add several users at the same time to Microsoft 365

You can download this sample spreadsheet as a starting point. Remember that Microsoft 365 requires column headings in the first row so don't replace them with something else.

Save the file with a new name, and specify CSV format.

When you save the file, you'll probably get a prompt that some features in your workbook will be lost if you save the file in CSV format. This is okay. Click Yes to continue.

Add multiple users in the Microsoft 365 admin center

1. Sign in to Microsoft 365 with your work or school account.

2. In the admin center, choose Users > Active users.

3. Select Add multiple users.

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

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

Your spreadsheet also needs to include values for the user name (like [e-mail]) and a display name (like Bob Kelly) for each user.

User Name,First Name,Last Name,Display Name,Job Title,Department,Office Number,Office Phone,Mobile Phone,Fax,Alternate email address,Address,City,State or Province,ZIP or Postal Code,Country or Region
[e-mail],Chris,Green,Chris Green,IT Manager,Information Technology,123451,123-555-1211,123-555-6641,123-555-6700,[e-mail],1 Microsoft way,Redmond,Wa,98052,United States

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

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

2. On the Set user options dialog you can set the sign-in status and choose the product license that will be assigned to all users.

3. On the View your result dialog you can choose to send the results to either yourself or other users (passwords will be 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.

---

REFERENCES

• https://learn.microsoft.com/en-us/microsoft-365/enterprise/add-several-users-at-the-same-time?view=o365-worldwide