Forum Discussion
How to update a sharepoint list from excel table?
Excel 2013 I have lot of working excel workbooks, that are update on daily basis from several users. I wish to push to a Sharepoint list a standard content (table) in order to create only one...
Unfortunately, over the course of the last few years, the previously strong link between Excel workbooks and SharePoint lists has been neglected. It is now no longer easy to synchronize changes in an Excel workbook to a SharePoint list.
If you are using SharePoint online with an Office 365 plan that includes Flow, you can build a flow to update a SharePoint list item when the Excel file is changed. The mechanics of this has many moving parts, though, and requires, if not programming skills, at least a programmer's understanding of how data is stored and retrieved.