2 ms·
I use LibreOffice just for this purpose. ie Creating csv files from xls files. Open Excel file in LibreOffice Save as text >> UTF-8 >> quote all text cells. Wor
by garyclarke27 10y ago
I use LibreOffice just for this purpose.
ie Creating csv files from xls files.
Open Excel file in LibreOffice Save as text >> UTF-8 >> quote all text cells.
Works perfectly every time, Excel is brilliant for most things but is useless with csv, all kinds of strange bugs will arise.