Forum Discussion
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.
is there no way to replace or addend to the List?
Not with Excel.
When you connect to SharePoint list with Power BI it actually connects to a GUID. Does cutting and pasting direct to the SharePoint List Change this GUID?
The GUID identifies the list. Pasting data into the list does not change the GUID. Why should it?