I am having trouble with a CSV file I wish to import. I save a UTF-8 copy off the original .xlsx which retains the correct date formatting unless I open the CSV. I have tried uploading it without opening it first; however, I receive the following error: “The rows are not all the same number of columns.” This error is easily resolved by opening the CSV in Excel but then the date formats are lost. I am using semi-colons as the delimiter.
I know there is a way around this I just can’t recall what I did previously. Any advice would be appreciated.