Forum Discussion
Creating SP List from Excel Workbook
When I create a new SP List from and existing Excel file the conversion always turns the column heading from Excel to 'Field_' (whatever number) in the new SP List.
Why does this happen, and is there a way to stop it so that the original Excel column heading shows in the SP List?
4 Replies
Can't reproduce. Perhaps you may give bit more details, are you in 365 environment or not; do you use New->List->From Excel or New->List->From CSV ?
SergeiBaklan Yes, 365 environment, SharePoint site, New List, New List from Existing Excel.
I have been told that my issue will occur when a source has column names that also match the default/system column names provided in SharePoint.
When this occurs SharePoint will not use the name, but will name the field(s) starting with 'Field_1'.
I have not yet tested this reasoning, but it makes sense.
I didn't test as well, but most probably yes. That's standard behaviour if you try to repeat existing name.
- Duplicate of thread posted on SharePoint blog
https://techcommunity.microsoft.com/t5/sharepoint/creating-new-sp-list-from-excel-document/m-p/3900014/highlight/true#M73713
