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

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
ssconvert


Solution 1:[1]

Try to use sed:

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

Solution 2:[2]

This should be working:

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Adobe

Related Questions