Display assistants in Org Chart for SharePoint and Microsoft Teams (Excel/CSV)

Org Chart supports displaying assistants alongside employees in the organizational hierarchy. This article explains how to configure assistants when using a Excel/CSV file as the data source.

The following examples show how assistants appear in the Classic top-to-bottom layout. Assistant placement may vary depending on the selected layout.

Example with a single assistant:

Org Chart showing one assistant connected to an employee

Example with multiple assistants:

Org Chart showing four assistants connected to an employee

Display assistants for Excel/CSV list data source

If you use the Excel/CSV data source, map the file columns in the Field mappings section of the configuration wizard:

Org Chart field mapping configuration for the Assistant ID column

In this example, the Excel file contains a column named AssistantEmail that stores assistant email addresses. You can enter several values as a semicolon-separated list.

AssistantEmail column containing assistant email values in the Excel source file

After creating the column, map the Assistant ID field in Org Chart settings to that column.

Finally, clear the Org Chart cache to reload the updated data.

Note

Check out how to display assistants for the SharePoint list, User profiles and Entra ID data sources.