To sort by date in Excel or to export to MySQL, the data must be treated as a Date Field. Currently, it does not work for this file.
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent
If you want it in Excel, do this formatting only once (and obviously, save it in Excel format):
Or if you really want it as CSV (because the import app only accepts that), try setting it to this format (yyyy-mm-dd), and save it back to CSV:
And then hope the import is smart enough to know this is really a date.