Export Employee List into Excel spreadsheet

5/2/2021
Applies To: Employee Directory

Vitextra Employee Directory makes it possible to export search results (list of employees) to Excel spreadsheet.

This article describes how to enable and set up this feature.

Important
Export to MS Excel spreadsheet feature available only for Employee Directory version 4.0.0 and higher.

Web Part Settings

Open Employee Directory web part settings, scroll down to the Export section, and turn on Microsoft Excel toggle:

Employee Directoyry Web Part Settings

Employee Directoyry Web Part Settings

📝 Note
Both Employee Directory and Employee Directory (Azure AD) web parts have similar settings according to custom user properties.

Columns

To choose attributes which will be presented in exported sreadsheet open Columns options and mark the attributes as visible:

Columns Settings

Columns Settings

The column order in the exported excel file corresponds to the column order specified in the web part settings. Custom attributes are also supported and displayed after the out-of-the-box attributes.

📝 Note
Columns in exported spreadsheet are the same as columns displayed in details view, except User Picture and Presence Status. These two columns are ignored when exporting.

Close the web part configuration pane and save changes.

Export to Excel

The export action link shows up under the search box:

Export to Excel action link

Export to Excel action link

The Employee Directory supports both User Profiles and Azure AD data source for exporting data to Excel spreadsheet.

In case of a large number of records, Employee Directory extracts all records page by page and generates an Excel file.

Export large number of records

Export large number of records

Exported excel file contains data with no links to the original data source.

Exported list of Employees

Exported list of Employees

📝 Note
There are some limitation of exporting functionality:

  • Width of the columns in exported spreadsheet is fixed
  • Style of the table is Blue, Table Style Medium 2 can'be changed

See Also

Share