those example which you provided uses server object model PowerShell cmdlets - they work only with Sharepoint on-prem (not with Sharepoint online) and only when this PowerShell runs on the server which is part of Sharepoint farm.

Hi @venkateshpadmanabhan-5594 ,

The code you provided is for SharePoint on-prem and not for SharePoint Online. It is recommended that you can run the following PowerShell script as an admin:

Export SharePoint Online List Items to CSV using PowerShell

 #Config Parameter
 $SiteURL = "https://domain.sharepoint.com/sites/sitename"
 $ListName = "listname"
 #InternalName of the selected fields
 $SelectedFields = @("ID","Title","Choice1","Person1","Date1") 
 $CSVPath = "C:\Temp\ListData.csv"
 $ListDataCollection= @()
     
 #Connect to PnP Online
 Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)
 $Counter = 0
    
 #PageSize:The number of items to retrieve per page request
 $ListItems = Get-PnPListItem -List $ListName -Fields $SelectedFields -PageSize 2000
     
 #Get all items from list
 $ListItems | ForEach-Object {
         $ListItem  = Get-PnPProperty -ClientObject $_ -Property FieldValuesAsText
         $ListRow = New-Object PSObject
         $Counter++
         ForEach($Field in $SelectedFields) 
         {
             $ListRow | Add-Member -MemberType NoteProperty $Field $ListItem[$Field]
         }
         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

Reference:

• Export SharePoint Online List Items to CSV using PowerShell

Thanks,
Echo Du
=========================================
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.