Creating A SP List From Excel XLSX - Created Date Column Problematic

Not applicable

I have exported a SP List to a csv file, opened the csv file and edited select columns with the goal of creating a new SP list from an Excel file.  I then name my table and save as a worksheet (.xslx).  The issue occurs when I try to create the new SP List as the Created column (auto created by SP) is showing as "Do not import" as shown below.
Excel Column Type - CreatedDate Problematic When Creating New List.png
When I review my column type in the Excel table, it is not getting a type assigned and worse yet, there is no date-time option (see below).  Any recommendations are greatly appreciated.   
Excel Column Type - NO DateTime Option.png

0 Replies