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.