Forum Discussion
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)
SusanSRG , Gilbert Okello , Sylvie_in_France , LauraB1858 , Ryuojiin
I have the complete 100% solution with no code to do sync from Excel to SharePoint Online or on-prem list. (100% free)
It also works from sqlserver, ODBC and CSV.
It creates missing items and update the changes made in the Excel book to existing items in the list.
It runs on any machine including a VM in azure as a an unattended windows service that has a build in scheduler. Also when something goes wrong you can be notified on email, windowsEventLog or invoke an automated Powe Automate cloud flow.
If you are interested I can show you how to use it and help you get started.
Thanks
//Steen
if you are able to assist... what steps I have taken so far is successfully created a Microsoft List on SharePoint by importing Excel file, also on SharePoint for our team. The specific team members update the Excel file of data. The Excel file is 282 rows and counting of data with a variety of column data types, however only a subset of the columns are imported into the List that was created. I would like to make updates in excel and then it automatically populate that data into the List. At this point the List can be read-only, but it would be most preferred if edits can be synced/populated in both directions. I'm just unsure how to make this work as any power automate I try is not working and all the googled info seems to be related to syncing an excel file with List updates, whereas I want the opposite scenario.
