Live Chat
Home » Blog » Office 365 » How to Export Office 365 User List? – Simple Methods Revealed
Office 365

How to Export Office 365 User List? – Simple Methods Revealed

  author
Published By Ashwani Tiwari
Tej Pratap Shukla
Approved By Tej Pratap Shukla
Published On March 15th, 2024
Reading Time 7 Minutes Reading

Do you want to export Office 365 User List? But the problem is you are not able to find the right method that can export Office 365 users at once. You don’t need to worry because, in this article, we will provide you with methods to export your Office 365 data in the desired format.

Table of Contents:

  1. Method 1- PowerShell Commands
  2. Steps of PowerShell Command to Export the List
  3. Some Common User Queries
  4. Method 2- Automated Solution
  5. Working Steps of the Automated Solution
  6. Conclusion

It is pretty easy to learn how to export Office 365 user list if you have the right guidance.

Many organizations use Microsoft 365 to make sure that the resources they need for growth and to enhance the user’s productivity are always available. The plan that Office 365 provides allows users to access the services that are defined and offered in each plan.

However, the Office 365 user account and the licenses don’t need to correspond to one another.

To avoid any confusion or disruptions, many admins prefer learning the process of exporting the Office 365 user list. It is a possibility that organizations may have users who do not have the license or have users who have licenses but it has just not been assigned to the users.

This is why admins prefer having a CSV file containing all the users’ lists with a certain plan to decide on the usage and other necessities.

User’s Concern: I’m having trouble extracting a list of all the users from a tenant & the licenses they have been assigned in Microsoft 365. How can I do that without failing? Please help!

How to Export Office 365 User List Manually?

There is one method which has the requirement of using PowerShell. It is a method that is easy for everyone who has full-fledged knowledge of PowerShell and how to apply its commands.

Since there are no functions provided by Office 365 to export the list, PowerShell remains the only manual way.

However, there are some prerequisites that you should run.

Pre-Requisites of the PowerShell Commands to Export Office 365 User List

If you want to export the list with the help of these commands, there are some things you need to take care of. Also, if your Office 365 account has never been connected to PowerShell before, this is what you need to do:

  • Install the Microsoft Online Services Sign-in Assistant for IT professionals RTW.
  • Install the Windows Azure Active Directory Module for Windows PowerShell.

Once all this is done and the prerequisites are fulfilled, you can connect your Microsoft 365 account to PowerShell easily.

Let’s see how to export Office 365 user list via PowerShell now.

Steps to Apply the PowerShell Command to Export the List

  • Step 1- Press the Start button and right-click on the Windows Azure Active Directory Module for Windows PowerShell. Choose the Run as administrator option.run-as-admin
  • Step 2- Now, you will see that the Windows Azure Directory window opens up after which you need to connect your Office 365 account with PowerShell.windows-azure-directory
  • Step 3- For that, run the following command:

$UserCredetial – Get-CredentialConnect-MsolServer –Credential $UserCredential

  • Step 4- After executing this command, a Windows PowerShell Credential Request wizard appears for username & password to export Office 365 user list.provide username and password
  • Step 5- Here, you have to enter the admin username and password to connect the account successfully.connect-office365
  • Step 6- Then, execute the following code to see all the licensed and unlicensed users available:

Get-MsolUser –All

  • Step 7- You will get all the results wherein you’ll see that isLicensed will either be true (licensed user) or false (unlicensed user).islicensed-info
  • Step 8- Now, to export the users that are licensed, execute the following command:

    Get-MsolUser –All | where {$_.isLicensed –eq $true}

  • Step 9- If you want to know how to export Office 365 user list for unlicensed users, go for the given code:

    Get-MsolUser –All –UnlicensedUsersOnly

  • Step 10- Next, you can make use of the following code to export this list in a .csv format with all the details like username, license type, account login name etcget-details
  • Step 11- The resultant file will look something like the one shown below.csv-file

Make sure all these commands and used correctly and carefully because if not executed correctly, there may be various troubles that the user will have to face.

User Queries Regarding How to Export Office 365 User List

Is there any technique that can help me extract the users’ list from my Office 365 tenant? I have been trying to get a list of all the licensed and unlicensed users but have no clue if I’m going in the right direction. Could someone please explain the steps for the same?

I want to know how I can get a list of the UserPrincipalName in a CSV file along with the types of licenses the users have been assigned. It has become important to export Office 365 user list due to the confusion of users not being able to do certain tasks as some have not yet been assigned the licenses. Help me please!

Automated Solution to Export Office 365 User List

After discussing about the manual method, we have one direct solution for you. This is the automated solution which is an expert’s recommendation. PCVITA Office 365 Export Tool. This is the most trusted and recommended software for the use of any kind of exporting from Cloud applications. This software not only just supports Office 365 but also has options like Google Workspace (G Suite), Microsoft Exchange, etc.

To know more about the software and its working prefer the software page. The working of the software is mentioned in the below segment.

Download Now Purchase Now

Working Steps of the Automated Solution

To know how this software works first download and install the software on your Windows OS.

  • Step 1- Start by selecting source as Office 365 and destination as Outlook on your Windows OS.

    Note: Here we will proceed with the destination as Outlook. You can choose destination platform as per ypur requirement. Also, while performing the steps of the automated method, you’re not required to install the Outlook on your system.

    select source and destination to export Office 365 User List

  • Step 2- Then select the category from the workload selection bar and apply date range filter options.
    apply date-range filter option
  • Step 3- Afterthat, provide Office 365 Email ID and Application ID to the software and then validate
    provide Office 365 Email ID and Application ID and Validate
  • Step 4- Now, provide the folder path where you want your data files to be saved. Then validate the necessary permissions.
     browse the backup folder path
  • Step 5- Now, there are multiple ways to add users from the source account
    Import Users: Through this users will import via CSV
    Fetch Users: This will fetch users automatically from the source domain
    Download Template: This feature will download the template.
    Select import user, Fetch Users, Download Template
  • Step 6- You may now view the list of selected users by using the Show Selected option. Additionally, you can select the user to export data from and search for a specific mailbox.
     you can view the list of selected users and export Office 365 User List
  • Step 7- Lastly, click on Start Export to export Office 365 User List straight into your system.
     click on Start Export to export Office 365 User List

It’s a Wrap

The article consists of the only way out to find both the licensed and unlicensed users that an organization may have. Because there is no other way, you can learn the procedure carefully or take assistance to perform the task.

The PowerShell cmdlet will provide a list of all the licensed and unlicensed users of Office 365. Using the commands, you can learn how to export Office 365 user list and save it in .csv format.

  author

By Ashwani Tiwari

I am an Expert Technical Analyst, specialized in assisting users with complex technological challenges. Through my blogs and articles, I offer expert guidance to help tackle these technical issues effectively. My true passion lies in providing valuable insights and simplifying complicated technicalities, enhancing user understanding and confidence.