How to Export User Skills and Languages from Microsoft Delve
Question details
The user needs to export profile details such as user skills and languages from Microsoft Delve.

- Product
- Microsoft Delve
- Device & OS
- not provided
- Scenario
- Administrators or managers attempting to extract and compile user profile information and employee skillsets for reporting purposes.
- Observed behavior
- Microsoft Delve does not provide a native or built-in export feature to download user profile details like languages or skills directly from the interface.
Ensure you have SharePoint Administrator or Global Administrator permissions in your Microsoft 365 tenant, and verify that the PnP PowerShell module is installed on your computer.
Export Profile Fields Using a Custom PnP PowerShell Script
Since Delve lacks a built-in export tool, utilizing a PnP PowerShell script to query the SharePoint User Profiles is the most effective administrative workaround.
Microsoft Delve surfaces data that is largely stored in SharePoint Online User Profiles. To extract fields like skills and languages, you must query these backend profile properties directly.
You will need to construct a script that connects to your tenant's admin center, iterates through your user base, and pulls the specific SPS properties (like 'SPS-Skills').
Open PowerShell as an Administrator and run 'Install-Module PnP.PowerShell' if you do not already have the module installed.
Run 'Connect-PnPOnline -Url https://[yourtenant]-admin.sharepoint.com -Interactive' to securely authenticate with your SharePoint admin center.
Use the 'Get-PnPUserProfileProperty' cmdlet within a loop to fetch the specific properties (e.g., SPS-Skills) for each user account in your organization.
Pipe the retrieved profile results into the 'Export-Csv' cmdlet to generate a downloadable spreadsheet of the user skills and languages.

Try WPS Office: A Free and Lightweight Office Suite Alternative
While managing user profiles requires specialized Microsoft 365 admin tools, you don't need expensive subscriptions for your daily document tasks. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office desktop apps, ensuring smooth offline and online workflows.
- 1. Visit the Official Website: Open your web browser and navigate to the official WPS Office website.
- 2. Download the Software: Click the 'Download' button to get the free installation package for your operating system.
- 3. Install and Edit: Run the installer, open WPS Office, and seamlessly edit your existing Microsoft Office documents or CSV exports.

Frequently Asked Questions
Can standard users export their own Delve profile data directly?
No, Microsoft Delve does not feature a built-in export option for standard users to download their profile information, such as skills or languages, directly from the user interface.
What SharePoint property names represent skills and languages?
In SharePoint Online user profiles, skills are typically mapped to the internal property name 'SPS-Skills'. Languages or other custom details may be stored under different SPS properties which you must identify in the SharePoint Admin Center before running your PowerShell script.
Is there an alternative to PowerShell for exporting this profile data?
If you prefer not to use PowerShell, you can utilize the Microsoft Graph API to programmatically extract user profiles. Alternatively, there are third-party Microsoft 365 administration and reporting tools available that offer built-in export features for Delve and SharePoint profile data.




