Forum Discussion
Sharepoint List not importing Excel Headers
I noticed lately that SharePoint is not importing the Excel table header names as column/internal name in SharePoint List. It was working before and I know it because I can check them in the List set...
Ensure your cells are formatted as Table (Convert to table). Click inside the table. In the Table menu -> External Table Data Group -> Export -> Export Table to SharePoint. Enter or copy SharePoint site (or subsite) URL. Give a name which will be used as List name in SharePoint. See that data types are correct. If not, cancel and select correct data type for cells (columns). Confirm.