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.
- Hi Susan, were you able to resolve this issue? I'm looking for this exact solution myself.
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.
try thuis .. it is FREE and x10 better than any suggested solution 🙂
Create Office365 SharePoint List from a CSV file and get the data transferred
Here is a 4 minute video that shows you - and it is ALL FREE!
It is FINALLY here!!!
While we are all waiting this freeware has turned up and does the job.
download: https://www.nocodesolution.com/
feature list: https://docs.nocodesolution.com/fusion/1/en/topic/fusion-feature-list
// Steen
- I've used Flow to do this before as on selected item in a doc library and scheduled. You can use Get Rows from Excel if you store the file in a doc library or OneDrive and then add a create item in SharePoint. The Excel get rows has a 500 row limit so I used a loop to get batches of 500 and change the start row in the Get Row action based on a variable. You'll need to use a date or flag column in the spreadsheet to track which ones have been done and update it in the loop
Alan MarshallDo you have a Flow process for updating existing items in a list from Excel?
Alan Marshall Is it possible to provide instruction on how to accomplish such tasks, please? I am a beginner user of SharePoint. I tried to recreate the SharePoint list with updated Excel file in document library using MS-Flow but somehow failed. Thanks in advance.
Assuming you are using Sharepoint Online (SPO) or '19, Here might be the place to start for that task: https://support.office.com/en-us/article/edit-list-items-in-sharepoint-online-dac1a1c3-a80b-4082-ba57-715cf613d0f7
If you are using earlier versions of Sharepoint, the process is quite similar with the exception "Quick View" is called "Edit in Datasheet"
You will likely get a much speedier answer to queries posted here if you first ensure the answer is not easily available within the Microsoft Help/Support/Training pages. https://support.office.com/en-us/sharepoint
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.
Thanks Andrew Koltyakov. Thanks Sergei Snitko.
- Nothing to share from my side, Andrew and Sergei have explained very well the options you have :-)
Hello
There is a very simple solution and it can help you.
1. Open the SharePoint Online site in Internet Explorer and add in to trusted sites
2. Open the excel file and look at the columns and remember thу sequence of them.
3. Open the list you need in classic mode and edit the default view, or add a new view. You need to show the fields of the list that you need to map with excel columns. So as a result, you have to make the SharePoint table view the same like it looks in Excel
4. Click the Edit button in the table view, and the table view changes to the edit mode.
5. Open the excel table and select the area you need. Press ctrl+c on tha keyboard
6. Open the SharePoint view, select the first cell and press ctrl+v on the keyboard.
Tha data is imported.
The copy and paste in Sharepoint 265 is limited to 50 rows at a time. If you copy more than 50 rows you may get errors.
