Forum Discussion
Gilbert Okello
Dec 21, 2016Iron Contributor
Updating SharePoint List from Excel
John White, jcgonzalezmartin is there a way to update a sharepoint list from Excel? (other than through 3rd party tools like SoftFluent's Sharepoint list synchronizer? SharePoint List Synchronizer)
Dec 21, 2016
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.
- Gilbert OkelloDec 21, 2016Iron Contributor
Thanks Andrew Koltyakov. Thanks Sergei Snitko.
- Dec 21, 2016Nothing to share from my side, Andrew and Sergei have explained very well the options you have :-)