SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '14 at 8:34

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


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


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.