Others

How to Export User Skills and Languages from Microsoft Delve

Rana GarciaRana Garcia Oct 23, 2026 869 views

Question details

The user needs to export profile details such as user skills and languages from Microsoft Delve.

How to Export 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.
Before you start

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.

Solution 1Recommended

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').

1
Install PnP PowerShell

Open PowerShell as an Administrator and run 'Install-Module PnP.PowerShell' if you do not already have the module installed.

2
Connect to SharePoint Online

Run 'Connect-PnPOnline -Url https://[yourtenant]-admin.sharepoint.com -Interactive' to securely authenticate with your SharePoint admin center.

3
Retrieve User Profile Properties

Use the 'Get-PnPUserProfileProperty' cmdlet within a loop to fetch the specific properties (e.g., SPS-Skills) for each user account in your organization.

4
Export the Data to CSV

Pipe the retrieved profile results into the 'Export-Csv' cmdlet to generate a downloadable spreadsheet of the user skills and languages.

Export Profile Fields Using a Custom PnP PowerShell Script
Need Help Writing the Script?: If you need assistance constructing the exact PnP PowerShell loop, it is highly recommended to post a request in the Microsoft Q&A forums where the community can provide up-to-date script templates.
Free Microsoft Office alternative

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. 1. Visit the Official Website: Open your web browser and navigate to the official WPS Office website.
  2. 2. Download the Software: Click the 'Download' button to get the free installation package for your operating system.
  3. 3. Install and Edit: Run the installer, open WPS Office, and seamlessly edit your existing Microsoft Office documents or CSV exports.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Process exported CSV profile reports effortlessly using WPS Spreadsheet.Lightweight design that runs smoothly on almost any computer.Familiar and intuitive user interface requires zero learning curve.
microsoft office alternative - wps office

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.