Transfer Sharepoint List Contents to Excel

Bob Wilson 1 Reputation point
2021-09-01T02:56:15.583+00:00

Hello,

So I have certain items on a SharePoint List and I would like to transfer the contents of each item to Excel. I’m not talking about the items that I can see once I click on the list but rather the contents of each list item, because each individual item has contents of its own.

Thank you

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,229 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Echo Du_MSFT 17,306 Reputation points
    2021-09-01T08:39:25.337+00:00

    Hello @Bob Wilson ,

    Welcome to Q&A Forum!

    Please following steps:

    1.If in the current view not set any filter, in other words you can view all items in the list. You can click on Export >> Export to Excel in the top menu bar

    128264-a1.png

    128237-a2.png

    2.Please run the below powershell script as an admin to export all list items to CSV

    $SiteURL = "https://tenant.sharepoint.com/sites/du"  
    $ListName = "listname"  
    $CSVPath = "C:\temp\ListData.csv"  
    $ListDataCollection= @()  
    
    #Connect to PnP Online  
    Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)  
    $Counter = 0  
    $ListItems = Get-PnPListItem -List $ListName -PageSize 2000  
    
    #Get all items from list  
    $ListItems | ForEach-Object {  
            $ListItem  = Get-PnPProperty -ClientObject $_ -Property FieldValuesAsText  
            $ListRow = New-Object PSObject  
            $Counter++  
            Get-PnPField -List $ListName | ForEach-Object {  
                $ListRow | Add-Member -MemberType NoteProperty -name $_.InternalName -Value $ListItem[$_.InternalName]  
                }  
            Write-Progress -PercentComplete ($Counter / $($ListItems.Count)  * 100) -Activity "Exporting List Items..." -Status  "Exporting Item $Counter of $($ListItems.Count)"  
            $ListDataCollection += $ListRow  
    }  
    #Export the result Array to CSV file  
    $ListDataCollection | Export-CSV $CSVPath -NoTypeInformation  
    

    128265-a3.png

    128208-a4.png

    Thanks,
    Echo Du

    ======================================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.