Updating SharePoint List from Excel

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.