M365Corner
Business Jan 01, 2045

How to Import Microsoft 365 Users Using CSV files?

Note: Most of the images contained within this article are gifs. Click them to understand Microsoft 365 User Import better.

Sign in to your Microsoft 365 tenant with your login credentials and do the following.

  1. Go to Microsoft 365 admin center by selecting the Admin tab.
  2. Select Show All >> Users >> Active Users option.
  3. Click Add multiple users and scroll down to I’d like to upload a CSV with user information checkbox.
  4. Enable I’d like to upload a CSV with user information checkbox. You’ll notice 2 links as shown in the image below:
    5. Image shows sample Microsoft 365 user import CSV files that you can download for reference.
    • Download a blank CSV with the required headers: if you download the sample CSV file using this link, the sample CSV file will only contain headers as shown in the image.
      • Sample CSV file with only headers that you can use as reference for adding your user details.
    • Download a CSV file that includes example user info: if you download the sample CSV file using this link, the sample CSV file will contain example user info too as shown in the image.
      • Sample CSV file with sample user info that you can use as reference for adding your user details.
  5. Add your user details to the CSV file and upload the same.

    6. The above procedure is explained in the form of click-and-play GIFs below, with each GIF representing a numbered step.

    Image shows how you can access Microsoft 365 admin center by clicking the Admin tab from the Microsoft 365 home page. Image shows how you can access Microsoft 365 Active users page from the Microsoft 365 Admin Center navigation menu. Image shows you can add multiple users by clicking the add multiple users button. Image shows how you can upload the CSV file containing your Microsoft 365 user details and assign them with Microsoft 365 user license.

© m365corner.com. All Rights Reserved. Design by HTML Codex