Copy/Paste Excel data into SharePoint list


Blog site René van Duren

​I was asked to create a simple list which could be initially filled with data available in a Excel sheet. It was said that this could be done by the good old copy/past routine.

So when had created the content type and the list (based on the content type) I was was ready to copy/paste the data in the list. And guess what…it didn’t work because it said that there were columns that require data but these are not included in the view.

And I was sure that all my columns were not required, they we’re all optional.

Plaatje1Excel2SP

So, I started looking around and after a while I found the solution why this error happened to me. To fix this you need to go to your Advanced Settings of your list and set the ‘Allow management of content types‘ to NO.

Plaatje2Excel2SP

When you save the settings and return to the previous screen…

View original post 78 more words