Forum Discussion
Export Excel data to a Sharepoint Custom List
How does one link Excel data (just 6-8 fields) to automatically fill columns in a Sharepoint list when the document is uploaded. Is a connection library needed?
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.
Copying and pasting from excel into a Modern Custom list does not appear to work anymore. Can someone else confirm this. I tried via Edge and Chrome. Does anyone know of another way that does work for getting your excel data into a Modern Custom List.
Thanks in advance
Hi Christine,
To my knowledge that doesn't work with modern experience (so far), only with classic lists. The nearest user voice i found is https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/17804779-update-excel-and-access-sharepoint-list-creation-t
is there no way to replace or addend to the List?
Not with Excel.
