organisation chart web part for SharePoint

Create and Share beautiful org charts with SharePoint

Quick to install. Easy to configure. Simple to use.

Exporting an Org Chart to Excel

The SharePoint Org Chart can be configured to allow end users to export the visible organisation chart to Excel so as to enable analysis and reporting.

Enable the Export to Excel Option

With the web part in Edit mode locate and activate Show Export To Excel option in the Export to Excel configuration section.

Active Directory Organisation Chart
Exporting the Org Chart

After applying the change the export to Excel icon will be shown menu at the top of the web part. The end user simply clicks the button and the chart will be opened in Excel.

Active Directory Organisation Chart

By default the Excel export will contain all the data fields available in the data source.

Excel Org Chart
Setting the columns to export

To specify the individual fields to export put the web part in Edit mode and enter a comma separated list ( column name1, column name2, column name3) of column names in to the Columns to export option in the Export to Excel configuration section.

Hint: Finding the names of the available columns
A quick way to find the available columns is to turn on the Debug Mode option in the Data Sources configuration section. Once applied a list of all available data columns will be shown beneath the chart.
Active Directory Organisation Chart