How to export sharepoint list description located in Additional Column Settings?

Question

How can I include description of each field/column when exporting sharepoint list ?

Answer 1

Hi Ignjic, Sladjana,

Good day! Welcome to Q&A forum.

To include field/column descriptions when exporting a SharePoint list, you'll need to use methods beyond the standard export options.

Using SharePoint Online PowerShell:

---

Connect to SharePoint Online

Connect - SPOService - Url https://yourtenant.sharepoint.com - Credential (Get - Credential)

Specify the site and list

$siteUrl = "**https://yourtenant.sharepoint.com/sites/yoursite**"

$web = Get - SPOWeb - Url $siteUrl

$list = $web.Lists.GetByTitle("YourListTitle")

Get list fields

$fields = $list.Fields

Get list items

$items = $list.Items

Prepare data for export

$exportData = @()

foreach ($item in $items) {

    $row = New - Object PSObject

    foreach ($field in $fields) {

        $fieldName = $field.Title

        $fieldDescription = $field.Description

        $fieldValue = $item[$field.InternalName]

        $row | Add - Member - MemberType NoteProperty - Name "$($fieldName) ($($fieldDescription))" - Value $fieldValue

    }

    $exportData += $row

}

Export to CSV

$exportData | Export - CSV - Path "C:\Temp\SharePointListExport.csv" - NoTypeInformation

---

Note: highlight is parameter.

Hope these information helps.

Please do let us know if you have any further queries.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.