Forum Discussion
Issues when creating a list from Excel (Modern List) - Help
Hi All,
I have an excel sheet i imported into a sharepoint list but when i go and try and edit the form i can only see the title and attachments.
All other fields don't show up 😞
Any reason why. Also sometimes during import i get error saying the list already exist which is false. But when i look at the recycle bin its there. It just goes there automatically
Very strange behaviour with the modern list
Any tip or help would be appreciated
5 Replies
- Patrick, perhaps this article will be helpful in the future. I've found that there are other more effective methods for importing a spreadsheet into a list... https://sharepointmaven.com/3-ways-import-excel-sharepoint/
- Thanks all.
I ended up doing the below : (Can MS please fix this issue moving forward)
Go into the list Advanced settings and set 'Allow management of content types?' to YES
When you leave the Advanced settings you'll see the Content type(s) showing on the screen above the columns you have
Click on the content type (it's a link) - for me it was 'Item'
Once into 'Item' I was able to add the columns imported via Excel, to the content type 'Item'
After that - they showed up in the 'form view' - Linking your thread with another thread that was posted on 8/4 with no resolution to date. No help I know, just FYI. 😞
https://techcommunity.microsoft.com/t5/sharepoint/imported-excel-file-columns-not-showing-in-form/m-p/2611812/thread-id/52644 Patrick Rote We are also have the same issue. The Body of the List should having the same issue I should be seeing 8 columns. I added Json code to see if the items would appear but, nothing changed besides a bit of formatting.
- Chris_McCann replied to the post below with the resolution.
https://techcommunity.microsoft.com/t5/sharepoint/imported-excel-file-columns-not-showing-in-form/m-p/2611812/thread-id/52644
