Jun 22 2017
07:07 AM
- last edited on
Jul 12 2019
10:47 AM
by
TechCommunityAP
Jun 22 2017
07:07 AM
- last edited on
Jul 12 2019
10:47 AM
by
TechCommunityAP
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?
Jun 22 2017 06:43 PM
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.
Jul 24 2017 02:20 PM
is there no way to replace or addend to the List?
Feb 14 2018 10:21 AM
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?
Feb 14 2018 04:24 PM
The GUID identifies the list. Pasting data into the list does not change the GUID. Why should it?
Feb 14 2018 05:12 PM
Mar 22 2018 11:51 AM
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
Mar 23 2018 04:49 AM
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-e...
Mar 23 2018 06:26 AM
Sergei,
Thanks for the info. I will get our crew to up-vote in uservoice.
Christine
Mar 24 2018 12:53 AM
The original question is about linking Excel data to the SharePoint list.
The last few posts in this thread veer off to a completely different topic. This is not related to the original question, so please use a new thread to discuss your other issues.