Issues when creating a list from Excel (Modern List) - Help

Iron Contributor

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 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. 

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-...
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'
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/