Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

In my Share Point list has 23072 records, but I am able to exports only 2000 records.

It has multivalued, Lookup, Yes/No & Calculated type columns and around 64 columns are there.

Any ideas, How to export all the data into excel sheet?

Thanks for any responses in advance!

share|improve this question
    
Can you open the list in Datasheet View, and copy everything to Excel? –  tweytjens May 5 at 8:34

1 Answer 1

Below PowerShell script will create different .csv files for all the existing lists in web. , Hope this will be useful.

  Param(
     [Parameter(Mandatory=$True)]
     [string]$webUrl,
     [Parameter(Mandatory=$True)]
     [string]$outPath
    )

  Add-PSSnapin "Microsoft.SharePoint.Powershell"
    $web = Get-SPWeb $webUrl
    write-host ("Path: " + $outPath)
    foreach($list in $web.Lists)
    {
      $exportlist = $null
      $exportlist = @()
      $list.Items | foreach {
        $hash = $null
        $hash = @{}
        foreach($fld in $_.Fields ){
          Try {
            $hash.add($fld.Title, $_[$fld.Title])
          }
          Catch [System.Management.Automation.MethodInvocationException]
          {
            # Eating an error caused by duplicate column names.
          }
          Finally
          {
            #"End"
          }
        }
        write-host ("Exported: " + $_.Title)
        $obj = New-Object PSObject -Property $hash #@{
        $exportlist += $obj

      }
      $expath = $outPath + '\' + $list.Title + '.csv'
      $exportlist | Export-Csv -path $expath #$oPath

    }
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.