Forum Discussion

Copper Contributor

Jun 22, 2017

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?

BI & Data Analytics

Requests

ChristineStack

Iron Contributor

Mar 22, 2018

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

SergeiBaklan

Diamond Contributor

Mar 23, 2018

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

ChristineStack
Iron Contributor
Mar 23, 2018
Sergei,

Thanks for the info. I will get our crew to up-vote in uservoice.

Christine
- IngeborgHawighorst
  MVP
  Mar 24, 2018
  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.