3 ms·
I use LibreOffice calc every time I need to export an Excel spreadsheet as csv, because you can specify double quoted fields and you can specify UTF-8 encoding.
by outsideoflife 9y ago
I use LibreOffice calc every time I need to export an Excel spreadsheet as csv, because you can specify double quoted fields and you can specify UTF-8 encoding. I think this is a major use for LibreOffice, moving enterprise data into a web CMS. I work on a dataset with a lot of foreign characters and LibreOffice is my savior.
- tialaramex 9y agoGnumeric includes a tool named ssconvert that does this sort of thing from the command line, very handy. Gnumeric doesn't have the mindshare of Libreoffice but you may find this simplifies your workflow so I thought I'd mention. Edited
- Anthony-G 9y agoGnumeric also requires very little RAM or CPU so it's very light-weight compared to LibreOffice Calc. I don't use spreadsheets that often but when I do, it serves my needs adequately and it works with most of the keyboard short-cuts that I'm used to from Excel and LibreOffice Calc.