How to export a SharePoint to Excel list using PnP Powershell

PnP PowerShell does not provide a function to directly export an item from the list to Excel.
You can use the code below to obtain, using the Export-CSV command:

Add-Type -Path "C:  Common Programs  Common Files  Microsoft Shared  Web Server Extensions  16  ISAPI  Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:  Common Programs  Common Files  Microsoft Shared  Web Server Extensions  16  ISAPI  Microsoft.SharePoint.Client.Runtime.dll"

## Variables for processing
$ SiteUrl = "https://xxx.sharepoint.com/sites/xxx/"
$ ListName = "xxx"
$ ExportFile = "c:  Scripts  ListRpt.csv"
$ UserName = "xxx@xxx.onmicrosoft.com"
$ Password = "xxx"

# Configuration IDs to connect
$ Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials ($ UserName, (ConvertTo-SecureString $ Password - AsPlainText -Force))

# Configure the context
$ Context = New-Object Microsoft.SharePoint.Client.ClientContext ($ SiteUrl)
$ Context.Credentials = $ login information

#Get the list
$ List = $ Context.web.Lists.GetByTitle ($ ListName)

#Get all the items in the list
$ Query = New-Object Microsoft.SharePoint.Client.CamlQuery
$ ListItems = $ List.GetItems ($ Query)
$ context.Load ($ ListItems)
$ context.ExecuteQuery ()

#Array to Hold List of items
$ ListItemCollection = @ ()

#Fetch each list item value to be exported to Excel
$ ListItems | for each {
$ ExportItem = PSObject New-Object
$ ExportItem | Add-Member -MemberType NoteProperty -name "Title" -value $ _["Title"]

    #Add the object with the above properties to the board
$ ListItemCollection + = $ ExportItem
}
#Export the Array result to a CSV file
$ ListItemCollection | Export-CSV $ ExportFile -NoTypeInformation

Write-host "List of exported data in a CSV file successfully!"

Reference:

SharePoint Online: Export List Items in CSV Format Using PowerShell