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)
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.
