asked on

Export Office 365 users to a CSV

Hello Experts,

Im just looking for a way to export the office 365 users to a CSV file with those parameters:

1-First Name.
2-Last Name.
3-Department.
4-Job Title.
5-Manager.
6-Email Address.

I already tried the get-msoiservice command but the manager parameter is not included, so any help?

Thanks.

SOLUTION

Vasil Michev (MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Abdul Ali

ASKER

Thanks Vasil, i already tried that but the manager parameter no included that is why i was looking for other command that can export all those required parameters.

Vasil Michev (MVP)

To include the manager, you can use the Get-User cmdlet or if you are using the new Azure AD PowerShell module, Get-AzureADUserManager.

Jessica K

Hello Abdul Ali,

You can go for the manual method proposed by the expert Vasil Michev. And if you need a fast solution for exporting your Office 365 user data to CSV file format, I would like to suggest you a third party software that will transfer your Office 365 user parameters into CSV file format directly.

You can refer the link for further information: https://goo.gl/g6v3z8

Thanks and regards,
Jessica

ASKER CERTIFIED SOLUTION

Todd Nelson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Todd Nelson

Sufficient info provided for a solution.