संपादित करें

इसके माध्यम से साझा किया गया


Add several users at the same time to Microsoft 365 - Admin Help

Each person on your team needs a user account before they can sign in and access Microsoft 365 services, such as email and the Microsoft 365 apps. 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. Not sure what CSV format is?

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 bob@contoso.com) 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
    chris@contoso.com,Chris,Green,Chris Green,IT Manager,Information Technology,123451,123-555-1211,123-555-6641,123-555-6700,chris@contoso.com,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-6700,chris@contoso.com,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-6700,chris@contoso.com,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-6700,chris@contoso.com,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-6700,chris@contoso.com,1 Microsoft way,Redmond,Wa,98052,United States
    
  5. 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.

  6. 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.

  7. 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.

Next steps

More information about how to add users to Microsoft 365

Not sure what CSV format is?

A CSV file is a file with comma separated values. You can create or edit a file like this with any text editor or spreadsheet program, such as Excel.

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.

An image of how to save a file in Excel in 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.

A picture of the prompt you might get from Excel asking if you really want to save the file as a CSV format.

Tips for formatting your spreadsheet

  • Do I need the same column headings as in the sample spreadsheet? Yes. The sample spreadsheet contains column headings in the first row. These headings are required. For each user you want to add to Microsoft 365, create a row under the heading. If you add, change, or delete any of the column headings, Microsoft 365 might not be able to create users from the information in the file.

  • What if I don't have all the information required for each user? The user name and display name are required, and you cannot add a new user without this information. If you don't have some of the other information, such as the fax, you can use a space plus a comma to indicate that the field should remain blank.

  • How small or large can the spreadsheet be? The spreadsheet must have at least two rows. One is for the column headings (the user data column label) and one for the user. You cannot have more than 250 rows. If you need to import more than 249 users, you can create more than one spreadsheet.

  • What languages can I use? When you create your spreadsheet, you can enter user data column labels in any language or characters, but you must not change the order of the labels, as shown in the sample. You can then make entries into the fields, using any language or characters, and save your file in a Unicode or UTF-8 format.

  • What if I'm adding users from different countries or regions? Create a separate spreadsheet for each area. You'll need to step through the Bulk add users wizard which each spreadsheet, giving a single location of all users included in the file that you're working with.

  • Is there a limit to the number of characters I can use? The following table shows the user data column labels and the maximum character length for each in the sample spreadsheet.

    User data column label Maximum character length
    User Name (Required) 79 including the at sign (@), in the format name@domain.<extension>. The user's alias cannot exceed 50 characters, and the domain name cannot exceed 48 characters.
    First Name 64
    Last Name 64
    Display Name (required) 256
    Job Title 64
    Department 64
    Office Number 128
    Office Phone 64
    Mobile Phone 64
    Fax 64
    Address 1023
    City 128
    State or Province 128
    ZIP or Postal Code 40
    Country or Region 128

Still having problems when adding users to Microsoft 365?

  • Double-check that the spreadsheet is formatted correctly. Check the column headings to make sure they match the headings in the sample file. Make sure you're following the rules for character lengths and that each field is separated by a comma.

  • If you don't see the new users in Microsoft 365 right away, wait a few minutes. It can take a little while for changes to go across all the services in Microsoft 365.

Add users individually or in bulk to Microsoft 365