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.
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.
