Export O365 Organization Chart details into XL or text files

Question

How to Export O365 Organization Chart details into XL or text files?

Answer 1

Hello!

Thanks for asking a Question!

To export organization chart details of your Office 365 (O365) users into an Excel or text file from SharePoint Online, here are a few options:

1. Use SharePoint Online PowerShell: You can use SharePoint Online PowerShell module to export user information from SharePoint User Profile Service. This is particularly useful if you want to export user properties such as Manager, Title, Department etc. you can use the export-csv or export-text cmdlets to export data to Excel or text file.
2. Use SharePoint UI: You can use the SharePoint User Profile Service to view user information, if the Manager property is set up correctly, you can use the "Organization chart" feature to view the organizational structure. You can also export this information to Excel using the built-in "Export to Excel" feature.
3. Use Third-party tools: There are also third-party tools that can help you export the organization chart details of your O365 users. Some examples are ShareGate, Nintex and Microsoft Flow. These tools can automate the process of retrieving and exporting the data for you, and also provides a more advanced features and more data to export.

Answer 2

Hi @sweetu ve ,
First of all, I want to confirm with you that the org chart you mentioned refers to the personnel structure or the site structure.
According to my research and testing, SharePoint Online currently has no OOTB way to achieve your needs. SharePoint Online has an organization chart web part, but it can only perform simple display and management for organization chart,  cannot export.
The web part like this:

For more information, please refer to:
https://support.microsoft.com/en-us/office/use-the-organization-chart-web-part-77e3fd2e-568c-454c-a0b4-611eb79fce11#:~:text=Click%20%2B%2C%20and%20then%20select%20Organization,chart%20into%20the%20search%20bar.&text=In%20the%20Organization%20chart%2C%20enter,Name%20or%20email%20address%20box.
To address your concern about the situation, we’d suggest you go to feedback on this issue, this is the best platform to let us hear from you and make our products and services better for you and others.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.