Updating SharePoint List from Excel

Hi Gilberto,

It depends on the usage scenario (one-time run or periodical, update by recreating all items, adding new, update existing by the key, should the list structure be the same or dynamic, amount of data, all of these make sense).

For basic cases one can use Excel's export to SharePoint list feature or inline editing feature and copy pasting for small data amount.

For complex periodic and rollup data from numerous excel documents scenarios a customization probably is the best and only option. It can be the technology of choise to read data from Excel (let's say ClosedXML .Net library or XLSX.js Node.js or Excel COM automation) and technology to write and update data in SharePoint (CSOM, SSOM or REST APIs) and settings layer extention.

Or 3rd parties, as mentioned above.