Dec 20 2016 05:36 PM
Dec 20 2016 05:36 PM
Dec 20 2016 10:24 PM
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.
Dec 20 2016 11:06 PM
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.
Dec 21 2016 02:44 AM
Jan 07 2019 07:59 AM
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.
Jan 07 2019 10:28 AM
Apr 03 2019 07:03 PM
@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.
Nov 29 2019 09:00 AM
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-ba5...
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
Nov 29 2019 10:20 AM
@bronniecplaceThank you for looking for answers on this topic. I've been watching it. Your reply doesn't address how to make these edits in Excel. Meaning, if I have an Excel spreadsheet linked to SharePoint, can I have it set to update particular columns for items already added and synced. For example, if I have an inventory list in excel that is set to export to SharePoint, can I edit prior rows (maybe like a quantity column that has how many of the item I have on hand) and have Excel recognize that the change needs to update an existing row and not create a new row. The goal is to be able to automate the update to existing rows on SharePoint using a master list in Excel.
Dec 23 2019 11:39 AM
Jan 12 2020 09:40 PM - edited Jan 15 2020 08:27 PM
It is FINALLY here!!!
While we are all waiting this freeware has turned up and does the job.
Jan 26 2020 10:54 PM
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!
Feb 12 2020 02:47 AM
try thuis .. it is FREE and x10 better than any suggested solution :)
Feb 25 2021 01:42 AM
The solution I've been using for years is the following :
There are many other tips to facilitate this way of working. I must make a video one day to share that!
May 03 2021 09:06 PM
@Sylvie_in_France I've been searching for something like however, I have encountered a syntax error when adding the formula in the excel sheet. Any chance you have a video of this?
Also just to clarify, update the SharePoint List will be done via the Excel Button Sheet?
Thank you in advance for any help!
May 04 2021 07:07 AM
Could you copy paste the formula and the error message so that I can help you?
To update the SharePoint list from Excel, you have to click on the "Edit" hyperlink on any row/item to modify. This hyperlink open the "edit item" page on SharePoint. Modify the item and Save it. Go back to Excel and refresh the table. Your data is updated in Excel.
You can of course modify serval items one by one, using their respective "Edit" hyperlink, and update the Excel file from times to times.
No video yet, sorry!
Keep me updated :)