Convert-to from csv to ods and viceversa [closed]

edit

I have this problem. A ".csv" file where delimiter is tab and content is a "Little-endian UTF-16 Unicode text" If i try to open it with gui in libreoffice my true settings are

Charset: Unicode Language: Default - English (USA) From row: 1 Separated by: tab, comma

via shel i'm trying

unoconv -f ods -e FilterOptions="59/44,34,UNICODE,1" [FILE]

but the result is a file with wrong separation. What's wrong?

And what's is the best shell command in order to convert this ods to file to a well generated csv (Unicode UTF8, comma separated, ecc.)?

I have tried to use LibreOffice from the Command line to convert from CSV file to Excel.While the software works great while using the GUI; it does not recognise Unicode characters, or semicolon delimited fields, and the output is only one chunk of data ( one column). How should I write my comenad line to let LibreOffice know I am using ";" as delimiter in a Unicode CSV file ? My command is: "C:\Program Files\LibreOffice 4\program\soffice.exe" --headless --convert-to xls --outdir "C:\DBA\scripts\CSV-to-Excel" "C:\DBA\scripts\CSV-to-Excel\CSV_file.csv" The output leaves a blank row in between two rows, and does not properly respect Unicode characters. The data ins left in only one column