Imported Excel File Columns not showing in form

%3CLINGO-SUB%20id%3D%22lingo-sub-2611812%22%20slang%3D%22en-US%22%3EImported%20Excel%20File%20Columns%20not%20showing%20in%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611812%22%20slang%3D%22en-US%22%3E%3CP%3ERecently%20imported%20an%20excel%20file%20into%20a%20SP%20List%20everything%20imported%20successfully.%20However%20when%20I%20go%20to%20enter%20a%20new%20entry%20the%20columns%20that%20I%20imported%20aren't%20showing%20in%20the%20form.%20I%20tried%20to%20go%20to%20configure%20layout%20and%20there%20are%20not%20found%20there.%20Any%20idea%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2611812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632770%22%20slang%3D%22en-US%22%3ERe%3A%20Imported%20Excel%20File%20Columns%20not%20showing%20in%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632770%22%20slang%3D%22en-US%22%3EI'm%20seeing%20the%20same%20issue%20and%20haven't%20found%20any%20resolutions%20online%20yet.%20Has%20anyone%20else%3F%3CBR%20%2F%3ECouple%20notes%3A%3CBR%20%2F%3E1.%20Issue%20was%20not%20present%20a%20couple%20of%20weeks%20ago%3CBR%20%2F%3E2.%20After%20importing%20my%20excel%20document%20I%20only%20see%20the%20Title%20and%20Attachment%20fields%20on%20the%20new%20and%20edit%20forms.%20None%20of%20my%20imported%20excel%20fields%20are%20showing.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2615495%22%20slang%3D%22en-US%22%3ERe%3A%20Imported%20Excel%20File%20Columns%20not%20showing%20in%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2615495%22%20slang%3D%22en-US%22%3EAnyone%20know%20a%20solution%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632825%22%20slang%3D%22en-US%22%3ERe%3A%20Imported%20Excel%20File%20Columns%20not%20showing%20in%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632825%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696843%22%20target%3D%22_blank%22%3E%40kim_williams_kdub%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOkay%20-%20I%20have%20the%20answer%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EGo%20into%20the%20list%20Advanced%20settings%20and%26nbsp%3Bset%20'%3CSPAN%3EAllow%20management%20of%20content%20types%3F'%20to%20YES%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EWhen%20you%20leave%20the%20Advanced%20settings%20you'll%20see%20the%20Content%20type(s)%20showing%20on%20the%20screen%20above%20the%20columns%20you%20have%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EClick%20on%20the%20content%20type%20(%3CU%3Eit's%20a%20link%3C%2FU%3E)%20-%20for%20me%20it%20was%20'Item'%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EOnce%20into%20'Item'%20I%20was%20able%20to%20add%20the%20columns%20imported%20via%20Excel%2C%20to%20the%20content%20type%20'Item'%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EAfter%20that%20-%20they%20showed%20up%20in%20the%20'%3C%2FSPAN%3E%3CSPAN%3Eform%20view'%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EI%20hope%20it%20helps!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EChris%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Recently imported an excel file into a SP List everything imported successfully. However when I go to enter a new entry the columns that I imported aren't showing in the form. I tried to go to configure layout and there are not found there. Any idea?

10 Replies
Anyone know a solution?

Same issue - no idea, keen to get an answer, as it's a bit of a problem! @jcurrie94 

I'm seeing the same issue and haven't found any resolutions online yet. Has anyone else?
Couple notes:
1. Issue was not present a couple of weeks ago
2. After importing my excel document I only see the Title and Attachment fields on the new and edit forms. None of my imported excel fields are showing.

@kim_williams_kdub 

 

Okay - I have the answer:

 

  • 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'

I hope it helps!

 

Chris

 

Chris, This worked! Thank you for the workaround!! Hopefully, MS can get the issues fixed, but for now, I'm good with using the workaround. :)
Thank you so much!!! This worked beautifully!

@Chris_McCann Hey Chris, After I enabled Allow Management of content types, my form is still not showing all the columns. 

jcurrie94_0-1628695559980.png

 

I was able to get them added to the form by adding them to the Content Type Item however when I try to rearrange the columns in the form it will not save. Any ideas?

@jcurrie94 I was able to successfully change the form field order by:
! After adding the imported fields to the Item content type
  1. Turn off "allow management of content types" 
  2. Go  List Settings and selecting the Column ordering link in the Column section and change the order of fields here and saving

 

Hope this works for you as well.

Thank you Chris, worked like a charm.