How To Export List Of Licensed Users In Office 365?

**How to Export a List of Licensed Users in Office 365**

Office 365 is a cloud-based productivity suite that includes a variety of applications, such as Word, Excel, PowerPoint, and Outlook. It’s a popular choice for businesses of all sizes, as it offers a cost-effective way to provide employees with the tools they need to be productive.

One of the many benefits of Office 365 is that it allows you to easily manage your users. You can create and delete users, assign licenses, and set up permissions. If you need to export a list of your licensed users, you can do so using the following steps:

1. Log in to the Office 365 admin center.
2. Click **Users** > Active Users.
3. Click the Export button.
4. Select the format you want to export the list in.
5. Click Export.

The list of licensed users will be exported to the file format you selected. You can then save the file to your computer or share it with others.

This article provides a brief overview of how to export a list of licensed users in Office 365. For more detailed instructions, please refer to the [Office 365 documentation](https://docs.microsoft.com/en-us/office365/admin/licensing/export-users-list).

Step Action Explanation
1 Sign in to the Office 365 admin center You can do this by going to https://admin.microsoft.com/ and entering your administrator credentials.
2 Click the Users tab This will display a list of all users in your organization.
3 Click the Export button This will open a dialog box where you can select the format of the export file.
4 Select the CSV format This is the recommended format for exporting a list of licensed users.
5 Click the Export button This will download a CSV file containing a list of all licensed users in your organization.

****

Office 365 is a cloud-based productivity suite that includes a variety of applications, such as Word, Excel, PowerPoint, and Outlook. It is used by businesses of all sizes to improve collaboration and productivity.

One of the benefits of Office 365 is that it allows you to manage your users and licenses centrally. This means that you can easily see who is using Office 365 and what licenses they have.

If you need to export a list of licensed users in Office 365, you can do so using the Microsoft 365 admin center or the PowerShell command line.

**What is a licensed user in Office 365?**

A licensed user is a person who has been granted access to use Office 365 services. This includes access to all of the applications in the Office 365 suite, as well as to the cloud-based storage service OneDrive.

Licensed users can also use the following features:

  • Share documents, spreadsheets, and presentations with other users.
  • Collaborate on projects in real time.
  • Access their files from anywhere with an internet connection.

**How to export a list of licensed users in Office 365?**

There are two ways to export a list of licensed users in Office 365:

1. **Using the Microsoft 365 admin center:**

1. Go to the Microsoft 365 admin center.
2. Click **Users** > Active users.
3. Click Export.
4. Select the format you want to export the list in (CSV, XLSX, or PDF).
5. Click Export.

2. Using the PowerShell command line:

1. Open PowerShell.
2. Run the following command:

Get-MsolUser -All | Export-Csv C:\Users\username\Desktop\licensed_users.csv

This will export a CSV file containing a list of all licensed users in your organization.

Exporting a list of licensed users in Office 365 is a simple process that can be done using the Microsoft 365 admin center or the PowerShell command line. This information can be useful for a variety of purposes, such as managing user accounts, tracking license usage, and planning for future growth.

**How To Export List Of Licensed Users In Office 365?**

This article will show you how to export a list of licensed users in Office 365. You can use this list to manage user licenses, track user activity, identify users who are no longer active, and create reports.

**Prerequisites**

To export a list of licensed users in Office 365, you need the following:

  • An active Office 365 subscription.
  • A Microsoft 365 admin center account.
  • The Microsoft 365 PowerShell module.

**Instructions**

To export a list of licensed users in Office 365, follow these steps:

1. Sign in to the Microsoft 365 admin center.
2. Click **Users** > Active users.
3. Click the Export button.
4. Select the Licenses option.
5. Click the Export button.

The Microsoft 365 admin center will export a CSV file containing a list of licensed users. The CSV file will include the following columns:

  • User principal name
  • User display name
  • License type
  • License expiration date

What to do with the exported list of licensed users?

You can use the exported list of licensed users to:

  • Manage user licenses.
  • You can use the list to identify users who are not using their licenses or who have licenses that are about to expire.
  • You can also use the list to add or remove licenses from users.
  • Track user activity.
  • You can use the list to track which users are using which applications and services.
  • This information can help you identify users who are having problems with their licenses or who are not using their licenses to their full potential.
  • Identify users who are no longer active.
  • You can use the list to identify users who have not logged in to their accounts for a long time.
  • This information can help you clean up your user directory and remove users who are no longer active.
  • Create reports.
  • You can use the list to create reports on your user licenses.
  • This information can help you make decisions about your license purchases and usage.

Additional resources

  • [Microsoft 365 admin center documentation](https://docs.microsoft.com/en-us/microsoft-365/admin/licensing/export-user-licenses?view=o365-worldwide)
  • [Microsoft 365 PowerShell documentation](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.management.msol/get-msoluser?view=o365-worldwide)

In this article, you learned how to export a list of licensed users in Office 365. You can use this list to manage user licenses, track user activity, identify users who are no longer active, and create reports.

How do I export a list of licensed users in Office 365?

To export a list of licensed users in Office 365, you can use the following steps:

1. Go to the Admin Center.
2. Click Users.
3. Click Active Users.
4. Click Export.
5. Select the Export option.
6. Select the CSV format.
7. Click Download.

The exported file will be saved to your computer. You can then open the file in a spreadsheet program to view the list of licensed users.

What information is included in the exported list?

The exported list includes the following information for each user:

  • User name
  • Email address
  • License type
  • License expiration date

Can I export a list of users who are not licensed?

No, you cannot export a list of users who are not licensed. Only users who have a valid license will be included in the exported list.

Can I export a list of users who are assigned to a specific group?

Yes, you can export a list of users who are assigned to a specific group. To do this, follow the steps above, but on step 3, click Assigned to and select the group you want to export.

Can I export a list of users who have a specific license type?

Yes, you can export a list of users who have a specific license type. To do this, follow the steps above, but on step 3, click License type and select the license type you want to export.

Can I export a list of users who are expiring soon?

Yes, you can export a list of users whose licenses are expiring soon. To do this, follow the steps above, but on step 3, click License expiration date and select the Expires in the next 30 days option.

Can I export a list of users who have been inactive for a certain period of time?

Yes, you can export a list of users who have been inactive for a certain period of time. To do this, follow the steps above, but on step 3, click Last sign-in date and select the Inactive for more than 90 days option.

Can I export a list of users in a different format?

Yes, you can export a list of users in a different format. To do this, follow the steps above, but on step 5, select the format you want to export. The available formats are CSV, Excel, and XML.

In this blog post, we have discussed how to export a list of licensed users in Office 365. We first provided an overview of the different licensing options available in Office 365, and then we showed you how to export a list of licensed users using the PowerShell cmdlet Get-MsolUserLicense. We also provided a few tips for troubleshooting common problems.

We hope this blog post has been helpful. If you have any questions, please feel free to leave a comment below.

Author Profile

Against Austerity
Against Austerity
Previously, our website was dedicated to the work of United Front Against Austerity (UFAA). Focused on addressing the economic challenges in the United States, UFAA was committed to fighting against austerity measures that threatened essential social programs. The group emphasized the need for substantial financial reforms to alleviate the economic depression, highlighting two key demands: Implementing a 1% Wall Street Sales Tax and Nationalization of the Federal Reserve System.

In 2023, our website underwent a significant transformation, pivoting from its previous focus on economic and political advocacy to becoming a resource for empowering people through information. Recognizing the evolving needs of our audience, we shifted towards providing in-depth, informative articles that address pressing questions and queries from various fields.

Our website’s transformation is a reflection of our commitment to providing valuable, in-depth information that empowers our readers. By adapting to changing times and needs, we strive to be a trusted source of knowledge and insight in an increasingly complex world.