12-20-2016 05:36 PM
12-20-2016 05:36 PM
12-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.
12-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.
12-21-2016 02:44 AM
01-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.
01-07-2019 10:28 AM
04-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.
11-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
11-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.
12-23-2019 11:39 AM
01-12-2020 09:40 PM - edited 01-15-2020 08:27 PM
It is FINALLY here!!!
While we are all waiting this freeware has turned up and does the job.
01-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!
02-12-2020 02:47 AM
try thuis .. it is FREE and x10 better than any suggested solution :)