Forum Discussion
Phishdawg
Aug 15, 2023Brass Contributor
Creating SP List from Excel Workbook
Creating New SP List from Excel Document 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 ...
SergeiBaklan
MVP
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 ?
Phishdawg
Aug 22, 2023Brass Contributor
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.
- SergeiBaklanAug 22, 2023MVP
I didn't test as well, but most probably yes. That's standard behaviour if you try to repeat existing name.