Is it possible to Import Excel data to a SharePoint List Using RESt API?
Unfrothantly, There is NO REST API endpoint to import excel data to a SharePoint list.
Workarounds
The available workarounds are:
- Using the OOTB import spreadsheets in SharePoint.
- Using PowerShell to add items from the excel sheet in SharePoint List.
1) Using the OOTB import spreadsheets in SharePoint.
- Open your SharePoint Site.
- Click on the Setting icon > Add a new APP.
- Search for Import Spreadsheets.
![import spreadsheets in SharePoint](https://spgeeks.devoworx.com/wp-content/uploads/2019/03/import-spreadsheet-to-sharepoint.png)
Read more about SharePoint Import Spreadsheets considerations at Import Excel Sheet Into Project Server
2) Using PowerShell to add items from the excel sheet in SharePoint List.
Install-Module SharePointPnPPowerShellOnline
$Listitems = Import-CSV "C:\listItems.csv"
foreach($item in $Listitems){
$List = @{}
$item.psobject.properties | ForEach-Object { $List[$_.Name] = $_.Value }
$suppress = Add-PnPListItem -List "SharePoint List" -Values $List
}