Question: how to change the default date format in 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.