Gallery view missing when importing excel spreadsheet to list.

%3CLINGO-SUB%20id%3D%22lingo-sub-1904078%22%20slang%3D%22en-US%22%3EGallery%20view%20missing%20when%20importing%20excel%20spreadsheet%20to%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1904078%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%20hoping%20someone%20can%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20create%20a%20new%20list%20from%20within%20Modern%20Sharepoint%2C%20I'm%20able%20to%20set%20the%20view%20to%20%22Gallery%22%20which%20formats%20the%20view%20to%20cards.%20This%20is%20ideal%20for%20the%20way%20I%20want%20to%20represent%20content%20and%20I've%20been%20prototyping%20in%20this%20view.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I'm%20ready%20for%20actual%20data%2C%20so%20I've%20used%20Microsoft%20Excel%20to%20export%20a%20sheet%20into%20sharepoint%20as%20a%20list.%20This%20is%20successful%3B%20however%2C%20the%20gallery%20view%20is%20missing.%20Only%20the%20%22List%22%20and%20%22Compact%22%20view%20items%20are%20present.%20When%20I%20go%20to%20format%20the%20view%2C%20card%20designer%20is%20not%20present.%20Only%20formatting%20for%20specific%20rows%2Fconditional%20formatting%20options%20are%20present.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20feel%20like%20I'm%20missing%20someone%20simple.%20Has%20anyone%20had%20this%20problem%3F%20I'm%20not%20getting%20any%20results%20when%20I%20search%20online.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1904078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2056982%22%20slang%3D%22en-US%22%3ERe%3A%20Gallery%20view%20missing%20when%20importing%20excel%20spreadsheet%20to%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2056982%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20having%20the%20exact%20same%20issue!!%20Did%20you%20find%20a%20solution%3F%3C%2FLINGO-BODY%3E
New Contributor

Hello all, hoping someone can help. 

 

When I create a new list from within Modern Sharepoint, I'm able to set the view to "Gallery" which formats the view to cards. This is ideal for the way I want to represent content and I've been prototyping in this view. 

 

Now I'm ready for actual data, so I've used Microsoft Excel to export a sheet into sharepoint as a list. This is successful; however, the gallery view is missing. Only the "List" and "Compact" view items are present. When I go to format the view, card designer is not present. Only formatting for specific rows/conditional formatting options are present. 

 

I feel like I'm missing someone simple. Has anyone had this problem? I'm not getting any results when I search online. 

2 Replies
I’m having the exact same issue!! Did you find a solution?

@EKBLOX 

Yes, I think I worked around it by using Sharepoint to import the file instead of using excel to export to Sharepoint.