Import excel data into SharePoint list using REST API

Question

How to import excel data into a SharePoint list using Rest API in SharePoint Online, and sharepoint server.

Answer 1

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.

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 
}