Highly rated Many readers found this article helpful.

The Vitextra Employee Directory lets you export search results - the list of employees - to a Microsoft Excel spreadsheet.

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

❗ Important
The export to Microsoft Excel feature is available only in Employee Directory version 4.0.0 and higher.

Web Part Settings

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

Employee Directory Web Part Settings

Employee Directory Web Part Settings

📝 Note
Both the Employee Directory and Employee Directory (Entra ID) web parts have similar settings for custom user properties.

Columns

To choose which attributes appear in the exported spreadsheet, open the Columns options and mark the attributes as visible:

Columns Settings

Columns Settings

The column order in the exported Excel file matches the column order specified in the web part settings. Custom attributes are also supported and appear after the built-in attributes.

📝 Note
The columns in the exported spreadsheet are the same as those shown in the details view, except for User Picture and Presence Status, which are ignored during export.

Close the web part configuration pane and save your changes.

Export to Excel

The export action link appears under the search box:

Export to Excel action link

Export to Excel action link

The Employee Directory can export data to Excel from both the User Profiles and Entra ID data sources.

For large result sets, the Employee Directory retrieves all records page by page and then generates the Excel file.

Export large number of records

Export large number of records

The exported Excel file contains plain data, with no links back to the original data source.

Exported list of Employees

Exported list of Employees

📝 Note
The export has a few limitations:

  • The column widths in the exported spreadsheet are fixed.
  • The table style is always Blue, Table Style Medium 2 and cannot be changed.

Questions and answers

Ask a question about this article and get an official answer from our team.

No questions yet. Be the first to ask.

Featured Articles

Why Is Someone Missing from the Organizational Chart?

A troubleshooting checklist for employees who do not appear in the Vitextra Organizational Chart: default exclusions for unlicensed accounts and blank job titles, disabled accounts, guest users, a missing manager in Microsoft Entra ID, filtered-out managers, collapsed levels and the 12-hour data cache.

105 8 min
QR Code Data Types: URL, Text, vCard, Wi-Fi, Email, SMS, Phone, Location and Event

Reference for the nine data tabs of the Vitextra QR Code Generator web part: the fields of each tab, which of them are required, what is written into the QR code and what a smartphone does after scanning it.

99 6 min
Why Doesn't My QR Code Scan?

A troubleshooting checklist for QR codes made with the Vitextra QR Code Generator web part: low contrast and transparent background, a black JPEG background, an oversized logo, a code that is too dense or printed too small, a missing margin, a wrong action after scanning, disabled buttons, the Copy button and changes that are lost after a reload.

107 6 min

Share