Export Excel data to a Sharepoint Custom List

Hello,

you can create a SharePoint list from data in an Excel workbook, but after the list has been created, there is no further connection between the workbook and the list. It is a one-time thing only. So, when you add new data to that Excel workbook, this data will not show in SharePoint.

You can, however, show the SharePoint list in the datasheet grid and then manually copy and paste data from the Excel workbook to the SharePoint list, or instead of entering the data into Excel, just enter it straight into SharePoint.