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)
Gilbert Okello Did you ever get a solution to this problem? I want to do the same thing but the replies I see do the opposite of what we want to do. We want our Excel table to update our SharePoint list when we make changes to our Excel table. However, the replies appear to do the opposite.
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.
- Hi, could you also provide me with this info? It'd be greatly appreciated!
- Hi MrNoCode ! Can you please share this with me as well. I'm much interested.
- yes I sent you a message
- I would love your assistance with this as well.
MrNoCode That is great! Yes, I am interested. I cannot get anything to work.
I just tried MS Automate (Flow) again and it says that my test was successful but it doesn't even create my list.
Please help me.
