Logo
English (US) Español
Sign in
  1. Support Latam
  2. Office 365
  3. Admin Center

    Add several users at the same time to Office 365

    Follow
    Avatar Nestor
    Updated : January 31, 2019 22:53 Created : January 31, 2019 21:17

    Each person on your team needs a user account before they can sign in and access Office 365 services, such as email and Office. If you have a lot of people, you can add their accounts all at once from an Excel spreadsheet or other file saved in CSV format.

    Add multiple users to Office 365 in the Office 365 admin center

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

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

      In the Admin center choose Users and then Active users

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

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

      In the More drop-down, choose Import multiple users

      Your spreadsheet needs to include the exact same column headings as the sample one (User Name, First Name, etc...). 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 bob@contoso.com) and a display name (like Bob Kelly) for each user.

    Copy
    User Name,First Name,Last Name,Display Name,Job Title,Department,Office Number,Office Phone,Mobile Phone,Fax,Address,City,State or Province,ZIP or Postal Code,Country or Region
    chris@contoso.com,Chris,Green,Chris Green,IT Manager,Information Technology,123451,123-555-1211,123-555-6641,123-555-9821,1 Microsoft way,Redmond,Wa,98052,United States
    ben@contoso.com,Ben,Andrews,Ben Andrews,IT Manager,Information Technology,123452,123-555-1212,123-555-6642,123-555-9822,1 Microsoft way,Redmond,Wa,98052,United States
    david@contoso.com,David,Longmuir,David Longmuir,IT Manager,Information Technology,123453,123-555-1213,123-555-6643,123-555-9823,1 Microsoft way,Redmond,Wa,98052,United States
    cynthia@contoso.com,Cynthia,Carey,Cynthia Carey,IT Manager,Information Technology,123454,123-555-1214,123-555-6644,123-555-9824,1 Microsoft way,Redmond,Wa,98052,United States
    melissa@contoso.com,Melissa,MacBeth,Melissa MacBeth,IT Manager,Information Technology,123455,123-555-1215,123-555-6645,123-555-9825,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.

      Your CSV file is verified

      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.

    Was this article helpful?
    0 out of 0 found this helpful
    • Facebook
    • Twitter
    • LinkedIn

    Comments

    Zendesk Theme Designed by Diziana

    Copyright © Diziana. All Rights Reserved