SSconvert convets date to YYYY-MM-DD irrespective of xlsx date format

Question

I am using ssconvert to convert xlsx to csv. One of the column has date field so when I convert it into csv date column value has converted into YYYY-MM-DD

Input:

Name Date
Test 05/08/2021

Command:

ssconvert test.xlsx  test.csv

Output:

Name,Date
Test,2021-08-05

Expected Output:

Name,Date
Test,05/08/2021 

Answer 1

This should be working:

ssconvert --export-type=Gnumeric_stf:stf_assistant -O "format=preserve" test.xlsx test.csv

Answer 2

Try to use sed:

sed -i -Ee 's#([0-9]{4})-([0-9]{2})-([0-9]{2})#\3/\2/\1#g' test.csv