Question: how do i change a date format from yyyy mm dd to csv?
Answer: Open your file in Microsoft Excel. Right-click the column containing dates. Select "Format cells" Click "Date" under Number >> Category. Ensure the Location (Language) is set to be United Kingdom (English) Select formatting that shows the date in the dd/mm/yyyy format.